SQL University Starting Back Up

Jorge Segarra's ( @SQLChicken) excellent community idea, SQL University, is starting back up next week. This is effectively free training on...

What Do I Need to Do After Moving a Database to SQL 2005/2008?

Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...

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

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

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

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

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

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

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

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