Certificates of Completion for SQL Seminars

Most managers and employers distinguish between attending a conference and training. We (the royal SQL community we) offer quite a...

Change file logical name for mirror database

Today I encountered a interesting issue when rename logical name for mirror database.

We have a database which has been setup...

Conference in Florida: SQL Server Live

This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...

Detecting and Removing Duplicate Indexes

Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...

Interesting Culture

A post from Alex Maccaw, programmer at Stripe. He talks about some things he likes about the company, and overall...

Register for Sean’s Dallas precon!

On October 13, Dallas will hold our second ever Special Bi Edition of SQLSaturday Dallas - #SQLSat163 for you Twitter folk...

Sleepless in Seattle – SQL in the City 2012

A few years ago I went to Seattle a few days before the PASS Summit started. I took my middle...

Something for the Weekend – SQL Server Links 14/09/12

It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server Links,...

Surface Area Configuration tool available in SQL Server 2008 & onwards

Surface area configuration is a security measure that involves stopping or disabling unused components. Surface area configuration helps to improve security by...

The DevConnections Schedule is out

It’s preliminary, but the fall 2012 SQL Server Connections schedule at DevConnections is out. I’ll be speaking Tuesday, Oct 30,...