(Pinal Dave) In this blog post today we will see an interesting observation which is related to COUNT and FROM clause in a single query. During my recent Comprehensive Database Performance Health Check, this was brought to my attention by one of the attendees.

(Grant Fritchey) Why don’t “actual execution plans” have “actual execution plan costs”?

(Tibor Karaszi) This post is all about the tempdb database. It is not about capacity planning, like size or number of data files – there is plenty of info about that out there.

AD authentication is a popular mechanism for login and user authentication. It works very well in many scenarios, especially for enterprise applications. AD authentication is a supported scenario on SQL Server on Linux.

(James Serra) My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with a blog post about disaster recovery in Azure SQL Database. First, a clarification on the difference between high availability and disaster recovery:

(Manoj) Microsoft SQL Server is the most popular database management system, which provides flexibility to the database administrator to manage their database.

(Greg Larsen) Have ever tried to debug a chunk of TSQL code (like a stored procedure) and found yourself trying to figure out which TSQL statement is at a particular line number?

(Pinal Dave) During my free time, I do provide assistance to the community. Sometimes via forums, sometimes by giving a free session to local user group related to SQL Server. In this blog, I would share the steps to fox WMI error 0x80041017, Invalid Query.

(Michael Otey) SQL Server files can be stored outside of Docker containers in host directories or volumes. Here’s how to set up SQL Server on Linux databases and attach them to containers.

(Jovan Popovic) Azure Command Line Interface (CLI) is a command line library that enables you to quickly and easily work with your Azure SQL Managed Instances. In this post, you will see some basic CLI commands that can be used with Managed Instance.