Meeting Information

Meeting Information


Meeting Name: August CITPG Meeting
Meeting Date: 8/21/2017
Meeting Times: 5:30pm-8:30pm
Location: Redmond Room
Meeting Description:  
For August the SQL Chick returns!!!

Presentation: Tales from Building a SQL Server Data Warehouse in Azure

In this session, we share our experiences and lessons learned from a recent migration to Azure for a SQL Server data warehousing environment. We begin with sharing our reasoning for IaaS vs. PaaS, our carefully-selected naming conventions, and how we structured development, test, and production within subscriptions and resource groups. We cover the what, why, and how for decisions around storage, encryption, and backups. Finally, the session wraps up with a brief discussion of the use of Azure Resource Manager (ARM) templates and PowerShell, as well as techniques for monitoring the environment in Azure.

Bio: Melissa Coates is the Lead Analytics Architect with SentryOne (SQL Sentry) in Charlotte, NC. She specializes in delivering analytics, data warehousing, and business intelligence solutions using on-premises, cloud, and hybrid technologies. Formerly a CPA, Melissa is ridiculously proud to be an IT geek and downright giddy to be a Microsoft Data Platform MVP.

Melissa blogs at sqlchick.com.


Presentations:  
Time: 5:30-8:15
Title: Tales from Building a SQL Server Data Warehouse in Azure
Presenter: Melissa Coates
Technology: SQL Server
Room: Redmond Room, Microsoft Campus
Abstract:  

In this session, we share our experiences and lessons learned from a recent migration to Azure for a SQL Server data warehousing environment. We begin with sharing our reasoning for IaaS vs. PaaS, our carefully-selected naming conventions, and how we structured development, test, and production within subscriptions and resource groups. We cover the what, why, and how for decisions around storage, encryption, and backups. Finally, the session wraps up with a brief discussion of the use of Azure Resource Manager (ARM) templates and PowerShell, as well as techniques for monitoring the environment in Azure.



Current Membership is 3679               2006 - 2017 © Copyright Carolina I.T. Professionals Group.   All rights reserved.               Read Privacy policy
373 Ridgewood Ave
Charlotte, NC 28209-1633
Contact Help Home