This isn’t my first time in California, but the first time outside the airport. I got to spend the first week of December 2019 in San Francisco teaching a SQL Server Performance Tuning and Optimization course. This is quickly becoming my favorite workshop to teach. What makes this class unusual…
What an amazing two weeks that started in Orlando for MCT Day the Saturday before Microsoft Ignite, then a quick trip to Seattle for the PASS Summit, and then finally to Kansas City to teach a dedicated SQL Performance Tuning and Optimization workshop. MCT Day: As you can see above,…
I just realized that I have not written a blog post since the beginning of May. Instead of backfilling let’s just start again here towards the end of September. First, the big news. After 17 years as a Senior Technical Instructor for New Horizons, I made the decision to make…
How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.
Yes, I have been slacking a little on the certification exams. But I’ve been a little busy the last couple of months. I have plans to add many of the new role based certifications to my list once the Microsoft courseware comes out. But in the meantime, I did pass…
In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…
I finally passed the 70-765 exam. This finished up the MCSA: SQL 2016 Database Administration certification and also re-earned the MCSE: Data Management and Analytics certification for 2018. I will say that this exam was not easy. The questions themselves are not that bad, but just the sheer amount of…
Completely shocked, surprised, and speechless to be awarded the annual Enrique Lima – MCT Community Service Award for 2018. The award was presented by Allison Kraker (MCT Program Manager) during the MCT Day right before the start of Microsoft Ignite. This is an incredible honor to be chosen by the…
18 months and a lot of long weekends and I’ve finally finished my Master of Business Administration: IT Management Degree. I am definitely taking some time off from studying after these last few months of finishing the capstone project. Thanks to everyone who helped me along the way.