Restore database permissions

Introduction:
I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+...

sp_Blitz, v16, on SQLServerCentral

Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and...

Speaking at Midlands PASS in February

On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...

SQL Server Virtualisation and Consolidation

Come and join me in London this March for a 3 day course on SQL Server virtualisation and consolidation.The course...

Talking on Purpose

Last year I stepped into the intimidating (and slightly effervescent) waters of the consulting world, and found great success. This...

Try a Database Design Exercise At Your Next SQL User Group

Tried something different for the January 2013 meeting of the Baton Rouge SQL Server User Group (brssug.org), which meets every...

#SQLMaiden 2013 dates

Some time back at a SQL Server user group in Southampton I was speaking to an MVP called Simon Sabin...

1000 Views on 26 Blog Posts – Thanks a Ton

Thank You all for your support to give me inspiration . It is the result of this that I have achieved...

A Learning Experiment

I’ve been looking for ways to improve the way I do my job, which is mostly writing and editing, but...

A Rickety Stairway to SQL Server Data Mining, Algorithm 1: Not-So-Naïve Bayes

            Thankfully, the simplest of SQL Server’s algorithms is not quite as naïve about data mining as I am.

            As mentioned...