New MSSQLTips Article: Nesting Database Roles in SQL Server

I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...

A DMV a Day – Day 7

I have three different DMVs for Day 7. The first one is sys.dm_db_missing_index_group_stats, which is described by BOL as:
Returns summary...

Catching Transient CPU Spikes Using SQL Trace

Catching Transient CPU Spikes Using SQL Trace If there was one thing I wish everyone who works with SQL Server would...

LV April SQL Users Group Meeting

S3OLV or SSSOLV will be holding our meeting Thursday April 8th.  The User Group is in affiliation with PASS and...

24 Hours of PASS Registration Now Open

Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00...

IP and Default Trace…T-SQL Tuesday #005 - A week early - D'oh

As chance would have it, I had been checking Adam’s blog daily for the last few days to find the...

Is Anybody Using That Stored Procedure?

Introduction
From time to time I get asked to check if a stored procedure is still used in preparation for dropping...

Swing and a Miss

I missed my first newsletter today. It wasn’t until I went to schedule tomorrow’s that I realized I hadn’t sent...

SCSUG April Meeting Reminder

A reminder to anyone in the Brevard County Florida area:

 
The SCSUG monthly meeting is at 6:30 on Thursday, April...

24 Hours of PASS v2.0

The kids over at the Professional Association of SQL Server Users have done it again. They’re hosting 24 Hours of...