Skip to content

Interview about Azure Data Factory Updates

Last year at Microsoft Ignite, I was fortunate enough to interview Mike Flasko and Sanjay Krishnamurthi. This year, I got to have a follow-up chat with Mike Flasko and Sharon Lo! We talked about the recent and upcoming Azure Data Factory updates :)

In this interview, Mike and Sharon share the highlights from their session at Microsoft Ignite 2018. What are visual Data Flows? How are Azure Data Factory Data Flows different from the recently announced Power BI Dataflows? What’s on the Azure Data Factory roadmap? And finally, how can you provide feedback and get involved in private previews?

Azure Data Factory Updates with Mike Flasko and Sharon Lo

(I apologize for the unsteady video :( Unfortunately, I didn’t see how shaky it was until post-production. If it gets too distracting to watch, please just listen. Mike and Sharon share a lot of interesting things :) )

Thank you so much to Mike and Sharon for chatting with me on a busy day!

Continue reading →

SSMS Results Grid Not Showing Ellipses

Earlier today, I ran into an interesting “feature” in the SQL Server Management Studio (SSMS) Results Grid.

During development, I found what appeared to be duplicate data. Uh-oh! I spent three hours debugging my query, looking into the underlying ETL, and doing all kinds of tests. I absolutely could not figure out what was wrong!

Then it hit me. Maybe my query was fine? Maybe the problem was how the results were displayed in the SSMS Results Grid? I tried expanding the columns. And sure enough. There it was. All my data, perfectly fine.

Facepalm.

After facepalming, I started laughing. One of my Norwegian phrases is “erre mulig!?” It roughly translates into an exasperated, humorous “how on earth is that possible!?” I kept laughing. And of course, I had to tweet about my fail of the day:

Continue reading →

Preparing for and Taking Microsoft Exam 70-768 (Developing SQL Data Models)

Microsoft Exam 70-768: Developing SQL Data Models

After taking a break from exams and certifications for a few years, I recently decided to resume studying. On May 29th, I shared my Updated Microsoft Certification Goals. On June 5th, I achieved my first goal by passing Microsoft Exam 70-767. On July 31st, I achieved my second goal! I passed Microsoft Exam 70-768: Developing SQL Data Models. By passing this exam, I became a Microsoft Certified Solutions Associate (MCSA): Business Intelligence Development :)

In this blog post, I share how I prepared for the exam and what my experience was like on the day of the exam.

Continue reading →

Preparing for and Taking Microsoft Exam 70-767 (Implementing a Data Warehouse using SQL)

Microsoft Exam 70-767: Implementing a Data WarehouseAfter taking a break from exams and certifications for a few years, I recently decided to resume studying. On May 29th, I shared my Updated Microsoft Certification Goals. A week later, on June 5th, I achieved my first goal! I passed Microsoft Exam 70-767: Implementing a Data Warehouse using SQL. By passing this exam, I became a Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics. Woohoo :)

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.

Continue reading →

Updated Microsoft Certification Goals

Updated Microsoft Certification Goals - MCSE: Data Management and AnalyticsIt has been several years since I last studied for a Microsoft Certification. (Insert your favorite saying about how time flies and life changes here!) Back in February 2014, I started working towards the old MCSE: Business Intelligence. The first step was to earn the MCSA: SQL Server 2012/2014. It took longer than I expected, including a frustrating experience trying an online proctored exam, but I finally passed the last of the three required exams in May 2015.

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…

Continue reading →