Converting SQL Agent Job Duration to TimeSpan using PowerShell

When you look in msdb for the SQL Agent Job duration you will find that it is an int.

This is...

Emojis in SQL Server

I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures...

Future DBA part 2

I do not say you should be expert in other technologies but you should be aware of what it is...

Great Value IT Training - Awesome ITIL offers

This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have...

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...