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
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 [...]
SQL University – Powershell Week
Welcome back to SQL University. This week we are going to talk about Powershell and how you can win the lottery. Wait a minute…apparently Powershell and Powerball are two different things altogether. One of them requires you to spend many hours learning how to work a system that can ultimately make your life richer and [...]