In the month of January, I offered exclusive training to my newsletter subscribers. The training was extremely unique and was available for a limited time. Quite a lot of newsletter subscribers took advantage of this limited time offer of “SQL Server Performance Tuning Practical Workshop”.
SQL SERVER – Error Msg 10778, Level 16 with InMemory OLTP
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:
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.
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 – Using dm_db_stats_properties With InMemory OLTP Tables
The whole concept of InMemory OLTP has been around for a while and still there are areas that I try to go back to learn every single time. If you are new to InMemory OLTP, I would highly recommend searching this blog for more content. For a starter, the blow blog is a great start.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.