Category: Azure

  • NYC Yellow Cab Data in Azure SQL Data Warehouse

    NYC Yellow Cab Data in Azure SQL Data Warehouse

    Microsoft Azure provides a convenient feature when creating a new Azure SQL Data Warehouse database. You can create the database from a backup of the Microsoft sample database, AdventureWorksDW. This is super fast and easy. It also has huge tables like dbo.FactInternetSalesReason with 64,515 rows! Oh, hold on I think I typo’ed. No, actually that is […]

  • What is a cloud data warehouse?

    What is a cloud data warehouse?

    Amazon Redshift was announced in November of 2012 and became the first cloud data warehouse, opening a whole new segment of technology. What is a cloud data warehouse exactly? On-premises data warehouse While cloud data warehouses are relatively new, at least from this decade, the data warehouse concept is not. A data warehouse is a […]

  • SQL Data Warehouse – Fast row counts

    SQL Data Warehouse – Fast row counts

    A couple of years ago I published a script to calculate fast, light-weight, row counts for SQL Server on-premises. The need to view the row counts of tables has not diminished but new technologies have come to the fore-front. Azure SQL Data Warehouse is a massively parallel processing (MPP) architecture designed for large-scale data warehouses. […]

  • T-SQL Tuesday #95 – Unstructured Cosmos

    T-SQL Tuesday #95 – Unstructured Cosmos

    T-SQL Tuesday (#TSQL2sDAY) is a blog party founded by Adam Machanic (b | t). Each month a member of the community hosts the party and selects a topic for us to write about. This month, I am hosting. I invited everyone to write about Big Data. For my post, I chose to learn about Microsoft […]

  • Launch your database into Azure SQL Database – bacpac edition

    Launch your database into Azure SQL Database – bacpac edition

    You have decided to migrate our on-premise SQL Server database into Azure SQL Database. How do you do that? The first thought that comes to mind is a simple backup from on-premise and restore to Azure SQL Database. Unfortunately, that is not supported by Microsoft. Instead, there are three supported methods of migrating into Microsoft’s […]

  • Azure SQL Database Elastic Pools

    Azure SQL Database Elastic Pools

    Azure SQL Database Elastic Pools are a mechanism for grouping your Azure SQL Databases together into a shared resource pool. Imagine for a moment that you had a physical server on premise. On that server, you have a single SQL Server instance and a single database. This example is similar to how Azure SQL Database […]

  • Connecting your Azure regions

    Connecting your Azure regions

    In this post, I am going to demonstrate how to configure virtual network gateways in Azure using Resource Manager. This is important for connecting two Azure regions together, enabling you to setup high-availability and/or disaster recovery systems. 1. Resource Groups Begin by creating or selecting a resource group in each of the regions that you […]

  • Connect to SQL Server on Azure VM via Local SSMS

    Connect to SQL Server on Azure VM via Local SSMS

    After you provision a Microsoft Azure VM with SQL Server there are a few more steps that you need to take to make remote connections. The procedure below starts with a fresh Azure VM provisioned and walks through the process of establishing a connection via SQL Server Management Studio, installed on an on-premises work station. […]