megan – Page 2 – Sql2Go Consulting

STRING_SPLIT and SSDT do not mix

Posted on February 24, 2017 by meganApril 11, 2017

Update (3/28/17): As a simple workaround, I added a string split UDF that does the same thing (only much more slowly). If I need to compile the DB project, I replace the intrinsic function with the UDF in the two places it is called. Otherwise I switch back to the … Continue reading →

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 →

Sql2Go Consulting

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

Author Archives: megan