SQL Server 2012 Diagnostic Information Queries (September 2012)

Here is the September 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...

SQLSaturday #171, Pittsburgh

Date: October 6, 2012
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was that...

Attendant’s checklist to a SQL Saturday event

Weeks Before The Event
Check for conflict in Schedule
Family Activities (Y/N)Business Appointment (Y/N)Other Commitments (Y/N)Plan the Trip
Distance (calculate travel time)Budget $ (Gasoline,...

After Seven Years, Time for Something New

Earlier this month, I passed the seven year mark at Digineer.  It was a weird feeling, since the last time...

Book Review: SQL Server 2012 Integration Services Design Patterns

This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...

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