Interesting Case of SSIS Failures

Interesting Case of SSIS Failures
We had an interesting case of SSIS failures recently where the cause ended up being improved...

T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2

T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2

This blog entry is participating in T-SQL Tuesday #007, hosted...

Taking A Medical Approach to Performance Troubleshooting

Taking a Medical Approach to Performance Troubleshooting
I find it difficult sometimes to explain to someone how to have a take...

Are you a DBA? You might Be!

 Are you a DBA? You might Be!
On Twitter, people do a lot more than gossip and post messages about mundane,...

Study Tips for the SQL MCM Exams

Study Tips for the SQL MCM Exams
I met the new rotation of the SQL Server Certified Master program on Friday....

Database Mirroring FAQ: Is Mirroring Supported by MS Access front-end?

Question: Is Mirroring Supported by MS Access front-end?
The following question was posted on a SQL Server discussion group. My reply...

The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads

The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...

A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s

 A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...

Undocumented Capabilities of Extended Event Objects

Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...

Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008

Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
 
One of the features of SQL Server 2008 that...