Skip to content

Posts from the ‘Uncategorized’ Category

Learning Paths Introduction: Guided Technical Enablement

Our ability to keep up with the volume of new cloud-based products and services is becoming more difficult. To survive in this environment, we need to adopt various learning techniques and Guided Technical Enablement is an example of Agile Learning and uses Learning Plan is one of them.

Read more

Learning Path: Azure Synapse Analytics – An Introduction

This learning Path covers Azure Synapse Analytics This service is not only the next evolution of Azure SQL Data Warehouse, but combines enterprise data warehousing and Big Data Analytics into collaborative projects to ingest, prepare, manage and serve data together in a single pane of glass experience.

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

5 Steps to Improve Your Excel Data Visualization Productivity

You can improve your data visualizations productivity by using the built-in table functionality available in Excel. This tutorial and sample Excel workbook, available on GitHub, will move you from raw table to interactive analysis in less than 5 minutes.

Read more

Create HTML Documentation for Your Data Discovery

There are many tools that you can purchase to generate documentation, however, also costs money or requires an install on client machines or servers. I wanted something fast which would not leave a foot print or require weeks of negotiations to get installed. The T-SQL script generates an HTML document out of the schema results that you can paste into Word to kickstart the documentation process.

Read more

33 Free Data Sources

Forbes Tech has just released a list of 33 free data sources that you can use for your next proof of concept or demo.  The list is a wide and varied source of Canadian, US and European open data initiatives.

Bernard Marr has written the article which is available on the Forbes website: Big Data: 33 Brilliant And Free Data Sources For 2016.

A short post, but a great resource.


DAX Studio Released

I must admit, it is always great to find a new tool that you can fit into your BI workflow and DAX Studio which helps you edit DAX queries is one of those tools. I was pleasantly surprised at the full functionality and deep feature set of this tool on CodePlex.

Read more

New Updates to Capacity Planning for SQL and SharePoint 2013

If you are using SharePoint 2013 this resource provides guidance on determining your capacity plan for SQL.

Read more

%d bloggers like this: