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

Slides & Samples for my SQLbits workshop & session

As announced in my SQLBits workshop & session last week in York/UK, you can find the
session/workshop material here.

Have fun!

-Klaus

SQL Lunch One Year Anniversary

I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...