SQL Query Processing
How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.
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.
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.
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…
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…