You Need Three Heads To Read This Post Properly

CXPACKET waits - You Need Three Heads To Read This Post Properly

I have a handful of things to share today. As a DBA it is my nature to be both driven and lazy so instead of three posts I am just going to combine them into one. You’re welcome. Here’s the first item for you: Recently Grant Fritchey (blog | @gfritchey) wrote an article titled “Be Cautious Offering Guidance”. The point … Read more

The Accidental Architect

Most readers of this blog are likely to be familiar with the term accidental DBA. It is meant to describe someone that ended up in the role of database administration by pure chance. They simply happened to be in the right place at the right time (or right place at the wrong time). I even wrote a book … Read more

Database Filegroups: Just Like Seatbelts But With Less Chafing

Years ago I left school after getting my graduate degree in Mathematics and got myself a real job, you know the one that had things like a pension and health insurance. Since it was only the cost of a co-pay I decided to visit a doctor to have a physical done because, well, isn’t that … Read more

March Madness – SQL Azure – Summary Review

Today is the final day for my SQL Azure blog series. These past few weeks I have been able to spend a lot of time with SQL Azure. The platform has come a long way in the two years time since I first started using it and doing presentations. I am very impressed with many … Read more

March Madness – SQL Azure – Wait Events

Yesterday we discussed one way to improve query performance in SQL Azure by making sure your statistics are kept up to date. In today’s penultimate post we look at another way to get information about your queries in SQL Azure: wait events. One of the first things I noticed that was missing from SQL Azure … Read more