MSDB Job History Duration Conversion

Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...

Converting Dates to Integers

While working on a project recently, I came across a conversion that was trying to convert a date to an...

SQLRally Event Flyer is Ready

The SQLRally marketing team put this flyer together last week. We’ll be trying to get Chapters and SQLSaturdays to link...

SQL Server Database Maintenance Checklist

In this blog post, I continue my series of SQL Server Health Checklists that I am developing for a new...

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

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

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

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

SQL Saturday in New England

Adam Machanic (blog|twitter) has put on a SQL Saturday/Data camp event in New England for the last two years. I’ve...

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