Skip to content

Posts from the ‘Resources’ Category

Microsoft Azure Data Exams DP-200 & DP-201 Changes

As of June 21, 2019 the exams, Exam DP-200: Implementing an Azure Data Solution and Exam DP-201: Designing an Azure Data Solution have changed. The exams look to be more focused in order to differentiate between a data engineer role from a database administrator role.

Read more

Two Resources to add Organization to Your Desktop with Microsoft Themed Wallpapers

My development activities require me to have various desktops open which can become confusing, especially if you keep to the default desktop image. The following two resources have worked best for me in changing up my desktop display.

Read more

SSDT for Visual Studio 2017 – Fixing the Install Error

There is an odd error when trying to install SQL Server Data Tools (SSDT), either as a stand-alone, or adding to an instance of Visual Studio 2017.  I had the same setup failure, no matter what configuration I was using. The following steps worked for me, and may for your situation.

Read more

Learning Resources to get you Started in Microsoft Azure Data Projects

As companies move data workloads to the cloud, more and more resources are available online to help you get up to speed. The following learning map provides a path to these online resources not only to give you an overview but also to provide an experience of these technologies .

Read more

A Quiz to Measure Your Work-Life Balance

A few years ago a manager at work circulated the "Work-Life Balance Quiz",  from the Canadian Mental Health Association which tries to quantify your balance.  A great quote from the quiz; "Achieving work/life balance means having equilibrium among all the priorities in your life – this state of balance is different for every person."

Read more

SQL Azure Stored Procedure Automation Using Runbooks and Email

Minimize the impact on SQL Automation workflows when migrating to SQL Azure by automating stored procedures using Runbooks and E-mail.  This step by step tutorial and walkthrough will review a solution to provide scheduling via Azure Runbooks with integrated O365 email alerts.

Read more

Effective Data Visualization – My 3 Key Lessons

I must say that I enjoy articles that teach me something new from people who have a great depth of knowledge about a topic.  I read an article by Avinash Kaushik,  Create High-Impact Data Visualizations: Nine Effective Strategies, which covers nine strategies while reviewing sixteen visualizations. It reminded me of three key learnings I have had over my career.

Read more

4 Key Power BI Learning Resouces​

There is a very active community around PowerBI with many sites specializing in different aspects of the product. The following 4 resources are ones I always fall back on recommending that provide both beginner and advanced users learning resources.

Read more

Story Telling with Data Visualizations and Infographics

Data visualizations can become the vehicle that leads a reader through your narrative.  Having an infographic or series of visuals allows one to tell a story and provide greater understanding than simply having text alone.

Read more

5 Resources to Create Realistic Demo Databases

There are times when, as a consultant, you have to produce a demo or training database that has no relation to the client that you are doing the work for. This can be due to security or confidentiality of the data. I try to produce training and samples that at least have realistic values so that the people involved have a frame of reference.

Read more