(Greg Larsen) If you have been a DBA for a while you have probably gone through at least one migration to a new version of SQL Server, or maybe even more than one migration.

(Pinal Dave) When I work with Comprehensive Database Performance Health Check, I get all sort of questions and I love answering them. Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.

(Rajendra Gupta) This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics.

(Chris Webb) In part 1 of this series – which I strongly recommend you read before reading this post – I showed how removing columns from a table can make a dramatic improvement to the performance of certain transformations in Power Query.

(Hannes du Preez) You never know what can happen when you attempt to delete data. Some may argue that it is best to delete data through a client application, some may say it is better to do so through SQL Server itself, by using SQL code.

(Rakesh Patil) When a SQL Server query executes, there are specific steps that are taken before the query is executed.

(Daniel Neumann) Earlier this year I had written a blog post about updating the VMSS base image of an aks-engine cluster.

(Pinal Dave) As they say, there are many ways to bell a cat. But in my consulting career, I have seen the same error due to multiple causes.

(Amit Bansal) In this video, you will see how you can find the elapsed time in milliseconds since SQL Server process started.

(Grant Fritchey) I love going to SQLSaturday events because I’m always asked questions that make me think.