Welcome back to SQL University. This week the topic is capacity planning. As your DBA Coach it is my role to help you understand the different levels for the subject at hand. Capacity planning is a subject that applies to just about everything in life; how much money is left in your bank account, how … Read more
Welcome back to this week’s installment for SQL University. The topic this time is all about indexing. I know, I know. It sounds incredibly exciting, right? I mean, what could possibly be more exciting than a comprehensive review of a B-tree? Or a lively discussion about having a heap or a clustered index? Lots of … Read more
I have been working for Confio Software for almost six full weeks now. Two of those weeks I was on the road, which means I have been working at the office for the other four weeks. And by “at the office” I mean “the spare bedroom located next to my bedroom that was redesigned by … Read more
Welcome back to another week of SQL University. This week we will cover advanced troubleshooting. When I first started as a DBA “advanced troubleshooting” was something that you performed while someone else was on the other end of a phone line yelling at you for their own mistakes. Yeah, it really was that much fun. … Read more
Welcome back to the semester that never ends. Think of this as summer school. No, not because you need remedial training (well, some of you don’t, anyway), but because it is frakkin’ July and we are still in session. Just consider that you are getting ahead for next year, like the students I had during … Read more
Welcome back to another installment of SQL University. This week we will be talking about a topic that is often overlooked: database design. On second thought, “overlooked” may not be the correct choice. I think a more accurate description would be NULL. That’s right, I just said that database design is an unknown entity to … Read more
