Setting DBCC 1222 on startup

The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)
However, once the SQL instance is restarted this...

Migrating to Azure SQLDatabase

Right now one of the hottest topics around the world is the cloud and the successful methods for the migration...

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