Author Archives: James Serra

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.

Scaling Azure SQL Database

One of the advantages Azure SQL Database has over on-prem SQL Server is the ease in which it can scale.  I’ll discuss the various options for horizontal scaling, vertical scaling, and other similar features. Horizontal scaling refers to adding or removing … Continue reading

Posted in Azure SQL Database, SQLServerPedia Syndication | 2 Comments

Microsoft Azure Stack in Preview!

Microsoft made available the first technical preview of its new Microsoft Azure Stack offering today.  It was announced last week.  Azure Stack brings the cloud model of computing to every datacenter – your own private cloud.  Azure Stack is a new hybrid … Continue reading

Posted in Azure, SQLServerPedia Syndication | Leave a comment

Migrate from on-prem SQL server to Azure SQL Database

This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database. In this migration process you migrate both your schema and your data from the SQL Server database in your current … Continue reading

Posted in Azure SQL Database, SQL Server, SQLServerPedia Syndication | Leave a comment

HA/DR for Azure SQL Database

Azure SQL Database is a relational database-as-a-service in the cloud.  It uses a special version of Microsoft SQL Server as its backend that is nearly identical to SQL Server (see Azure SQL Database Transact-SQL differences).  While there are many benefits … Continue reading

Posted in Azure SQL Database, SQLServerPedia Syndication | Leave a comment

Why use a data lake?

Previously I covered what a data lake is (including the Azure Data Lake and enhancements), and now I wanted to touch on the main reason why you might want to incorporate a data lake into your overall data warehouse solution. To … Continue reading

Posted in Data Lake, SQLServerPedia Syndication | 7 Comments

Storage options on Azure

Microsoft Azure is a cloud computing platform and infrastructure, created by Microsoft, for building, deploying and managing applications and services through a global network of Microsoft-managed and Microsoft partner-hosted datacenters.  Included in this platform are multiple ways of storing data.  Below … Continue reading

Posted in Azure, Data Lake, SQLServerPedia Syndication | 1 Comment

Redundancy Options in Azure Blob Storage

So you have data in Azure Blob Storage and are concerned about reliability.  Have no fear!  There are four replication options for redundancy: 1. Locally Redundant Storage (LRS): All data in the storage account is made highly durable and available within … Continue reading

Posted in Azure, SQLServerPedia Syndication | 1 Comment

Copying data from Azure Blob Storage

In a previous blog I talked about copying on-prem data to Azure Blob Storage (Getting data into Azure Blob Storage).  Let’s say you have copied the data and it is sitting in Azure Blob Storage (or an Azure Data Lake) … Continue reading

Posted in Azure, Data Lake, SQLServerPedia Syndication | Leave a comment

Azure Data Lake enhancements

I first blogged about Microsoft’s new product, the Azure Data Lake, a few months back (here).  There are already enhancements, as announced at Stata + Hadoop World.  Here they are in brief: The Azure Data Lake has been renamed to the … Continue reading

Posted in Azure, Data Lake, SQLServerPedia Syndication | 2 Comments

Getting data into Azure Blob Storage

If you have on-prem data and want to copy it to Azure Blob Storage in the cloud, what are all the possible ways to do it?  There are many, and here is a quick review of them: AzCopy: A popular command-line … Continue reading

Posted in Azure, Data Lake, SQLServerPedia Syndication | 2 Comments