TechNet Magazine: March 2010 SQL Q&A column

The March edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column.

This month's topics are:

Distributed transactions and database mirroring – why they don't work together
Background processes that can cause I/Os even with no connections to the server
How to restore backups from a file containing multiple appended backups
The perennial problem of production databases being too large to restore in development

Check it out at http://technet.microsoft.com/en-us/magazine/ff458345.aspx.

Leave a Reply Cancel reply

Other articles

Summer School Savings SALE is live!

Happy Fourth of July to all who celebrate! I’m looking forward to a great view Thursday evening looking west along the Skagit Valley with some

The Curious Case of… missing log information

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more

The Curious Case of… missing 832 errors during memory corruption

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more

The Curious Case of… recovering from a ransomware attack

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more

30%-off health checks and self-service via credit card – no waiting!

We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget

The Curious Case of…. alcoholism

Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve been an alcoholic. A maintenance drinker –

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.