Quick and dirty way to find the size of all tables in a azure database. DROP TABLE #list DROP TABLE #data GO CREATE TABLE #data ( name VARCHAR(100) […]
Azure Blob Storage usage scenarios for Archival
Azure blob storage is a great way to store large amounts of data. It provides cheap highly available access to data anytime, anywhere. However the nature of data […]
Configuring Polybase in MS SQL Server 2016
A bit late in the day but I figured I would add a post on how to configure MS SQL Server Polybase. Polybase is a feature of MS […]
Scaling SQL Express with Stretch table feature
Recently I was asked by a client if the Stretch table feature will work with SQL Express and if so what the limitations are. This seemed like an […]
Charting controls: – Things to keep in mind
I often do a number of trainings on MSBI and PowerBI and one of the tasks we do during the course is “I would ask all participants to […]
Adding additional Network interfaces in Azure
In this post we cover how to add an additional NIC card to our Azure VM. Most real world production environments have multiple NIC (Network cards) and quite […]
Monitoring Billing in Azure by Resource Group
In our previous post we explored how to organize resources deployed in Azure. In this post we explore how to understand the impact of the resources that were […]
Creating a Resource Group in Azure
A resource group is a nice little feature that helps Azure Administrators stay organized when managing a large scale deployment. In its simplest sense it behaves like folders […]
Configuring Network security Groups in Azure
In this post we cover how to configure the Network security group that was created by default when we set up the VM previously. The Network Security group […]
Create a Virtual machine in Azure and Bind it to a Virtual Network
In out last post we created a virtual network, in this post we create a virtual machine and map it to our virtual network. There are tons of […]