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
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
Welcome back to SQL Univeristy. The topic this week will be on women in technology (WIT). I first heard about the WIT in general because of my involvement with PASS. My reaction to hearing about the WIT was something similar to “what about the men in technology?” (I had the same reaction to a “mothering … Read more
Welcome to this week’s installment of SQL University. For this edition of I am going to focus on serving the SQL Community, but feel free to perform any acts of community service you desire (especially those that are court-ordered). tempdb The first step you need to take is to be aware of the SQL Community. … Read more
