Welcome to Megan’s Sql2Go.com. You’ll find a brief introduction to me and this website here.
See the Services and About pages for information about my availability and services offered.
Comodo SSL Organization ValidatedBundlerMinifier.Core quits working after Visual Studio 2019 update
Earlier today I was doing some final testing in preparation for a production release, and I happened to notice that one of my bug fixes was somehow no longer fixed. A JavaScript method was failing when called, and it was failing because it was the pre-fix code that was broken to begin with. (It’s what happens sometimes when I code into the night — the original bug, that is.)
Continue reading →.Net Core 3.1 Azure App Service startup exception: System.IO.DirectoryNotFoundException
It has been a couple of years since I posted here, time spent developing and testing code rather than writing about it, but this bug brought me back to the blog. As it happens, it has also been a couple of years since I published and tested an Azure App … Continue reading →
Link: WDeployConfigWriter Account Issues
I’ve been using MS Web Deploy for several months to publish changes to the ASP.Net Core Razor Pages application that I am developing. The other day Web Deploy quit working, and I’ve spent more hours than I could count trying to find out why. This blog post explains it and … Continue reading →
Specifying Schema Names in Entity Framework Core Code-First Models
This seemed like such a simple thing, and it turned out to be, but I couldn’t for the life of me find a simple explanation by searching. I am building my first ASP.Net Core Razor app using .Net Core 2.2 and EF Core, and my database uses schema names other … Continue reading →
SQL Server SP or CU upgrade script failures — Do WHAT to my master database?
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 … Continue reading →
Migrating…
A heap of trouble
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 →
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 →
New DelimitedTextCleaner library available on github
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 →
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 →