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
This past weekend I took another trip up to Lake Placid. I wrote about my trip last year in a piece titled “Luck, Preparation, and Opportunity“, to this day one of my favorite blog posts I have written. With my upcoming job change the trip this year to Lake Placid seemed to be an opportune … Read more
I have written more than a handful of blog posts in regards to finding a job as a DBA. In fact, I have whole page dedicated to helping others land a job as a DBA. But I never put together a post on how to break up with your employer. That is, until now. This … 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
“Every new beginning comes from some other beginning’s end.” – Seneca, Roman philosopher In a time when people typically change jobs every few years, I recently celebrated my ninth year with the same company. For the last six of those years I have been a DBA. At first it was in a Junior position, then … 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
