(Pinal Dave) This is one of the features which I wanted to demonstrate to my clients while delivering my service Comprehensive Database Performance Health Check. So, while preparing for a demo I encountered a strange error.

(Jeremy Kadlec) Users are reporting issues accessing one of our critical production databases. I see that the database is not loading properly in the application and in SQL Server Management Studio.

(Pinal Dave) Some concepts are so good in SQL Server, they keep on coming back to me one way or another way. After reading my recent blog posts about CHECKPOINTS lots of people wanted to see the demonstration of the same.

(Hannes du Preez) Avoid using NOT IN whilst comparing nullable columns.

(Ben Richardson) SQL Server CASE statement is equivalent to the IF-THEN statement in Excel.

(Greg Robidoux) One of the main functions of a DBA is to maintain indexes. There have been several tips written about different commands to use for index rebuilds and index reorgs as well as the differences between index maintenance with SQL Server.

(Marcin Policht) While the most common methods of interacting with Azure Cosmos DB involve programmatic access, there are times when you might want to perform a quick change or take a peek at some of documents in a collection.

(Denny Cherry) There are people out there that love SQL CLR, and there are people that hate SQL CLR. I have a slightly different opinion, which is that I hate how most people use SQL CLR.

(Jack Vamvas) Question: Do you have a powershell script allowing me to dynamically create a drive – pointing to a network share , and then start an unattended install of SQL Server patching?

(Pinal Dave) Earlier I have written few blogs about automatic seeding feature. In this blog we would learn how to fix error: Automatic seeding of availability database ‘SQLAGDB’ in availability group ‘AG’ failed with a transient error.