"SQL Server Permissions and Security Principals" at SQLSaturday Charlotte This Weekend!

I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.

As a SQLSat...

#SQLSpeaking this Fall!

I have some great speaking dates coming up this Fall - here is the list:

--

First - the big one.  I am honored...

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