Advanced Troubleshooting Week at SQL University, Lesson 2

Welcome back to Advanced Troubleshooting Week at SQL University. I’m your guest professor for this course and today I will continue talking about Advanced Troubleshooting. I’m delighted to see that everyone returned safely from their battle with those dastardly Nargles. Nargles are actually fairly innocuous once you learn their weaknesses. Let’s move on to something a little fiercer … grindylows. Grindylows are those nasty little water demons who trick SQL Server into performing a table or clustered index scan even
read more

Advanced Troubleshooting Week at SQL University, Lesson 1

Advanced Troubleshooting Week at SQL University, Lesson 1 Welcome to Advanced Troubleshooting Week at SQL University. Once again, I’m your guest professor for this course and today I will be talking about Advanced Troubleshooting. Being a Harry Potter fan, I’m subtitling this week’s lessons as @SQLSoldier‘s Defense Against the Dark Arts. In this case, the dark arts would be poor performance. Unfortunately, I won’t have any magical tricks to teach you. Just solid techniques for finding performance problems and fixing
read more

Degree Seeker Week at SQL University, Extra Credit

Degree Seeker Week at SQL University, Extra Credit Welcome back to Degree Seeker Week at SQL University. If you have returned for this extra credit session, you are truly an eager learner. I’m your guest professor for this course and today I will be presenting a lesson on non-SQL Server skills that will make you a better DBA and to what certifications those skills can roll up. Most DBA’s perform other duties from time to time. Some of us find
read more

Degree Seeker Week at SQL University, Lesson 3

Degree Seeker Week at SQL University, Lesson 3 Welcome back eager learners to Degree Seeker Week at SQL University. I’m your guest professor for this course and today I will be presenting Lesson 3, Advanced SQL Server certifications. The advanced certifications consists of the Microsoft Certified Master program and the Microsoft Certified Architect program. We will take a look at what these certifications mean, how to prepare for them, and how to succeed in the programs. Hopefully you read the previous
read more

Degree Seeker Week at SQL University, Lesson 2

Degree Seeker Week at SQL University, Lesson 2 Welcome once again eager learners to Lesson 2 of Degree Seeker Week at SQL University. I’m your guest professor for this course. I’m a little late getting to class today as I spent a large part of today fighting failing hard drives and allergies, but let’s get class started. Today’s lesson will investigate the Specialist and Professional series of certifications for SQL Server. We’ll delve into the various tests required for each
read more

Degree Seeker Week at SQL University, Lesson 1

Welcome eager learners to Lesson 1 of Degree Seeker Week at SQL University. I’m your guest professor for this course, and I will try to guide you through the various certification tracks for SQL Server available through the Microsoft certification program. This class is divided into three lessons. You will find the course syllabus below. Accordingly, as the lessons progress, the skill level will advance as well. Lesson 1: Introduction to Microsoft Certification for SQL Server (level 100) Lesson 2: Becoming a Microsoft Certified IT Professional (level 200), Wednesday, July 7, 2010 Lesson 3: Seeking Advanced Microsoft Certification (level 500), Friday, July 9, 2010 Lesson 4: Extra Credit – Non-SQL Server Skills for DBA’s, Saturday, July 10, 2010
read more

Extracurricular Activities

Extracurricular Activities Recently I presented two sessions at SQL Saturday #43 in Redmond, WA. The night prior to the event, many of the presenters had dinner together at Red Robin Gourmet Burgers in Redmond. One of the other presenters asked me why I was presenting. He wanted to know what I was promoting. In truth, I wasn’t promoting anything. My reply was, “Well, I guess I just enjoy doing it.” I wasn’t promoting a book (though I had one come
read more