There is a failure pattern for SQL Server service pack and cumulative updates that I had somehow not encountered up until now. The SP or CU runs various upgrade scripts while it is doing its thing and, rarely, one of these will fail due to something that is different about that particular server.
Category Archives: SQL Server
Migrating…
to SQL Server 2017. Into the unknown we go.
Continue reading →
Adam Machanic : Uniquely Identifying XML Nodes with DENSE_RANK
I came across this post today from 2009 that solves a problem I have been having with SQL Server XML shredding, and I thought I would pass it along in case anybody else has managed to miss it for as long as I have. When working with XML in SQL … Continue reading →
GedcomReader library fails while reading FTM 2017 GEDCOM export
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 →Deployment fail at MacKiev/Ancestry.com
Update: It shipped! It shipped!! Less than four months late! That’s not too bad in this industry. 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 … Continue reading →
STRING_SPLIT and SSDT do not mix
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
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.
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.
Continue reading →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®
Continue reading →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
Continue reading →