Taking a Medical Approach to Performance Troubleshooting

I find it difficult sometimes to explain to someone how to have a take a good approach to performance troubleshooting. I had the stomach flu a few weeks ago, and the same day I visited my doctor, there were many people trying to… Read more

 Are you a DBA? You might Be!

On Twitter, people do a lot more than gossip and post messages about mundane, trivial tasks. As DBA’s, we help people having problems (#sqlhelp), we have in-depth discussions, we promote upcoming events (#sqlpass, #sqlsat43, #sqlcruise, etc.), we… Read more

Study Tips for the SQL MCM Exams

I met the new rotation of the SQL Server Certified Master program on Friday. I was supposed to meet them the week before, but I decided to keep my stomach flu to myself, so I waited for this week. I offered up some… Read more

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

Lately I’ve noticed an increasing number of people recommend increasing worker threads. The reasons for the recommendations include things as simple as a troubleshooting step for reports of general system slowness or as complex as a means to… Read more

Question: Is Mirroring Supported by MS Access front-end?

The following question was posted on a SQL Server discussion group. My reply follows.

Is the MS SQL Mirroring supported by MS Access Frontend (.adp) ?

We have MS SQL Server 2008 Developer Edition.
The Mirroring is configured and works… Read more

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

I just want to pass along a few updates on the SQL Server 2008 MCM. A new MCM class is starting up next week, and I'll be paying them a visit. Two more candidates… Read more