Data-Tier Applications in SQL Server 2008 R2 and Visual Studio 2010

grrrgrapeInternet and Web Development

Oct 31, 2013 (3 years and 7 months ago)

61 views

Data
-
Tier Applications

in SQL Server 2008 R2

and Visual Studio 2010

Meir Dudai

Valinor


http://www.SQLServer.co.il/

twitter
:
@SQLServercoil


Database evolution

1990

2000

2010

Underutilized
hardware

Overburdened
Administrators

Having fun with deployment

Who Am I?

Meir Dudai


SQL Server consultant


Valinor


Working with SQL Server for
10 years


Editor of
SQLServer.co.il



Agenda


What is DAC


Live demo


Utility Control Point


Q&A


Summary

Challenges

Development



No uniform DB project
system and
workflow

Deployment



DBAs
and Developers
work in
silos


Time
consuming and
error
prone

Management



Difficult to centrally
control the
environment


Investments

Development



Data
-
tier Application project


Integrated
editor,
debugger,
IntelliSense, policy designer


Static
code
analysis, build
service

Deployment



Easier to deploy and
upgrade Data
-
tier
Apps from VS and
SSMS


Management



Manage @
Scale: SQL
Server
Control Point


Visualize
resource
utilization at the
instance & application
level

Concepts
-

Data
-
tier Application
Project



New
project type in VS
2010
; Leverages Database project
system code base


First class T
-
SQL/DAC development experience in Visual
Studio

Concepts


.
dacpac

= unit of deployment
(data
-
tier application +
developer intent)


Data
-
tier Application
Component


Improves collaboration
between developer and DBA


Moves developers from a
procedural

model to a
declarative

model



V1 is targeted at
small apps


Schema

LOGICAL

Tables
,
Views
,
Procs
,
UDFs


PHYSICAL

Users
,
Logins,
Indexes

DAC Deployment Profile

Deployment
Requirements,
Management
Policies

Unit of Deployment

Database
Project vs
.
DAC Project

Data
-
tier Application Project V
1

(Small Apps)

Visual
Studio

Build

.
dacpac

Database Project

(Mission Critical, Business Critical)

Visual
Studio

.
dbschema

Build

Deploy

Deploy

Generate
scripts

Data
-
Tier Application

Key Concept: SQL Server Utility




DBA

SQL02

SQL03

SQL04

SQL
01

Managed Instances

SQL05

UCP

Utility Control Point (UCP)


Central reasoning point
of the
utility


Central policy
evaluation, deployment,
impact, and what if
analysis can be
performed


Simple to setup and use


DBA

SQL Server Management Studio

Managed
Instances

HR

Control

Point

SALES

DEVELOP

DEPLOY

MANAGE

Visual Studio 2010

Developer

FinApp

Prod DB

DBA

SQL Server Management Studio

FinApp

Dev

DB

Reverse
Engineer
DAC

Create
policies

Deploy /

Upgrade
DAC

.
dacpac

Compile

+ Build

Hand
-
off to DBA

Deploy /

Upgrade
DAC

Manage, Register,
Uninstall, Extract,
Upgrade DAC

Summary


What is DAC


Live demo


Utility Control
Point

Summary


Deployment becomes
easy using
DAC


Try out these new
features, download:


SQL Server
2008
R
2


Visual Studio
2010