Indexing Just Got Easy

As a database professional one of the things that we should be familiar with is the use of indexes.  In SQL Server an index helps to improve query performance...

Indexing Just Got Easy

As a database professional one of the things that we should be familiar with is the use of indexes.  In...

Powershell Day 1

Day 1 Introduction to Powershell I got inspired by great people like Paul Randal and Glenn Berry and decided to...

Reflections on Dev Connections / SQL Connections

When SQL Connections in the spring was announced, the folks at Red Gate and SQL Server Central reached out to...

SQL in the City: Free SQL Server Events in London and Los Angeles

Red Gate Software has announced two free, full-day SQL Server events, called “SQL in the City”. Both events will provide...

SQL Saturday 63 Dallas: EPICITY

SQL Saturday 63 Dallas. Will. Be. Epic.
Here are my proofs:
The Schedule. Note the gelato breaks. It is impossible to get...

SQLSaturday#71 is only a day away! - Final Schedule....

Just a final note for all of you planning on attending tomorrow's SQL Saturday #71 event extravaganza up in Boston.  The event...

SQLServerCentral.com Track at Orlando SQL Server Connections

This past week, about 1,200 developers, IT professionals, and DBAs spent three days attending DevConnections at the J.W. Marriott Resort...

Word Macro to load a Data Warehouse

Recently I came across a very specific requirement for a Data Warehouse project for one of our customers. Due to...

Change SQL Startup Parameters with PowerShell

Backups Abound

The Annoyance
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...