Working with the registry in SQL Server – adding trace flags to startup parameters

In a recent post, I introduced you to how to work with the registry directly from within SQL Server. Continuing...

A Trip Across the Pond for the Community Hub

The Redgate Community Hub is out, and people are starting to use it. It’s a an idea that we think...

DBCC CHECKDB Azure SQL Database

Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...

Checklist: DR Plan Sanity Check

If a disaster struck tomorrow, are you ready for it? Are you sure you thought of everything? I cannot count...

CISL 1.5.0 is released

I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released.

The biggest...

Truncate vs Delete in SQL Server: What’s the Difference?

I’ve been using TRUNCATE TABLE to clear out some temporary tables in a database. It’s a very simple statement to...

HTTP 403 error – PowerShell Remoting, Different Domains and Proxies

On my day to day work I use Nagios monitoring software. I want to add some custom SQL Server scripts...

Kerberos Explained - Taming the Beast: Kerberos for the SQL Server DBA

David has a talk that he delivers at SQL Saturdays, all about Kerberos authentication.  What it is, how it works...

Upcoming speaking events

Back in March I did my first “feature length” presentation at SQL Saturday Iceland
At that point I’d done a few...

DBCC CloneDatabase for SQL Server 2012

Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...