A DMV a Day – Day 8

We have two related DMVs for Day 8. The first one is sys.dm_fts_active_catalogs, which is described by BOL as:
Returns information...

A 96 hour meeting

I didn’t think about it this way, but it made perfect sense after I read an essay. Recently my team...

Test Driving a LinkedIn Poll

Had this on my list for a while, thinking maybe it’s a way to leverage the investment in my (your)...

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