Skip to content

Learning Path: Azure Synapse (Formerly Azure SQL Data Warehouse)

In this Learning Path for the Azure Synapse (Formerly Azure SQL Data Warehouse), you are provided with various online resources in a structured learning format. Each level contains the objectives delivered through articles, labs and tutorials.

Read more

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

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

How to Keep up with What’s New in Azure SQL Databases

Keeping up to speed with the pace of change in cloud-based computing is one of the most challenging tasks for technical resources. This article covers the Azure Updates site which lists resources to keep you informed about not only Azure SQL but also other Microsoft cloud services.

Read more

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

How to Setup VSCode for Python and GitHub Integration

For those DBAs are using SQL for data discovery, the move to data science can involve a brand-new set of varied tools and technologies. This article is a walkthrough of setting up the tooling to do some data discovery using Python. By setting up your workflow using, GitHub, VSCode and Python you will have the basic architecture set up for Data Exploration.

Read more

How to Set up Free Microsoft Office Online for Data Analysis

This first article in the Introduction to Data Analysis series will walk you through setting up Microsoft's free Office Online and introduce you to using Excel Online with OneDrive.

Read more

Productionalize, Productionize, or Productionise?

You are writing and come across a word that just does not look right. This article covers one of my pet peeves, "Productionalization". As I looked at various sources, I realized that perhaps I have to open my mind to the new english.

Read more

How to use Azure Automation PowerShell Runbooks to Create BI PaaS Architectures

This post covers the automation and creation of an; Azure Resource Group, Blob storage, Azure SQL Server and an Azure Analysis Services in a PaaS offering using Azure Automation PowerShell Runbooks.

Read more