megan – Page 2 – Sql2Go Consulting

ogr2ogr (GDAL 2.x) fails mysteriously

Posted on February 24, 2017 by meganFebruary 26, 2017

Update (2/26/17): It turns out that I did have uses for several of the GDAL 2.1 features, and there was a simple fix for the problem — switch to a different distribution. I tried the GIS Internals msi installer and everything worked the way it should.

“Proximity” Genealogy Database Project

Posted on February 14, 2017 by meganAugust 3, 2017

I am developing a proof-of-concept for a genealogical database intended to support querying for various proximities including Generational relationships (traditional family tree) Proximity of events in time and space (geolocation) Genetic proximity (DNA matching via SNPs) … Continue reading →

Migrating Sql2Go to new hosting service

Final update: the broken logo image is no more. I finally tracked the faulty html down to the Weaver Xtreme theme settings and removed it once and for all. Goodbye, little question mark.

Availability Groups: More Planned Downtime for Less Unplanned Downtime – Brent Ozar Unlimited®

Why I don’t do AGs (nothing against them; just not part of the service here)… Availability Groups: More Planned Downtime for Less Unplanned Downtime – Brent Ozar Unlimited®

Services Update

Services page updated with new services and availability.

SA Spoof | SQL Studies

Love this… This is nothing new but it’s still a fun idea. The problem: The vendor app we just purchased (and are told we must keep) requires the sa password. The vendor insists that sa is hard coded int… Source: SA Spoof | SQL Studies

SQL Server 2016 Report Designer always upgrades to 2016 RDL schema

Posted on June 28, 2016 by meganJuly 30, 2016

Update (7/25/16): You should be fine with older versions of Report Server and SSMS 2016/Visual Studio 2015/SSDT, if you do these three things: Set the appropriate compatibility level for deployment (TargetServerVersion) in the report project properties. Build the report project before deploying (this may also catch some kinds of errors). … Continue reading →

Window Functions and Cruel Defaults – Brent Ozar Unlimited® by Brent Ozar Unlimited®

Window Functions and Cruel Defaults – Brent Ozar Unlimited®

Fooled Again — SSRS 2012 auto-configuration

Posted on January 8, 2015 by meganJuly 30, 2016

It has been years since I tried selecting the RS 2012 option that automatically configures Report Server at installation time. I vaguely remembered that there was a good reason never to use it, but I felt like I needed reminding. And there was. … Continue reading →

Dealing with the Evil of FMTONLY from SSRS – SQLServerCentral

The weirdness of SSRS dataset stored procedure metadata, explained at last! I have fought this battle in the past and won, eventually, but it sure is nice if you know the enemy. “Evil” is no exaggeration. Dealing with the Evil of FMTONLY from SSRS – SQLServerCentral.

Sql2Go Consulting

MS SQL Server Database Development, Tuning, & Admin — Information Technology — Audio-Visual Systems

Author Archives: megan