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 →Category Archives: Development
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 provides a fix. (Removing and re-installing Web Deploy on the server might also work.)
Continue reading →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 →
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 →
‘Proximity’ Genealogical Database Project Update
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 →
“Proximity” Genealogy Database Project
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 →SQL Server 2016 Report Designer always upgrades to 2016 RDL schema
Update (7/25/16): You should be fine with older versions of Report Server and SSMS 2016/Visual Studio 2015/SSDT, if you do these three things: Set the appropriate compatibility level for deployment (TargetServerVersion) in the report project properties. Build the report project before deploying (this may also catch some kinds of errors). … Continue reading →