Skip to content
Cathrine Wilhelmsen

Tag: SQL Server

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 →

Azure Data Factory v2 with Mike Flasko

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 :)

Thank you Mike and Sanjay for sitting down with me on a busy day! If you were unable to attend Microsoft Ignite 2017, you can now watch Mike’s session New capabilities for data integration in the cloud on-demand:

Other interviews from Microsoft Ignite 2017

Data Science with Buck Woody
SQL Server 2017 with Bob Ward
High Performance Analytics with Sunil Agarwal

High Performance Analytics with Sunil Agarwal

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

You can learn more in the SQL Server Database Engine Blog, follow Sunil Agarwal on Twitter @S_u_n_e_e_l and follow Kevin Farlee on Twitter @kfarlee.

I’m very happy they all managed to find time to talk to me, hope you enjoy the interview! To learn more, watch Sunil and Aaron’s session Delivering high performance analytics with columnstore index on traditional DW and HTAP workloads from Microsoft Ignite 2017:

Other interviews from Microsoft Ignite 2017

Data Science with Buck Woody
SQL Server 2017 with Bob Ward
Azure Data Factory v2 with Mike Flasko