The key to certification success is to make sure you have the current requirements and training sites to have the best chance of passing the exam. This guide reviews the Microsoft exam structure, the program's role-based nature, and the material provided.
My 5 Tips for Microsoft Certification Success
As with many exams, Microsoft certifications are not all that difficult if you are well prepared. Having had to write a few over the last couple of years, seven to be exact, which shows that anyone can do this if you prepare. This article presents my five most essential tips that have helped me in my certification journey.
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.
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.
How to keep Your Microsoft Azure Automation Runbook Modules Up-to-Date
This article will review a major trap you can find yourself in when using PowerShell in your Runbooks as Azure Automation does not keep your referenced modules up to date.
How to use Azure Data Factory V2 Sliding Windows for SQL Exports to Azure Data Lake
This article reviews the process of using Azure Data Factory V2 sliding windows triggers to archive fact data from SQL Azure DB. This process will automatically export records to Azure Data Lake into CSV files over a recurring period, providing a historical archive which will be available to various routines such as Azure Machine Learning, U-SQL Data Lake Analytics or other big data style workloads.
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 .