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…
Explore SQL Server Page Types and their roles in optimizing performance and managing data storage within your database.
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.