SlideShare a Scribd company logo
1 of 34
Download to read offline
Migrate SQL Server Apps to SQL Azure Cloud DB,[object Object],Joe D’Antoni, Synthes,[object Object],12-May-2011	,[object Object]
About Me,[object Object],[object Object]
Primarily in health care
Vice President of the Philadelphia SQL Server User Group
I like to talk about and use new technologies
@jdanton on Twitter
Blog—joedantoni.wordpress.com,[object Object]
Cloud Computing Overview	,[object Object]
Cloud in the news…,[object Object],May 6, 2011,[object Object],"Most of the work going forward will be integration, and architectural in nature. There will be a need for people in all levels who are thinking about a composite world. You have to think about how parts fit, which is an architectural mindset. It's not implementation of a feature, it's architectural in nature”,[object Object],Bob Kelly, MS VP Server and Platform Marketing ,[object Object]
Amazon Outage,[object Object]
Why your CIO Likes Cloud Computing,[object Object],Increased flexibility on new project,[object Object],Capital spending can be lower,[object Object],Reduce costs of offsite backup,[object Object],Potentially reduced employee costs,[object Object]
Legal?	,[object Object],“In theory, you have the same legal protection in the cloud, that you do in your own data center, but….Amazon doesn’t care as much about your data as getting the AG off of their back”,[object Object],--General Counsel of medium size healthcare company,[object Object]
SQL Azure	,[object Object],The only purely database offering currently available,[object Object],[object Object]
Limited Selection of SQL Server Features
50 Gb size limit for an individual database
No native backup command
MS guarantees 99.95% availability,[object Object]
Leverage existing skills through existing ecosystem of developer and management tools
Explore new data application patterns
Database utility; pay as you grow
Flexible load balancing
Business-ready SLAs
Enable multi-tenant solutions
World-wide presence
Easy provisioning and deployment
Auto high-availability and fault tolerance
Self-maintaining infrastructure; self-healing
No need for server or VM administration,[object Object]
Why your Legal Department thinks it’s not…,[object Object],A good friend of mine, who shall remain nameless…,[object Object],“In theory, you have the same legal protection in the cloud, that you do in your own data center, but….Amazon doesn’t care as much about your data as getting the AG off of their back”,[object Object],--General Counsel of medium size healthcare company,[object Object]
SQL Azure Costs,[object Object],SQL Azure,[object Object],Web Edition,[object Object],$9.99 per database up to 1GB per month,[object Object],$49.95 per database up to 5GB per month,[object Object],Business Edition,[object Object],$99.99 per database up to 10GB per month,[object Object],$199.98 per database up to 20GB per month,[object Object],$299.97 per database up to 30GB per month,[object Object],$399.96 per database up to 40GB per month,[object Object],$499.95 per database up to 50GB per month,[object Object],Data Transfers,[object Object],North America and Europe regions,[object Object],$0.10 per GB in,[object Object],$0.15 per GB out,[object Object]
On-Premise SQL Server Costs	,[object Object],Server - $15k,[object Object],SQL Server Standard Edition (2 CPUs) - $14,200,[object Object],DBA - $85k year,[object Object],Tape backups - $20k,[object Object],Upfront Costs - ~$50k,[object Object],Annual Costs - $105k,[object Object]
SQL Azure Limitations,[object Object],Connection Constraints,[object Object],SQL Azure Database provides a large-scale multi-tenant database service on shared resources. In order to provide a good experience to all SQL Azure Database customers, your connection to the service may be closed due to the following conditions:,[object Object],Excessive resource usage,[object Object],Connections that have been idle for 30 minutes or longer,[object Object],Failover because of server failures,[object Object]
Limitations, Cont’d,[object Object],Must have clustered index on all of your tables,[object Object],No Backup Command,[object Object],SQL Authentication only,[object Object],No SQL Agent*,[object Object],Both the READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION database options are set to ON in SQL Azure Database,[object Object],50 GB Limit – Database can be sharded, but it’s not easy ,[object Object]
SQL Azure Database,[object Object],Single Logical,[object Object],Database,[object Object],Multiple PhysicalReplicas,[object Object],Replica 1,[object Object],Single Primary,[object Object],Based on SQL Server 2008 R2 engine,[object Object],Use same tools and data access frameworks,[object Object],Six global datacenters,[object Object],High Availability & Redundancy,[object Object],Reads are completed at the primary,[object Object],Writes are replicated to a quorum of secondaries,[object Object],Replica 2,[object Object],DB,[object Object],Replica 3,[object Object],Multiple,[object Object],Secondaries,[object Object]

More Related Content

What's hot

Day Of Cloud - Windows Azure Platform
Day Of Cloud - Windows Azure PlatformDay Of Cloud - Windows Azure Platform
Day Of Cloud - Windows Azure PlatformWade Wegner
 
Azure SQL Managed Instance - SqlBits 2019
Azure SQL Managed Instance - SqlBits 2019Azure SQL Managed Instance - SqlBits 2019
Azure SQL Managed Instance - SqlBits 2019Jovan Popovic
 
SQL PASS Summit 2018
SQL PASS Summit 2018SQL PASS Summit 2018
SQL PASS Summit 2018Kendra Little
 
Develop Your Own Path On Microsoft Azure
Develop Your Own Path On Microsoft AzureDevelop Your Own Path On Microsoft Azure
Develop Your Own Path On Microsoft AzureWePlus Consultancy
 
Windows azure sql_database_tutorials
Windows azure sql_database_tutorialsWindows azure sql_database_tutorials
Windows azure sql_database_tutorialsMILL5
 
Creation of cloud application using microsoft azure by vaishali sahare [katkar]
Creation of cloud application using microsoft azure by vaishali sahare [katkar]Creation of cloud application using microsoft azure by vaishali sahare [katkar]
Creation of cloud application using microsoft azure by vaishali sahare [katkar]vaishalisahare123
 
Geek Sync | Planning a SQL Server to Azure Migration in 2021 - Brent Ozar
Geek Sync | Planning a SQL Server to Azure Migration in 2021 - Brent OzarGeek Sync | Planning a SQL Server to Azure Migration in 2021 - Brent Ozar
Geek Sync | Planning a SQL Server to Azure Migration in 2021 - Brent OzarIDERA Software
 
Microsoft Azure Overview Infographic
Microsoft Azure Overview InfographicMicrosoft Azure Overview Infographic
Microsoft Azure Overview InfographicMicrosoft Azure
 
SQL Azure the database in the cloud
SQL Azure the database in the cloud SQL Azure the database in the cloud
SQL Azure the database in the cloud Eduardo Castro
 
Data Management Gateway - Deep Dive
Data Management Gateway - Deep DiveData Management Gateway - Deep Dive
Data Management Gateway - Deep DiveJean-Pierre Riehl
 
Introducing Azure Services Platform V1
Introducing Azure Services Platform V1Introducing Azure Services Platform V1
Introducing Azure Services Platform V1guest120d945
 
Architecting Cloudy Applications
Architecting Cloudy ApplicationsArchitecting Cloudy Applications
Architecting Cloudy ApplicationsDavid Chou
 
Architecting Solutions Leveraging The Cloud
Architecting Solutions Leveraging The CloudArchitecting Solutions Leveraging The Cloud
Architecting Solutions Leveraging The CloudDavid Chou
 
Microsoft Database Options
Microsoft Database OptionsMicrosoft Database Options
Microsoft Database OptionsDavid Chou
 
Azure architecture
Azure architectureAzure architecture
Azure architectureAmal Dev
 
Microsoft Cloud Computing - Windows Azure Platform
Microsoft Cloud Computing - Windows Azure PlatformMicrosoft Cloud Computing - Windows Azure Platform
Microsoft Cloud Computing - Windows Azure PlatformDavid Chou
 

What's hot (20)

Day Of Cloud - Windows Azure Platform
Day Of Cloud - Windows Azure PlatformDay Of Cloud - Windows Azure Platform
Day Of Cloud - Windows Azure Platform
 
Azure SQL Managed Instance - SqlBits 2019
Azure SQL Managed Instance - SqlBits 2019Azure SQL Managed Instance - SqlBits 2019
Azure SQL Managed Instance - SqlBits 2019
 
SQL PASS Summit 2018
SQL PASS Summit 2018SQL PASS Summit 2018
SQL PASS Summit 2018
 
Develop Your Own Path On Microsoft Azure
Develop Your Own Path On Microsoft AzureDevelop Your Own Path On Microsoft Azure
Develop Your Own Path On Microsoft Azure
 
Windows azure sql_database_tutorials
Windows azure sql_database_tutorialsWindows azure sql_database_tutorials
Windows azure sql_database_tutorials
 
SQL Azure
SQL AzureSQL Azure
SQL Azure
 
Creation of cloud application using microsoft azure by vaishali sahare [katkar]
Creation of cloud application using microsoft azure by vaishali sahare [katkar]Creation of cloud application using microsoft azure by vaishali sahare [katkar]
Creation of cloud application using microsoft azure by vaishali sahare [katkar]
 
SQL Database on Azure
SQL Database on AzureSQL Database on Azure
SQL Database on Azure
 
Geek Sync | Planning a SQL Server to Azure Migration in 2021 - Brent Ozar
Geek Sync | Planning a SQL Server to Azure Migration in 2021 - Brent OzarGeek Sync | Planning a SQL Server to Azure Migration in 2021 - Brent Ozar
Geek Sync | Planning a SQL Server to Azure Migration in 2021 - Brent Ozar
 
Microsoft Azure Overview Infographic
Microsoft Azure Overview InfographicMicrosoft Azure Overview Infographic
Microsoft Azure Overview Infographic
 
SQL Azure the database in the cloud
SQL Azure the database in the cloud SQL Azure the database in the cloud
SQL Azure the database in the cloud
 
Data Management Gateway - Deep Dive
Data Management Gateway - Deep DiveData Management Gateway - Deep Dive
Data Management Gateway - Deep Dive
 
Azure data platform overview
Azure data platform overviewAzure data platform overview
Azure data platform overview
 
Introducing Azure Services Platform V1
Introducing Azure Services Platform V1Introducing Azure Services Platform V1
Introducing Azure Services Platform V1
 
Architecting Cloudy Applications
Architecting Cloudy ApplicationsArchitecting Cloudy Applications
Architecting Cloudy Applications
 
Architecting Solutions Leveraging The Cloud
Architecting Solutions Leveraging The CloudArchitecting Solutions Leveraging The Cloud
Architecting Solutions Leveraging The Cloud
 
Microsoft Database Options
Microsoft Database OptionsMicrosoft Database Options
Microsoft Database Options
 
Azure architecture
Azure architectureAzure architecture
Azure architecture
 
Microsoft Cloud Computing - Windows Azure Platform
Microsoft Cloud Computing - Windows Azure PlatformMicrosoft Cloud Computing - Windows Azure Platform
Microsoft Cloud Computing - Windows Azure Platform
 
Cloud Computing
Cloud ComputingCloud Computing
Cloud Computing
 

Viewers also liked

Guide Ecoles
Guide EcolesGuide Ecoles
Guide Ecolesasmouch
 
ProduccióN Editorial Universitaria septiembre 2009
ProduccióN Editorial Universitaria septiembre 2009ProduccióN Editorial Universitaria septiembre 2009
ProduccióN Editorial Universitaria septiembre 2009Julia08102006
 
Ramstel - Character design - Tesi di laurea
Ramstel - Character design - Tesi di laureaRamstel - Character design - Tesi di laurea
Ramstel - Character design - Tesi di laureaGabriele
 
Sql server 2012 ha dr nova
Sql server 2012 ha dr novaSql server 2012 ha dr nova
Sql server 2012 ha dr novaJoseph D'Antoni
 
Guest Lecture - GIT Version Control
Guest Lecture - GIT Version ControlGuest Lecture - GIT Version Control
Guest Lecture - GIT Version ControlPing Onn Cheng
 
Server virtualization and cloud computing
Server virtualization and cloud computingServer virtualization and cloud computing
Server virtualization and cloud computingJoseph D'Antoni
 

Viewers also liked (8)

Guide Ecoles
Guide EcolesGuide Ecoles
Guide Ecoles
 
ProduccióN Editorial Universitaria septiembre 2009
ProduccióN Editorial Universitaria septiembre 2009ProduccióN Editorial Universitaria septiembre 2009
ProduccióN Editorial Universitaria septiembre 2009
 
Ramstel - Character design - Tesi di laurea
Ramstel - Character design - Tesi di laureaRamstel - Character design - Tesi di laurea
Ramstel - Character design - Tesi di laurea
 
Sql server 2012 ha dr nova
Sql server 2012 ha dr novaSql server 2012 ha dr nova
Sql server 2012 ha dr nova
 
Guest Lecture - GIT Version Control
Guest Lecture - GIT Version ControlGuest Lecture - GIT Version Control
Guest Lecture - GIT Version Control
 
Server virtualization and cloud computing
Server virtualization and cloud computingServer virtualization and cloud computing
Server virtualization and cloud computing
 
Git Advanced
Git AdvancedGit Advanced
Git Advanced
 
South Asian Studies08
South Asian Studies08South Asian Studies08
South Asian Studies08
 

Similar to Deploying your Application to SQLRally

Working with azure database services platform
Working with azure database services platformWorking with azure database services platform
Working with azure database services platformssuser79fc19
 
Microsoft Cloud Database & Cloud BI
Microsoft Cloud Database & Cloud BIMicrosoft Cloud Database & Cloud BI
Microsoft Cloud Database & Cloud BIMark Kromer
 
SQL Azure Overview - ericnel
SQL Azure Overview - ericnelSQL Azure Overview - ericnel
SQL Azure Overview - ericnelukdpe
 
Understanding The Azure Platform Jan
Understanding The Azure Platform   JanUnderstanding The Azure Platform   Jan
Understanding The Azure Platform JanDavidGristwood
 
Azure SQL DB Managed Instances Built to easily modernize application data layer
Azure SQL DB Managed Instances Built to easily modernize application data layerAzure SQL DB Managed Instances Built to easily modernize application data layer
Azure SQL DB Managed Instances Built to easily modernize application data layerMicrosoft Tech Community
 
SQL Azure Dec 2010 Update
SQL Azure Dec 2010 UpdateSQL Azure Dec 2010 Update
SQL Azure Dec 2010 UpdateEric Nelson
 
SQL Azure Dec Update
SQL Azure Dec UpdateSQL Azure Dec Update
SQL Azure Dec UpdateEric Nelson
 
Datavail Accelerates AWS Adoption for Sony DADC New Media Solutions PPT
 Datavail Accelerates AWS Adoption for Sony DADC New Media Solutions PPT Datavail Accelerates AWS Adoption for Sony DADC New Media Solutions PPT
Datavail Accelerates AWS Adoption for Sony DADC New Media Solutions PPTAmazon Web Services
 
Afternoons with Azure - Azure Data Services
Afternoons with Azure - Azure Data ServicesAfternoons with Azure - Azure Data Services
Afternoons with Azure - Azure Data ServicesCCG
 
Be05 introduction to sql azure
Be05   introduction to sql azureBe05   introduction to sql azure
Be05 introduction to sql azureDotNetCampus
 
Reference for data migration pls choose and
Reference for data migration pls choose andReference for data migration pls choose and
Reference for data migration pls choose andiswarianagarajan
 
SQL Azure Overview for Bizspark day
SQL Azure Overview for Bizspark daySQL Azure Overview for Bizspark day
SQL Azure Overview for Bizspark dayEric Nelson
 
Windows Azure Platform + PHP - Jonathan Wong
Windows Azure Platform + PHP - Jonathan WongWindows Azure Platform + PHP - Jonathan Wong
Windows Azure Platform + PHP - Jonathan WongSpiffy
 
Azure from scratch part 3 By Girish Kalamati
Azure from scratch part 3 By Girish KalamatiAzure from scratch part 3 By Girish Kalamati
Azure from scratch part 3 By Girish KalamatiGirish Kalamati
 

Similar to Deploying your Application to SQLRally (20)

Working with azure database services platform
Working with azure database services platformWorking with azure database services platform
Working with azure database services platform
 
Microsoft Cloud Database & Cloud BI
Microsoft Cloud Database & Cloud BIMicrosoft Cloud Database & Cloud BI
Microsoft Cloud Database & Cloud BI
 
Windows Azure Platform Overview
Windows Azure Platform OverviewWindows Azure Platform Overview
Windows Azure Platform Overview
 
Sql Azure - Adi Cohn
Sql Azure - Adi CohnSql Azure - Adi Cohn
Sql Azure - Adi Cohn
 
SQL Azure Overview - ericnel
SQL Azure Overview - ericnelSQL Azure Overview - ericnel
SQL Azure Overview - ericnel
 
Understanding The Azure Platform Jan
Understanding The Azure Platform   JanUnderstanding The Azure Platform   Jan
Understanding The Azure Platform Jan
 
Sql Azure Pass
Sql Azure PassSql Azure Pass
Sql Azure Pass
 
Sql Azure Pass
Sql Azure PassSql Azure Pass
Sql Azure Pass
 
Azure SQL DB Managed Instances Built to easily modernize application data layer
Azure SQL DB Managed Instances Built to easily modernize application data layerAzure SQL DB Managed Instances Built to easily modernize application data layer
Azure SQL DB Managed Instances Built to easily modernize application data layer
 
SQL Azure Dec 2010 Update
SQL Azure Dec 2010 UpdateSQL Azure Dec 2010 Update
SQL Azure Dec 2010 Update
 
SQL Azure Dec Update
SQL Azure Dec UpdateSQL Azure Dec Update
SQL Azure Dec Update
 
Datavail Accelerates AWS Adoption for Sony DADC New Media Solutions PPT
 Datavail Accelerates AWS Adoption for Sony DADC New Media Solutions PPT Datavail Accelerates AWS Adoption for Sony DADC New Media Solutions PPT
Datavail Accelerates AWS Adoption for Sony DADC New Media Solutions PPT
 
Afternoons with Azure - Azure Data Services
Afternoons with Azure - Azure Data ServicesAfternoons with Azure - Azure Data Services
Afternoons with Azure - Azure Data Services
 
Be05 introduction to sql azure
Be05   introduction to sql azureBe05   introduction to sql azure
Be05 introduction to sql azure
 
Reference for data migration pls choose and
Reference for data migration pls choose andReference for data migration pls choose and
Reference for data migration pls choose and
 
SQL Azure Overview for Bizspark day
SQL Azure Overview for Bizspark daySQL Azure Overview for Bizspark day
SQL Azure Overview for Bizspark day
 
Sql Azure
Sql AzureSql Azure
Sql Azure
 
Why you should(n't) run your databases in the cloud
Why you should(n't) run your databases in the cloudWhy you should(n't) run your databases in the cloud
Why you should(n't) run your databases in the cloud
 
Windows Azure Platform + PHP - Jonathan Wong
Windows Azure Platform + PHP - Jonathan WongWindows Azure Platform + PHP - Jonathan Wong
Windows Azure Platform + PHP - Jonathan Wong
 
Azure from scratch part 3 By Girish Kalamati
Azure from scratch part 3 By Girish KalamatiAzure from scratch part 3 By Girish Kalamati
Azure from scratch part 3 By Girish Kalamati
 

More from Joseph D'Antoni

The modern analytics architecture
The modern analytics architectureThe modern analytics architecture
The modern analytics architectureJoseph D'Antoni
 
Building perfect sql servers, every time -oops
Building perfect sql servers, every time -oopsBuilding perfect sql servers, every time -oops
Building perfect sql servers, every time -oopsJoseph D'Antoni
 
Pass 2013 dantoni azure a gs
Pass 2013 dantoni azure a gsPass 2013 dantoni azure a gs
Pass 2013 dantoni azure a gsJoseph D'Antoni
 
Accelerating Database Performance Using Compression
Accelerating Database Performance Using CompressionAccelerating Database Performance Using Compression
Accelerating Database Performance Using CompressionJoseph D'Antoni
 
Sql server 2012 ha and dr sql saturday boston
Sql server 2012 ha and dr sql saturday bostonSql server 2012 ha and dr sql saturday boston
Sql server 2012 ha and dr sql saturday bostonJoseph D'Antoni
 
Accelerating Database Performance with Compression
Accelerating Database Performance with CompressionAccelerating Database Performance with Compression
Accelerating Database Performance with CompressionJoseph D'Antoni
 
Sql Server 2012 HA and DR -- SQL Saturday Richmond
Sql Server 2012 HA and DR -- SQL Saturday RichmondSql Server 2012 HA and DR -- SQL Saturday Richmond
Sql Server 2012 HA and DR -- SQL Saturday RichmondJoseph D'Antoni
 
Sql server 2012 ha and dr sql saturday tampa
Sql server 2012 ha and dr sql saturday tampaSql server 2012 ha and dr sql saturday tampa
Sql server 2012 ha and dr sql saturday tampaJoseph D'Antoni
 
Windows server 2012 failover clustering new features
Windows server 2012 failover clustering new featuresWindows server 2012 failover clustering new features
Windows server 2012 failover clustering new featuresJoseph D'Antoni
 
Sql server 2012 ha and dr sql saturday dc
Sql server 2012 ha and dr sql saturday dcSql server 2012 ha and dr sql saturday dc
Sql server 2012 ha and dr sql saturday dcJoseph D'Antoni
 
San presentation nov 2012 central pa
San presentation nov 2012 central paSan presentation nov 2012 central pa
San presentation nov 2012 central paJoseph D'Antoni
 
Always on availability groups way too deep
Always on availability groups way too deepAlways on availability groups way too deep
Always on availability groups way too deepJoseph D'Antoni
 
South jersey sql virtualization
South jersey sql virtualizationSouth jersey sql virtualization
South jersey sql virtualizationJoseph D'Antoni
 
Sql server 2012 ha dr 24_hop_final
Sql server 2012 ha dr 24_hop_finalSql server 2012 ha dr 24_hop_final
Sql server 2012 ha dr 24_hop_finalJoseph D'Antoni
 
Sql server 2012 ha dr 24_hop_final
Sql server 2012 ha dr 24_hop_finalSql server 2012 ha dr 24_hop_final
Sql server 2012 ha dr 24_hop_finalJoseph D'Antoni
 
Sql saturday powerpoint dc_san
Sql saturday powerpoint dc_sanSql saturday powerpoint dc_san
Sql saturday powerpoint dc_sanJoseph D'Antoni
 

More from Joseph D'Antoni (20)

DBA Fundamentals VC
DBA Fundamentals VCDBA Fundamentals VC
DBA Fundamentals VC
 
The modern analytics architecture
The modern analytics architectureThe modern analytics architecture
The modern analytics architecture
 
Building perfect sql servers, every time -oops
Building perfect sql servers, every time -oopsBuilding perfect sql servers, every time -oops
Building perfect sql servers, every time -oops
 
Pass 2013 dantoni azure a gs
Pass 2013 dantoni azure a gsPass 2013 dantoni azure a gs
Pass 2013 dantoni azure a gs
 
Accelerating Database Performance Using Compression
Accelerating Database Performance Using CompressionAccelerating Database Performance Using Compression
Accelerating Database Performance Using Compression
 
Pass bac jd_sm
Pass bac jd_smPass bac jd_sm
Pass bac jd_sm
 
Sql server 2012 ha and dr sql saturday boston
Sql server 2012 ha and dr sql saturday bostonSql server 2012 ha and dr sql saturday boston
Sql server 2012 ha and dr sql saturday boston
 
Accelerating Database Performance with Compression
Accelerating Database Performance with CompressionAccelerating Database Performance with Compression
Accelerating Database Performance with Compression
 
Sql Server 2012 HA and DR -- SQL Saturday Richmond
Sql Server 2012 HA and DR -- SQL Saturday RichmondSql Server 2012 HA and DR -- SQL Saturday Richmond
Sql Server 2012 HA and DR -- SQL Saturday Richmond
 
Sql server 2012 ha and dr sql saturday tampa
Sql server 2012 ha and dr sql saturday tampaSql server 2012 ha and dr sql saturday tampa
Sql server 2012 ha and dr sql saturday tampa
 
Windows server 2012 failover clustering new features
Windows server 2012 failover clustering new featuresWindows server 2012 failover clustering new features
Windows server 2012 failover clustering new features
 
Sql server 2012 ha and dr sql saturday dc
Sql server 2012 ha and dr sql saturday dcSql server 2012 ha and dr sql saturday dc
Sql server 2012 ha and dr sql saturday dc
 
San presentation nov 2012 central pa
San presentation nov 2012 central paSan presentation nov 2012 central pa
San presentation nov 2012 central pa
 
Always on availability groups way too deep
Always on availability groups way too deepAlways on availability groups way too deep
Always on availability groups way too deep
 
South jersey sql virtualization
South jersey sql virtualizationSouth jersey sql virtualization
South jersey sql virtualization
 
Virtualization for DBA
Virtualization for DBAVirtualization for DBA
Virtualization for DBA
 
Sql server 2012 ha dr 24_hop_final
Sql server 2012 ha dr 24_hop_finalSql server 2012 ha dr 24_hop_final
Sql server 2012 ha dr 24_hop_final
 
Sql server 2012 ha dr 24_hop_final
Sql server 2012 ha dr 24_hop_finalSql server 2012 ha dr 24_hop_final
Sql server 2012 ha dr 24_hop_final
 
Sql server 2012 ha dr
Sql server 2012 ha drSql server 2012 ha dr
Sql server 2012 ha dr
 
Sql saturday powerpoint dc_san
Sql saturday powerpoint dc_sanSql saturday powerpoint dc_san
Sql saturday powerpoint dc_san
 

Recently uploaded

9 Steps For Building Winning Founding Team
9 Steps For Building Winning Founding Team9 Steps For Building Winning Founding Team
9 Steps For Building Winning Founding TeamAdam Moalla
 
UiPath Community: AI for UiPath Automation Developers
UiPath Community: AI for UiPath Automation DevelopersUiPath Community: AI for UiPath Automation Developers
UiPath Community: AI for UiPath Automation DevelopersUiPathCommunity
 
Machine Learning Model Validation (Aijun Zhang 2024).pdf
Machine Learning Model Validation (Aijun Zhang 2024).pdfMachine Learning Model Validation (Aijun Zhang 2024).pdf
Machine Learning Model Validation (Aijun Zhang 2024).pdfAijun Zhang
 
20230202 - Introduction to tis-py
20230202 - Introduction to tis-py20230202 - Introduction to tis-py
20230202 - Introduction to tis-pyJamie (Taka) Wang
 
Building Your Own AI Instance (TBLC AI )
Building Your Own AI Instance (TBLC AI )Building Your Own AI Instance (TBLC AI )
Building Your Own AI Instance (TBLC AI )Brian Pichman
 
IaC & GitOps in a Nutshell - a FridayInANuthshell Episode.pdf
IaC & GitOps in a Nutshell - a FridayInANuthshell Episode.pdfIaC & GitOps in a Nutshell - a FridayInANuthshell Episode.pdf
IaC & GitOps in a Nutshell - a FridayInANuthshell Episode.pdfDaniel Santiago Silva Capera
 
Videogame localization & technology_ how to enhance the power of translation.pdf
Videogame localization & technology_ how to enhance the power of translation.pdfVideogame localization & technology_ how to enhance the power of translation.pdf
Videogame localization & technology_ how to enhance the power of translation.pdfinfogdgmi
 
UiPath Studio Web workshop series - Day 7
UiPath Studio Web workshop series - Day 7UiPath Studio Web workshop series - Day 7
UiPath Studio Web workshop series - Day 7DianaGray10
 
Crea il tuo assistente AI con lo Stregatto (open source python framework)
Crea il tuo assistente AI con lo Stregatto (open source python framework)Crea il tuo assistente AI con lo Stregatto (open source python framework)
Crea il tuo assistente AI con lo Stregatto (open source python framework)Commit University
 
VoIP Service and Marketing using Odoo and Asterisk PBX
VoIP Service and Marketing using Odoo and Asterisk PBXVoIP Service and Marketing using Odoo and Asterisk PBX
VoIP Service and Marketing using Odoo and Asterisk PBXTarek Kalaji
 
Empowering Africa's Next Generation: The AI Leadership Blueprint
Empowering Africa's Next Generation: The AI Leadership BlueprintEmpowering Africa's Next Generation: The AI Leadership Blueprint
Empowering Africa's Next Generation: The AI Leadership BlueprintMahmoud Rabie
 
How Accurate are Carbon Emissions Projections?
How Accurate are Carbon Emissions Projections?How Accurate are Carbon Emissions Projections?
How Accurate are Carbon Emissions Projections?IES VE
 
Anypoint Code Builder , Google Pub sub connector and MuleSoft RPA
Anypoint Code Builder , Google Pub sub connector and MuleSoft RPAAnypoint Code Builder , Google Pub sub connector and MuleSoft RPA
Anypoint Code Builder , Google Pub sub connector and MuleSoft RPAshyamraj55
 
Nanopower In Semiconductor Industry.pdf
Nanopower  In Semiconductor Industry.pdfNanopower  In Semiconductor Industry.pdf
Nanopower In Semiconductor Industry.pdfPedro Manuel
 
Apres-Cyber - The Data Dilemma: Bridging Offensive Operations and Machine Lea...
Apres-Cyber - The Data Dilemma: Bridging Offensive Operations and Machine Lea...Apres-Cyber - The Data Dilemma: Bridging Offensive Operations and Machine Lea...
Apres-Cyber - The Data Dilemma: Bridging Offensive Operations and Machine Lea...Will Schroeder
 
UWB Technology for Enhanced Indoor and Outdoor Positioning in Physiological M...
UWB Technology for Enhanced Indoor and Outdoor Positioning in Physiological M...UWB Technology for Enhanced Indoor and Outdoor Positioning in Physiological M...
UWB Technology for Enhanced Indoor and Outdoor Positioning in Physiological M...UbiTrack UK
 
UiPath Solutions Management Preview - Northern CA Chapter - March 22.pdf
UiPath Solutions Management Preview - Northern CA Chapter - March 22.pdfUiPath Solutions Management Preview - Northern CA Chapter - March 22.pdf
UiPath Solutions Management Preview - Northern CA Chapter - March 22.pdfDianaGray10
 

Recently uploaded (20)

9 Steps For Building Winning Founding Team
9 Steps For Building Winning Founding Team9 Steps For Building Winning Founding Team
9 Steps For Building Winning Founding Team
 
UiPath Community: AI for UiPath Automation Developers
UiPath Community: AI for UiPath Automation DevelopersUiPath Community: AI for UiPath Automation Developers
UiPath Community: AI for UiPath Automation Developers
 
Machine Learning Model Validation (Aijun Zhang 2024).pdf
Machine Learning Model Validation (Aijun Zhang 2024).pdfMachine Learning Model Validation (Aijun Zhang 2024).pdf
Machine Learning Model Validation (Aijun Zhang 2024).pdf
 
20230202 - Introduction to tis-py
20230202 - Introduction to tis-py20230202 - Introduction to tis-py
20230202 - Introduction to tis-py
 
201610817 - edge part1
201610817 - edge part1201610817 - edge part1
201610817 - edge part1
 
Building Your Own AI Instance (TBLC AI )
Building Your Own AI Instance (TBLC AI )Building Your Own AI Instance (TBLC AI )
Building Your Own AI Instance (TBLC AI )
 
20150722 - AGV
20150722 - AGV20150722 - AGV
20150722 - AGV
 
IaC & GitOps in a Nutshell - a FridayInANuthshell Episode.pdf
IaC & GitOps in a Nutshell - a FridayInANuthshell Episode.pdfIaC & GitOps in a Nutshell - a FridayInANuthshell Episode.pdf
IaC & GitOps in a Nutshell - a FridayInANuthshell Episode.pdf
 
Videogame localization & technology_ how to enhance the power of translation.pdf
Videogame localization & technology_ how to enhance the power of translation.pdfVideogame localization & technology_ how to enhance the power of translation.pdf
Videogame localization & technology_ how to enhance the power of translation.pdf
 
UiPath Studio Web workshop series - Day 7
UiPath Studio Web workshop series - Day 7UiPath Studio Web workshop series - Day 7
UiPath Studio Web workshop series - Day 7
 
Crea il tuo assistente AI con lo Stregatto (open source python framework)
Crea il tuo assistente AI con lo Stregatto (open source python framework)Crea il tuo assistente AI con lo Stregatto (open source python framework)
Crea il tuo assistente AI con lo Stregatto (open source python framework)
 
VoIP Service and Marketing using Odoo and Asterisk PBX
VoIP Service and Marketing using Odoo and Asterisk PBXVoIP Service and Marketing using Odoo and Asterisk PBX
VoIP Service and Marketing using Odoo and Asterisk PBX
 
20230104 - machine vision
20230104 - machine vision20230104 - machine vision
20230104 - machine vision
 
Empowering Africa's Next Generation: The AI Leadership Blueprint
Empowering Africa's Next Generation: The AI Leadership BlueprintEmpowering Africa's Next Generation: The AI Leadership Blueprint
Empowering Africa's Next Generation: The AI Leadership Blueprint
 
How Accurate are Carbon Emissions Projections?
How Accurate are Carbon Emissions Projections?How Accurate are Carbon Emissions Projections?
How Accurate are Carbon Emissions Projections?
 
Anypoint Code Builder , Google Pub sub connector and MuleSoft RPA
Anypoint Code Builder , Google Pub sub connector and MuleSoft RPAAnypoint Code Builder , Google Pub sub connector and MuleSoft RPA
Anypoint Code Builder , Google Pub sub connector and MuleSoft RPA
 
Nanopower In Semiconductor Industry.pdf
Nanopower  In Semiconductor Industry.pdfNanopower  In Semiconductor Industry.pdf
Nanopower In Semiconductor Industry.pdf
 
Apres-Cyber - The Data Dilemma: Bridging Offensive Operations and Machine Lea...
Apres-Cyber - The Data Dilemma: Bridging Offensive Operations and Machine Lea...Apres-Cyber - The Data Dilemma: Bridging Offensive Operations and Machine Lea...
Apres-Cyber - The Data Dilemma: Bridging Offensive Operations and Machine Lea...
 
UWB Technology for Enhanced Indoor and Outdoor Positioning in Physiological M...
UWB Technology for Enhanced Indoor and Outdoor Positioning in Physiological M...UWB Technology for Enhanced Indoor and Outdoor Positioning in Physiological M...
UWB Technology for Enhanced Indoor and Outdoor Positioning in Physiological M...
 
UiPath Solutions Management Preview - Northern CA Chapter - March 22.pdf
UiPath Solutions Management Preview - Northern CA Chapter - March 22.pdfUiPath Solutions Management Preview - Northern CA Chapter - March 22.pdf
UiPath Solutions Management Preview - Northern CA Chapter - March 22.pdf
 

Deploying your Application to SQLRally

Editor's Notes

  1. Hello, and welcome to SQL Saturday #59 in New York NY. My name is Joe D’Antoni, and I’m going to talk about Data Tier Applications today. Before I get started on the presentation, let me tell you a bit about myself—I’m currently a DBA at Synthes—we’re a medical device company in West Chester PA. Our specialty areas are trauma and spine, if you break it we have the hardware to fix it. My background is largely in healthcare, I’ve worked in the pharmaceutical and medical device fields, so I’m used to a lot of paperwork and change control processes. I’m currently the Vice President of the Philadelphia SQL Server users group, and we are planning our SQL Saturday for March of 2011. When I’m not working or working with group, I like to spend time cycling, cooking and eating. I love being here in New York. I also like to work with new tech and talk about—I’ll be presenting this topic at SQL Saturday DC, next month. Lastly, if you’re on twitter look me up, I’m @jdanton—we have a great community of SQL folks on there, and it’s an easy way to get questions answered.
  2. This is what I’m going to try cover today—we’ll go over the basics around cloud computing. I’m going to discuss a couple of business scenarios where SQL Azure might make sense for you or your firm. Then a couple of methods to build and deploy data and code to your SQL Azure Database. Finally, we’ll have a very brief demo of the Reporting Services feature in the latest CTP for SQL Azure. It’s not publically available yet, but it will be shortly.
  3. Since it is a buzzword—cloud computing has been used in every new product offering I’ve seen recently. I’ve heard private cloud which basically applies to a closed box solution like PDW. I’ll try to break this down into a few isolated categories. I’ve been using cloud computing since the mid 90s—Yahoo Mail.Basically, there are four basic types of cloud offerings. Software as a service—which like my aforementioned Yahoo Mail, Gmail, Oracle Cloud Office, Microsoft Office in the cloud, and an offering like Salesforce.com Platform as a service, is a specific product offering. Specifically the two platforms I’m going to talk about today, which are database specific-Microsoft’s SQL Azure, and Amazon EC2. Infrastructure as a service—this could be a couple of things, a hosted server that you manage, or a hosted Oracle environment that is managed by someone else. We’ll discuss a couple of providers that provide Oracle services. Lastly, I wanted to discuss private clouds—I think this is a buzzword gone awry, but it’s basically a black box that is setup by the vendor. Exadata and Exalogic are good examples of this.
  4. This just happened a couple of weeks ago—Amazon had a pretty major outage at one of it’s data centers. This took down a lot of websites—four square included. Amazon’s cloud setup does allow for a real DR scenario within their data centres—but most of these firms hadn’t done it that way.
  5. So why would you use a cloud provider. Reduce backup and storage costs. Potentially reducing employee costs. But another use is to be able quickly add capacity to your environment. Zygna the people who bring you those annoying Facebook games like Farmville, keeps about 40-50% of their capacity at any time at Amazon. They can quickly deploy new capacity, while adding to their own data center.
  6.  The legal concerns about cloud computing are not well defined. But a friend of mine who is the general counsel of a healthcare company said the following. Quote. Just another thing to think about in terms of what data to put out there. Another concern is encrypting any personally identifiable data, as its going across the internet. 
  7. SQL Azure is Microsoft’s cloud offering—it’s basically just a database. There is no server that you have any association with. It has a limited subset of SQL features, but they are getting added rapidly. Much like Amazon MS has multiple data centers allowing users to replicate data for redundancy or speed. There is no licensing involved, just a monthly fee.
  8. So why would you use a cloud provider. Reduce backup and storage costs. Potentially reducing employee costs. But another use is to be able quickly add capacity to your environment. Zygna the people who bring you those annoying Facebook games like Farmville, keeps about 40-50% of their capacity at any time at Amazon. They can quickly deploy new capacity, while adding to their own data center.These are some of the reasons why your CIO thinks this is a good idea. Especially in a startup type environment, I can wave my MBA hat and agree with him or her. Another good example I heard mentioned recently is Domino’s Pizza—they have something like 3000% more orders on Super Bowl Sunday—so they have scaled up with Windows Azure, just for that event.
  9. The legal concerns about cloud computing are not well defined. But a friend of mine who is the general counsel of a healthcare company said the following. Quote. Just another thing to think about in terms of what data to put out there. Another concern is encrypting any personally identifiable data, as its going across the internet.
  10. A lot of these requirements are due to the fact that you are operating in a multi tenant environment, and MS is trying to limit massive IOPs. Microsoft does replicate your data to three data bases, so in theory you have that redundancy. However, after last months Amazon outage—I’d like to have the DR plan of running in a second MS data center (and paying for) or Bulk Copying on regular basis, but I’m paranoid about data loss that way. There is no SQL Agent, however you can run SQL Agent jobs from an on-premise SQL Server, which connect to your SQL Azure database.We can only grow a database up to 50 GB—that number has increased—it was initially 5 or 10. I forget. The term sharding comes to us from the NOSQL community—it’s a way of spanning databases across multiple servers using horizontal partitioning. There’s a white paper on TechNet (linked in this deck) on how to do it, but it’s pretty complex, and something you’ll need to think about early in your application development process.
  11. Slide ObjectiveUse this slide to transition into an explanation of SQL Azure Database (Reporting and Data Sync will be covered later)Explain at a high level how SQL Azure worksSpeaker NotesDesign Principle of SQL Azure: Focus on combining the best features of SQL Server running at scale with low frictionSQL Azure is a high availability databaseAlways three transaction consistent replicas of the databaseOne primary replica; two slave replicasFailure of a replica will result in another replica being spun up immediately by the fabricFailure of the primary replica means a slave replica will become the primary and a new slave will spin upMinimal down timeTypically just a few dropped connectionsEasy to code for the failover scenario- if you are ding god connection management and error handling will be fineClustered index required on all tables to allow replicationNotesUseful article from SQL Azure teamhttp://msdn.microsoft.com/en-us/magazine/ee321567.aspx
  12. These are three sample application topologies that demonstrate different ways of using Azure
  13. Managing Azure from both the Web and SSMS—mention that this requires SSMS 2008R2
  14. Use Code Plex Tool here—the path going forward will be to use Data Sync (discussed in coming slides)
  15. http://netflixpivot.cloudapp.net/
  16. Top FeaturesThe Business Intelligence Design Studio (BIDS) offers a consistent report authoring experience that make your reports rich with visualizations – maps, charts, gauges, sparklines and more.Export to various popular file formats, including Excel, Word, HTML, PDF, XML, CSV and ATOM feeds.Scale and flex to meet elastic demand. Our cloud services platform automatically scales up and down to meet demand and has built-in high availability and fault tolerance. Microsoft SQL Azure Reporting lets you use the familiar on-premises tools you’re comfortable with to develop and deploy operational reports to the cloud. There’s no need to manage or maintain a separate reporting infrastructure, which leads to the added benefit of lower costs (and less complexity). Your customers can easily access the reports from the Management Portal, through a web browser, or directly from your applications.While SQL Azure Reporting is not yet commercially available, you can register to be invited to the community technology preview (CTP).Use SQL Azure Reporting to:Deliver rich insights to your customers without building and managing a reporting platform in house. Create robust, easy-to-read reports available directly within your applications, on the SQL Azure portal or online via a browser. Keep your data secure while offering access to even more users. The rich authentication/authorization model gives reliable, secure access to reports and underlying data
  17. So what are the requirements for this? It is part of Visual Studio 2010 functionality. Additionally, to deploy data-tier applications, you need to running SQL 2008 R2 (enterprise
  18. This is a view of an expanded DACPAC—as you can see it consists of 3 SQL scripts—the main schema script and any pre and post deployment scripts. There are a couple of XML files that define the physical and logical models around the data. As vendors begin to use this technology as method to roll out databases for their technology, as DBAs this will be the place where we can preview their schema and identify any potential issues. Also, not that you would do this, but always review code in a dacpac you downloaded from an unknown source, to ensure that there isn’t any malicious code. In Visual Studio 2010 Premium and higher, you can compare two DACPAC schema files, or just use a file comparison tool.