Seldom Used Indexes

On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then...

Get Free Learning

A couple of different events going on today and tomorrow:
Today (03/20) at 3pm CDT - "Choose Your Own Adventure: Performance Tuning"...

Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)

Free E-Book: Introduction to SQL Server 2012

Ross Mistry and Stacia Misner have again done a wonderful job on this free...

FILESTREAM and Snapshot Isolation Mode in SQL 2008

FILESTREAM and Snapshot Isolation mode are incompatible in SQL 2008.

In SQL 2008 R2 however...

http://msdn.microsoft.com/en-us/library/ms173763.aspx
In SQL Server 2008 R2, snapshot...

Powershell - Working with Cluster Resources - Byte Arrays

Over the next few weeks, I plan to share some of the discoveries I've had when working with Windows 2008R2...

SQL in the City: Free SQL Server Event in London

Red Gate Software has announced “SQL in the City: London,” to be held on Friday, July 13, 2012, at the...

Slides & Samples from my SQLSaturday #115 presentation about ColumnStore Indexes

As I have announced in my ColumnStore presentation last Saturday in Lisbon, you can
find here the slides
& samples for download....

SQL Server 2012: xVelocity

After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature...

Looking to Windows 9

I haven’t played with Windows 8 yet, and only a little with Windows Phone 7, but I am a little...

RYO Maintenance Plan – Integrity Checks

Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it...