Blog

SQL Query Processing

How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.


Restore and Recovery

The restoration process of a SQL Server database passes through two phases: Restore and Recovery.


Azure and M365 Fundamentals

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…


Writing T-SQL Videos

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…


70-765 SQL Admin Exam

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…


Enrique Lima Award 2018

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…


Official MBA Graduate

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.


College Update – Capstone Simulation

Sweet, finished the team portion of my Capstone Project. Now, just need to finish a consulting project and write 5 more papers. More updates to come on the tasks for the Capstone Simulation.


College Update: IT Strategic Solutions

Spent the weekend and today working on three of four papers needed for my IT Strategic Solutions class. The last one is definitely going to take a day or two by itself. Get that done and I’ll only have the Capstone project left. Update: I actually finished all four papers…


MBA Update March 2018

I have been procrastinating over the last month to get started on my Data-Driven Decision-Making course. My student mentor was starting to stress a little as I was getting behind on the official timetable for this term. But I knew I could knock out this task on a weekend once…