(James Randall) This is something to be aware of as its effects can be very very subtle.

(blobeater) Would you like to troubleshoot a deadlock in Azure SQL Database? To do this you probably will be after the deadlock graph. So does this mean that you need to setup your own extended event session?

(K. Brian Kelley) My organization has multiple storage solutions with different models for the same vendor, and different models across different vendors. Each product has its own set of tools for monitoring and managing.

(Kenneth Igiri) Very recently, a colleague of mine came to me in desperation owning up that he had issued an update statement without a WHERE clause on a key application table.

(Pinal Dave) Recently I was delivering training on SQL Server Performance Tuning and during the session, I received a very simple question about the nonclustered columnstore index on a temp table.

(Kenneth Igiri) There are situations where a SQL Server databases is handed over to you and you find that the primary data file is unnecessarily huge.

(Pinal Dave) I really like my work as every single day I get to see different SQL Server and new interesting problems to solve when I work with Comprehensive Database Performance Health Check. Recently, while working with a client we noticed that they have a huge index with a first key column as uni

(blobeater) The Azure SQL Database service triggers an automatic failover after a failure is detected and the grace period has expired. What is the grace period?

(Rick Dobson) What are the different types of SQL Server user-defined functions? What are special syntax rules for creating and invoking each major type of SQL Server user-defined function?

(Grant Fritchey) Those my friends are, in my opinion, one of the single most wonderful things on earth, white chocolate macadamia nut cookies.