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

SQL Saturday #53 – Kansas City Wrap Up

Another weekend, another new city, another SQL Saturday. This was my first trip to Kansas City, and it was a...

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

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

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

SQLSaturday #52 – Colorado Recap

I had the good fortune of being able to travel to Denver for SQLSaturday #52 the weekend of September 25,...

Maintain Change Data Capture Configuration when restoring a database

I have been working with a several clients that are leveraging Change Data Capture (CDC) as a tool for incrementally...

SQL Saturday #53 review

The KC PASS chapter has successfully executed the latest SQL Saturday.  Thanks to all the organizers and volunteers for a...