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 … Read more
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 … Read more
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 … Read more
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 … Read more
Welcome back to SQL University! This week I am going to step *way* outside my comfort zone and talk about SSIS. I am not embarrassed to say that I have little to no practical experience as an SSIS developer, I simply have not had the need to play with SSIS to the extent that I … Read more
Welcome to another week of SQL University. This week’s discussion will revolve around the various tools we use in order to get our jobs done. We all have our favorite weapons of choice for various tasks and I will do my best to walk you through what I feel is a natural progression for DBAs. … Read more
