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.

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.

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.

Using Azure Data Lake with Power BI

Power BI gives you the ability to use a wide variety of data sources in your data visualization project. This walkthrough shows you how to access files in a Azure Data Lake and import them into a Power BI data models.

How To: Create the missing KPI Indicator In Power BI Desktop Using Conditional Formatting (Updated)

Power BI lacks the ability to add KPI calculations when creating a data model in Power BI Desktop. I will show you how to get the same functionality by using the recently released feature “Conditional Formatting by a Different Field”. This will allow you to take a calculated score and have an Icon displayed for each row in your table.  A working Live Interactive Power BI Sample is attached at the bottom of this post.

Powered by WordPress.com.

Up ↑