NO DEK Update for File ID
Since installing SQL Server 2019 CU9, I have been getting lots of errors about NO DEK Update for almost every file. Here is an excerpt… Read More »NO DEK Update for File ID
SQL Server
SQL Configuration Manager Missing
On a number of recent installs of SQL Server that I have worked on, I have noticed that the SQL Configuration Manager has been missing… Read More »SQL Configuration Manager Missing
Performance: Faster way to concatenate longer string
After my post yesterday on the performance implications of concatenating long strings with the + operator and the CONCAT function, today I am following up… Read More »Performance: Faster way to concatenate longer string
January 2021 Security Patch for SQL Server
Microsoft has recently released a security patch for all supported version of Microsoft SQL Server. These updates are fixing where an elevation of Privilege vulnerability… Read More »January 2021 Security Patch for SQL Server
2020 Blog Post Summary
Babelfish for Aurora PostgreSQLDecember 1, 2020Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of… Read More »2020 Blog Post Summary
Babelfish for Aurora PostgreSQL
Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of SQL Server to PostgreSQL or… Read More »Babelfish for Aurora PostgreSQL
DBCC Shrink Fails with Error
Recently when shrinking a SQL Server data file, I ran into the following error: File ID 3 of database ID 15 cannot be shrunk as… Read More »DBCC Shrink Fails with Error
Configuring The Distributed Transaction Coordinator
When building out a new SQL Server to replace an existing SQL Server, the previous system may have been using DTC or the Distributed Transaction… Read More »Configuring The Distributed Transaction Coordinator
Iterating over JSON and XML values
One handy thing when working with JSON or XML is to take part of the data and represent it as tabular data, since everything in… Read More »Iterating over JSON and XML values
Weekly Summary July 4, 2020
Here is a recap of my last week of posts. Accessing XML and JSON contentJuly 3, 2020 Building on my earlier post of JSON and… Read More »Weekly Summary July 4, 2020