"SQL Server Permissions and Security Principals" at SQLSaturday #560 Charlotte 2016

I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by...

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

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

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

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

Restoring Azure SQL Database

A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering...

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

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

#SQLSpeaking this Fall!

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

--

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

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