Presenting Banish RBAR! at Richmond SQL UG

On Thursday, Sept 8, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Richmond SQL Server User Group....

Presenting at Curacao SQL UG

On Thursday, Sept 1, 2011 at 7:15pm EST, I’ll be presenting via LiveMeeting to the Curacao SQL Server User Group....

The OVER Clause enhancements in SQL Server code named “Denali”, CTP3

A look at how the OVER clause is changing in SQL 11, based on the CTP 3 released to the public.

Running totals in “Denali” CTP3

One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause....

ORDER BY Clause with clustered index

One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index...

Contained database temporary tables

Logged Operations

Contained database users

Nested Temporary Tables

Setting SQL Server Default Locations

How to set the default locations for backups, data files, and log files in SQL Server.