How Silly

Have you ever done anything that made you feel like a dunderhead?  Maybe a little bone-headed, thick, numb-skullish?
Here is my...

How Do I Identify Invalid or Unneeded Logins?

Introduction
I was looking at one of my servers and was caught off-guard by how many individual users had been granted...

SQLSaturday Orlando 2010 - The Planning Begins

Believe it or not, it's already time to start planning for Orlando's next SQLSaturday.  Andy Warren and I had our...

2010 Goals – First Quarter Review

Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.

Community...

Use a Clustered Index

I stumbled across this clustered index test from Hugo Kornelis recently from a post in the forums. I think I’d...

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