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 doing a great deal of refactoring as I discover, bit by bit, how to usefully apply a relational database system to solving difficult genealogical problems.
Logging in Maintenance Plans – SQLServerCentral.
Why Local Variables are Bad for Tuning Stored ProceduresBrent Ozar Unlimited®.
TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask.
The Performance of Traversing a SQL Hierarchy.
Myths and Misconceptions about Transaction Isolation Levels – SQLServerCentral.
SQL Server XML Questions You Were Too Shy To Ask.
The LookupCTE trick described here is pretty slick. These days I find myself working with large databases where these things really matter and I found this post quite interesting. Improving Query Performance by using correct Search Arguments – SQLServerCentral.
Why every SQL Server installation should be a cluster – SQLServerCentral.