SQL Saturday New England: The Date

Mark your calendars. Make your travel arrangements. Plan on being in the Boston area on April 16th, 2011. Three of...

SSC Editorial – Great Service

I wrote the editorial about great service after noticing a couple small but interesting customer service experiences during two trips....

SSWUG Fall 2010 Virtual Conference This Month

Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up.  On October 20-22, you can attend a conference from...

Tip: OVER and PARTITION BY

Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…

OVER
OVER allows you...

CPU-Z Support For Sandy Bridge Processors

The CPUID website has a screenshot of CPU-Z 1.55.2, showing its support for the upcoming 32nm Sandy Bridge processor, which...

Drawn By the BI Sirens

Patrick Is the lead Singer
Sirens. Their sweet songs lured sailors to their deaths in tales of yore. Alas, I too...

Four Year IT Degree Approved for Seminole State College

Back in 2007 when we started SQLSaturday we had the good luck to leverage an existing relationship between Seminole Community...

How to Tell if Execution Plans are Reused

I try to watch the search phrases that point people to the blog because sometimes, you get a sense of...

Notes from SQLSaturday #48

I drove up on Friday, just under 7 hours with a couple quick stops on the trip. Listened to Team...

Return of Index Analysis

Now that I’ve finished going through some of the details for sys.dm_db_index_operational_stats, it’s time to take that information and incorporate...