Using Logins and Certificates to evelate Permissions

Problem

A common question I get asked by SQL developers is to be able to query the sys.dm_db_index_usage_stats table to see...

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