Welcome to Megan Brooks’ Sql2Go™.com. You’ll find a brief introduction to me and this website here.
I have released a small, free, C# single-class library that can be used with SSIS or in other environments to parse CSV and other similar delimited text formats (such as tab or pipe delimited), and to do so with some tolerance for errors in the use of double quote characters. The repo can be found on github.
While testing Family Tree Maker 2017 (FTM), I happened to notice that GEDCOM imports for my Proximity Database project had ceased to work. At first I suspected FTM, but the output was fine and it was a complete mystery why the imports were failing. … Continue reading →
There is an ongoing deployment-gone-wrong story involving SQL Server and about which I have heard nary a word on the SQL Server blogs. While it looks a lot like a classic, doomed-to-failure approach to deployment, surely there are lessons to be learned somewhere. … Continue reading →
Pieces of my Experts Exchange badge (left column on the home page here) keep dropping off. Am I losing skills as I grow older? (Update: I must really be losing it. I misspelled “losing.” Fixed now.) (Update to update: I refreshed the badge script and the widget looks much better … Continue reading →
The Proximity project is coming along. I have successfully loaded a large family tree from a GEDCOM file and a very large set of pedigrees downloaded from Ancestry DNA using DNAGedcom.com. Name, place, and date parsers are working reasonably well, although there is considerable room for improvement. I have been … Continue reading →
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 →
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.
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 →
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.
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®