More PowerShell for the Azure World

The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...

Quick #SQLPrompt Tips – Expanding Wildcards

I tend to try and get code on the screen quickly and then start to remove things. I’m a visual...

Splitting CSV strings in SQL 2016

Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...

Sql Server - Detecting and Monitoring Memory Pressure

Introduction - Detecting and Monitoring Memory Pressure 

I will be writing this article in four parts because this
topic is huge and amount...

Challenge Accepted

My life for the last 2 years has been a constant battle of putting out fires with system performance; finally...

DBCC CHECKFILEGROUP

Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...

Future DBA Part 1

As I stated in my earlier blog on future DBA, we should learn many things as we can to be...

PowerShell to create Azure SQL DBs

Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So...

SQL Saturday Minneapolis Precon – Complete Primer to SQL Server Virtualization – Coming Soon!

This is just a quick reminder to encourage you to attend my next round of all-day precon training session at the...

SQL Server Execution Plan formats

Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor. In SQL...