Open Source PowerShell – Play by Play

What’s going on here? So last week you may have seen this picture on Twitter…it went a little crazy…and you may have been wondering what are we up to?...

SQL Sentry Plan Explorer is now free

You’ll probably hear about this from other sources, but an announcement made this morning bears repeating: One of my favorite...

TGI SQL Friday - 16th September 2016 Weekly roundup

I have had an interesting week teaching Learning Tree course 534 Developing SQL Queries for SQL Server. I had an...

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