(Chris Webb) I’ll admit that I’m a bit less excited about Excel dynamic arrays than I was when I last blogged about them.

(Kenneth Fisher) If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain if you have to pass a value in for each of them.

(Alejandro Cobar) Knowing the configuration of your SQL Server instance is key to determine if it is patched, how much memory has been allocated for SQL Server, parallelism settings and more.

(Grant Fritchey) The more you work with containers, the more you just want to work with containers. However, there are still reasons to have a virtual machine for some types of workloads.

(Denny Cherry) The recent announcement that VMware will be available within Azure makes for a really interesting announcement. It brings a great on-prem solution (VMware) that the admin teams already know and use extensively, into the Azure Cloud.

(Paul White) In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join.

(Pinal Dave) Today I am going to share a story of my client who has hired me over 7 times for my most popular consulting service Comprehensive Database Performance Health Check for different servers and situations. In the latest engagement, we had a very interesting situation of Performance Impact o

(Rajendra Gupta) This article gives an overview of the SQL DROP TABLE statement to remove one or more tables from a database.

(Kenneth Fisher) I’m sure lots of you have used the function RAISERROR to handle an error caused by your code.

(Aleksejs Kozmins) Transferring SQL Server data from a source database with numerous data tables with time and system resource limit is a very common issue.