SQL Server 2016 brought several innovations. One of the most anticipated feature additions was the ability to define foreign keys with InMemory tables. I wrote about this feature earlier on blog at: SQL SERVER 2016 – InMemory OLTP support for Foreign Key.
SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword
Playing around with the new capability of SQL Server 2016 has been a fun journey. Even after a year, the discovery keeps happening every single day that I work with it. When I wrote the post around NULL values getting returned, lesser did I know there have been folks who work on this feature. Let us learn in this blog post about JSON NULL Value Using STRICT Keyword. Do make sure to read the other blog too:
SQL SERVER – Script level upgrade for database master failed – Error: 4860, Severity: 16, State: 1 – Cannot bulk load. SqlTraceCollect.dtsx does not exist
Of late, I have been contacted by few clients who have been facing issues with SQL startup failure after applying patch to SQL Server instance. This blog is an outcome of one such assistance provided. Here is a blog post where I discuss script level upgrade for database master fails.
SQL SERVER – SQL Installation fails with error code 0x851A001A – Wait on the Database Engine recovery handle failed
One of my client was trying to deploy his product on their test servers. They found that the SQL Server installation was failing with below error. Let us learn about error Wait on the Database Engine recovery handle failed.
SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database
SQL Server troubleshooting topics seem to be the most searched for in this blog. In continuation to this, blog for today is also inspired with one such error message. Some time back I have written below blog which talks about the upgrade script mode of SQL Server: SQL SERVER – Login Failed For User – Reason Server is in Script Upgrade Mode
SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key
Along with performance consulting, sometimes I also get requests from a few clients to look at the AlwaysOn availability group related problems.
SQL SERVER – Unable to Apply Security Patch – The setup has encountered an unexpected error in datastore
One of my clients reported that he is trying to apply security patch for SQL Server clustered instance and it was failing. Since this is SQL 2005 instance, there is no official support available from Microsoft at this point. So, they contacted me. I asked to share setup logs and found a very interesting note.