Search
SQL University
SQL University – Capacity Planning Week
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 [...]
SQL University – Indexing Week
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 things, [...]
SQL University – Advanced Troubleshooting Week
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. [...]
SQL University – Certification Week
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 [...]
SQL University – Database Design/Development Week
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 [...]
SQL University – Women in Technology Week
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 [...]
SQL University – Community Service Week
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. If you [...]
SQL University – HA/DR Week
I may be at TechEd this week, but that doesn’t excuse me from pitching in for SQL University. This week we are going to discuss the most critical function you have as administrators: your ability to recover from a disaster. Make no mistake, this is going to decide if you are able to keep your [...]
SQL University – Database Testing and Refactoring week
Welcome back to this week’s installment of SQL University. The topic this time around is a contentious one which is very odd to me. See, most everyone agrees that database testing is necessary, but there is a lot of disagreement on who does the testing, how the testing is to be done, and what is [...]
SQL University – Parallelism Week
I may be in the middle of a career makeover, but that does not excuse me from missing out on SQL University. This week we are going to talk about parallelism, an aspect of SQL Server that many DBAs have only a cursory amount of information.
tempdb
The first thing you need to do is to understand [...]
My Book
Categories
0 | Unique Visitors |
