Skip to content

Posts from the ‘Resources’ Category

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

How to add a Wiki to Your GitHub Project Using Markdown​

There are many formats that you can write documentation in for the Web.  For GitHub projects, Markdown is an accessible format that is cross-platform and compatible with many web editors and CMS systems.  This article shows how to add a Wiki to your GitHub project, write in markdown, and convert HTML documentation to the Markdown format.

Read more

Connecting R Scripts to SQL Azure for Data Discovery and Profiling

I added R to my toolkit and have had great success using it on many projects, for not only discovery but also for visualizations.  R provides many packages and functions that let you perform data discovery over a data set.

Read more