In this blog post, I share how I prepared for the exam and what my experience was like on the day of the exam. While I only shared my updated goals last week, I spent weeks before that focused on studying. More importantly, I have had real experience working hands-on in projects for several years. Without this experience, I don’t think I would have been able to pass this exam – at least not on the first attempt.
By then, my goals had changed. Varigence had announced the BimlHero Certified Expert program, and I decided to put the MCSE on hold for a while. Sorry, Microsoft, Biml was just more fun! :) In February 2016, after 10 months of working on the Biml certification, I became the second BimlHero in the world.
My plan was always to resume studying for MCSE: Business Intelligence. But, surprise surprise, things changed again. My new jobs required a lot of traveling, and I even put tech on hold for over a year while working in a community-facing role. I challenged myself in different ways by speaking and delivering workshops. In short, I chose to focus on developing other skills.
We are now almost halfway through 2018 and I am finally ready to continue working towards my next Microsoft Certification. Except for the tiny little detail that I was so slow that the certification I originally set as my goal no longer exists. Hahaha! :) Instead of the old MCSE: Business Intelligence, my updated goal is…
One of the sessions I was most looking forward to at Microsoft Ignite 2017 was New capabilities for data integration in the cloud with Mike Flasko. In that session, he talks about Azure Data Factory (ADF) v2 and its new first-class SSIS support.
After the session, I convinced Mike Flasko and Sanjay Krishnamurthi to have a chat with me :) We talked about what’s new in Azure Data Factory v2, including the updated pipeline application model with a new visual design canvas, new Software Development Kits (SDKs) for working with Azure Data Factory, the new Integration Runtime, and the ability to run SSIS packages inside Azure Data Factory v2.
Azure Data Factory v2 with Mike Flasko
Follow Mike Flasko on Twitter @mflasko, and keep an eye out for more news about ADF and SSIS! I may or may not have convinced him to do another interview with me in a couple of months :)
At Microsoft Ignite 2017, I had planned an interview with Sunil Agarwal, and was very excited about it. Then Sunil asked if he could bring Kevin Farlee. Of course! Then he asked if he could also bring their customer, Aaron Gerdeman from FIS. Even better! :)
In this interview, we chat about SQL Server 2017, Resumable Index Builds, Adaptive Query Processing, Columnstore Indexes, High Availability, Real-time Analytics, Real-time Dashboards and the SQL Tiger Team.
High Performance Analytics with Sunil Agarwal, Kevin Farlee, Aaron Gerdeman
I know Bob had a very busy schedule at Microsoft Ignite, so I’m very thankful he was able to spend a few minutes with me! I hope you find this as interesting as I did :) If you want to learn even more, you can watch his session Experience Microsoft SQL Server 2017: The fast and the furious from Microsoft Ignite 2017: