Category: Azure
-
Modern Data Architecture – Part 4 – Setting up a SQL Server
Modern Data Architecture – Part 4 – Setting up a SQL Server Before we move on to loading data into our Azure Data Lake, we will need a data source to simulate pulling data from as to mirror a production system. For this exercise, we will walk through creating your own SQL server database and…
-
Modern Data Architecture – Part 3 – Creating Data Lake Storage
Modern Data Architecture – Part 3 – Creating Data Lake Storage A data lake is a system or repository of data stored in its natural/raw format, usually object blobs or files. A data lake is usually a single store of all enterprise data including raw copies of source system data and transformed data used for…
-
Modern Data Architecture – Part 2 – Resource Groups and Subscriptions
Modern Data Architecture – Part 2 – Resource Groups and Subscriptions Resource Groups in Azure are a mechanism of grouping a collection of services and assets in Azure together. Resource groups can assist in automatic provisioning, deprovisioning, monitoring, and access control as well as provide logical groupings for business processes, units or even environment. A…
-
Modern Data Architecture – Part 1 – Navigating the Azure Portal
Modern Data Architecture – Part 1 – Navigating the Azure Portal Logging into Azure and the Portal Open up a web browser and navigate to https://azure.microsoft.com/en-us/ and click on “Portal” to log in. You will be navigated to authentication portal to log in. You can either sign up for a new account which comes with…
-
Microsoft Data Analytics Projects to take on while COVID-19 Quarantine is in place
Are you looking for some Microsoft Data Analytic Projects to take on while the work from home COVID-19 Quarantine is in place? Here is a list of projects that can be completed easily and independently by your team with little supervision that you may have been kicking the can down the road on. 1) SQL…
-
Create or download free custom backgrounds to make your Power BI reports pop!
The difference between a good looking Power BI report and a great looking Power BI report is just a short extra mile using a custom background template. It is easy to create or download free custom backgrounds to make your Power BI reports pop!
-
Auto Spin up and Down Azure Virtual Machines (VM)
One of the best perks of moving your infrastructure to the cloud is the ability to only pay for the resources you use. When using Virtual Machines that usage can be even further limited to servers that stay on only when you need them (business hours or nightly data runs) and then shut down to…
-
Create a NodeJS Client Application to Submit Data to Event Hubs
Now that we have provisioned a Event Hub in Azure, let’s Create a NodeJS Client Application to Submit Data to Event Hubs. Prerequisites Visual Studio 2017 Install NodeJS SDK
-
Provisioning an Azure Event Hub to capture real time streaming data
Provisioning an Azure Event Hub to capture real time streaming data is fairy easy once you have an Azure account. Event Hubs can be used to capture data from many different sources including databases or IoT devices. As we look at building a CDC streaming ETL, let’s take a look at the basics of Event…
-
Visual Studio Dev Essentials to download and install SQL Server Developer Edition
With the Microsoft BizSpark program now gone, so is the easy way to download and install SQL Server to your local machine for development purposes. Let’s take a look at using Visual Studio Dev Essentials to download and install SQL Server Developer Edition on your local machine for data development.