How many mirrored databases can I have on a server?

 How many mirrrored databases can I have on a server?
10 mirrored databases per server is the recommendation for a 32...

Deleting Duplicates without a unique key

The following was sent to me by my friend and colleague Dave Miller:

Dave's Email:
Wanted to pass along something I hadn't...

What every DBA that manages a large number of SQL Servers should know about SQL 2008!!

Error when importing RegServer list from SQL 2005 to SQL 2008
I discovered the already known bug in SQL 2008 that...

How do I automatically respond to mirrored database failovers?

Automatic Failover - an incomplete solution
Automatic failover with Database Mirroring is great, but what about all of the other things that...

How do I .... grant access permissions for SSIS to users?

SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to...

I've got a date with an Error Log -- Error Logs Part II

Error Logs Part II -- Enumerating the error logs
In my first post on SQL Server Error Logs, I briefly mentioned using...

Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!

"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is...

Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!

Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...

The Shadow Knows What Procedures Lurk in the SQL Plan Cache

How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You...

Suggested Reading: Deadlock Notifications in SQL Server 2005

Here's a good article on setting up Deadlock Notifications in SQL Server 2005 written by Patrick LeBlanc.