SQL Server 2012 Top FeaturesToward Data Craftsmanship@LynnLangit

3 Core Areas

Breakthrough Insights

Mission-Critical

Cloud on your terms

Breakthrough Insights = Better BIPo

wer

View

New

sem

antic

se

rver

mod

el

for S

SAS

Data

Qua

lity

Serv

ices

Mas

ter D

ata

Serv

ices

Colu

mn-

stor

e In

dex (

10x-

100x

fast

er)

Sem

antic

Se

arch

&

Filet

able

DemoData Explorer – ETL for all

DemoNew BI Semantic Model in SSAS

DemoData Quality Services

Mission Critical = Always On

High Availability

Data Distribution

Mirroring (failover) of groups of databases

Availability Groups

Policy-based failover

Multiple (readable) Secondaries

Async Secondaries

How To set up HADRON – Availability Groups

Cloud on your Terms = SQL Azure

SQL Server Data Tools for Visual

Studio

Version targeting

Stand-alone or integrated into VS2010

Data Sync

Cloud

On Premises

SSRS hosted on Azure

CTP

SQL Azure improvements

Federations

Max size increase to

150 GB

DemoSQL Azure – updated web portal

DemoSSDT – SQL Server Data Tools

Data in the Cloud

Cloud on your Terms = Cloud Services

Import / Export from SQL Azure

Uses Windows

Azure BLOBs

Simple data upload page

To SQL Azure –OR-

To Windows Azure

ETL in the Cloud

Data Explorer CTP

NoSQL Integration

Connector for Hadoop

Local Instance of Hadoop (testing)

Windows Azure DataMarket

Big Data Integration

• Hadoop connectors for– SQL Server 2008 connector – download here– Excel Hadoop Interface (Hive or HQL integration)

Hadoop Connector to Excel

T-SQL Enhancements

Sequence generation

Page Data (OFFSET/FETCH)

Add ‘Throw’ to SEH

Enhanced ‘Execute’

New T-SQL Functions• String Functions (CONCAT and FORMAT)• Logical Functions (CHOOSE and IIF)• Date and Time Functions (EOMONTH and

more)• Conversion Functions (PARSE and

TRY_CONVERT and TRY_PARSE)

Engine and Data Type Enhancements

• Partial containment• Support for HADR and SQL Azure

Contained Databases

• Complex Shape Support• Better Precision• Adds Aggregates (i.e. UnionAggregate, more….)• Spatial Index Improvements

Better Geospatial Types

DemoT-SQL and engine enhancements

Resources• SQL Server 2012• BigData Information – Hadoop…• Other SQL Server Courses

www.Develop.com

TeachingKidsProgramming.orgDo a Recipe Teach a Kid (Ages 10 ++)Microsoft SmallBasic Free Courseware (recipes)

DONATE

Follow me @LynnLangit

RSS my blog www.LynnLangit.com

Hire me•To help build your BI/Big Data solution•To teach your team next gen data solution

Keep up with SQL Server 2012