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.
to SQL Server 2017. Into the unknown we go.
Continue reading →
Earlier this week I experimented, once again, with using temporary hash tables to speed up intermediate processing. Temp tables can be very useful for creating “optimizer fences” that serve to simplify queries to the point where the optimizer will consistently (more or less) come up with a good plan if … Continue reading →
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 →
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. … Continue reading →
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 →
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 →
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 →
Update: I have much more to report about the project, but I have to make choices between writing about it and developing, and right now the development work is taking precedence. Look for a new post soon. I hope. If this work sounds like something you might want to contribute to financially … 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 →