Build Applications in Microsoft SQL Server CodeNamed Denali and SQL Azure Rick Negrin Program Manager Adrian Bethune Program Manager Microsoft DBI306 Symmetry Isolation DeploymentMovementUpgrade ID: 612437
Download Presentation The PPT/PDF document "Using Contained Databases and DACs to" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Using Contained Databases and DACs to Build Applications in Microsoft SQL Server Code-Named "Denali" and SQL Azure
Rick Negrin, Program ManagerAdrian Bethune, Program ManagerMicrosoft
DBI306Slide2
Symmetry
IsolationDeployment/Movement/UpgradeDevelopment Experience
Pain Points and Capabilities
Capabilities
Key Characteristics
Elastic
Rapid & Elastic
Provisioning
Scalable
Resources dynamically
assigned / unassigned
Greatly
ReducedTCO & Increased Agility
MeasuredAutomatic control & Optimization
Available24x7 availability
Self
ServiceUnilaterally provisionresources without humanintervention
# of applications and amount of data is exploding
IT spending 80% managing existing apps
Focus on management at scale
Hybrid on-premise and cloud environmentsSlide3
Data-tier Application Lifecycle
CREATE
TABLE
Orders
( id INT
,
ordTime
DATETIME,
. . .) --
ON OrdPS(ordTime)CREATE TABLE OrderEntr(
CREATE
TABLE Orders( id
INT, ordTime DATETIME,
. . .) -- ON
OrdPS(ordTime)
CREATE TABLE OrderEntr(Source Code
Contained Database
(CDB)
Definition
Runtime Container
Build
Extract
Deploy
Upgrade
Reverse
Engineer
DAC Framework Services
DACPACSlide4
SQL Azure
2011CDB and DAC, more features
Roadmap
SQL Azure
2010
CDB, some features, DAC support
SQL
“Denali” + 1
Full CDB: Symmetry Across SQL Azure & SQL ServerSQL Server 2008: Existing DB Model
SQL Server & SQL Azure
app features
aligned
SQL Denali CDB: partial containment
SQL Server 2008
R2, DAC Support
SQL Azure
2012
CDB and DAC, most featuresSlide5
Contained Database (CDB)Slide6
Host-App Binding: a Cautionary Tale
Master
MSDB
Temp
Master
MSDB
User DB
TempDB
Instance Collation
LoginsCredentialsLinked Server Defs.CLR…AgentReplicationDB Mail…
…TempDB CollationOther AppsOther DBs
User DB
User DB
User DBSlide7
Separating Concerns
Resource Governance
Collation
Distributed Queries
Authentication
Authorization
Security
Jobs
HA Setup
Instance/System
System Managed
CDB
Database
Server admin / System
Dev/App AdminSlide8
Contained Database: Where are we today?SQL AzureFully ContainedUncontained features turned off
SQL Server “Denali”Severed dependency on system settingsSplit metadata and data collationContained authenticationPartial Containment
Provided metadata showing uncontained uses.
Statically,
sys.dm_db_uncontained_entitiesDynamically, cdb_uncontained_usage XEventSlide9
Fixing CollationsCDBs introduce the catalog collationLatin1_General_100_CI_AS_WS_KSFixedCatalog collation used for all metadata
Variables, cursors, goto labelsTable names, Temp table namesDatabase collation used for all data
Table data
Temp table data (different from today!)
_SC
UTF-16Slide10
AuthenticationSQL logins → users with passwords.New user type.Not mapped to login.
Like a SQL login, it carries a password hash.But the hash is stored in the database.User is effectively guest on the instance.Authentication is direct to the CDB.
Windows logins are handled similarly.
No new user type...
...but need not have a matching login to authenticate.Slide11
demo CDB DemosSlide12
Data-tier Application Lifecycle
CREATE
TABLE
Orders
( id INT
,
ordTime
DATETIME,
. . .) --
ON OrdPS(ordTime)CREATE TABLE OrderEntr(
CREATE
TABLE Orders( id
INT, ordTime DATETIME,
. . .) -- ON
OrdPS(ordTime)
CREATE TABLE OrderEntr(Source Code
Contained Database
(CDB)
Definition
Runtime Container
Build
Extract
Deploy
Upgrade
Reverse
Engineer
DAC Framework Services
DACPACSlide13
Development and Management DifficultiesSchema and data portabilityMaintaining database script librariesVersioned deploymentsManagement at scaleSlide14
DAC and ContainmentDAC application model symmetrical with SQL AzureExtract, Build, and Export validate the modelThe model enables schema and data portabilityImport and Export services
Available as a CTP on http://www.sqlazurelabs.com/importexport.aspx Slide15
demo DAC portabilitySlide16
DAC – DevelopmentDevelop DACs inVisual Studio 2010SQL Server Development Tools Codename “Juneau”Based on Visual StudioDeclarative authoringIntelliSense
DesignersDeep ValidationVersioned buildsSlide17
demo Start developing with DACSlide18
DAC – Deployment and ManagementExtract, Deploy, and UpgradeIn-place upgrades (with SQL Azure Support) as ofVisual Studio 2010 SP1SQL Server 2008 R2 SP1 (CTP)Slide19
demo DAC upgradesSlide20
Wrap Up
Capability
SQL Azure
–
SQL Server “Denali”
SQL Azure
–
SQL Server “Denali” + 1
Symmetry
Incremental progressFullIsolationFull containment in AzurePartial containment in “Denali”Full containmentMovement,Deployment,
UpgradeDAC aligned to CDB (SQL Azure)DAC
Development Experience“Juneau”“Juneau”Slide21
SQL Azure
2011CDB and DAC, more features
Q&A
SQL Azure
2010
CDB, some features, DAC support
SQL
“Denali” + 1
Full CDB: Symmetry Across SQL Azure & SQL ServerSQL Server 2008: Existing DB Model
SQL Server & SQL Azure
app features
aligned
SQL Denali CDB: partial containment
SQL Server 2008
R2, DAC Support
SQL Azure
2012
CDB and DAC, most featuresSlide22
Database Platform (DAT) Resources
Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub.
Try the new SQL Server Mission Critical
BareMetal
Hand’s on-Labs
Visit the updated website for SQL Server
®
Code Name “Denali” on
www.microsoft.com/sqlserver
and sign to be notified when the next CTP is availableFollow the @SQLServer Twitter account to watch for updatesVisit the SQL Server Product Demo Stations in the DBI Track section of the Expo/TLC Hall. Bring your questions, ideas and conversations!
Microsoft® SQL Server® Security & Management
Microsoft® SQL Server® Optimization and ScalabilityMicrosoft® SQL Server® Programmability
Microsoft® SQL Server® Data Warehousing
Microsoft® SQL Server® Mission CriticalMicrosoft® SQL Server® Data IntegrationSlide23
Resources
www.microsoft.com/teched
Sessions On-Demand & Community
Microsoft Certification & Training Resources
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
Learning
http://northamerica.msteched.com
Connect. Share. Discuss.Slide24
Complete an evaluation on
CommNet
and
enter to win!Slide25Slide26
©
2011 Microsoft
Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment
on
the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation
. MICROSOFT
MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.Slide27