70-461 Querying MicrosoGet Latest Pass4sure 70-461 Querying Microsoft SQL Server 2012

SQL Server 2012 Top Features

Querying Microsoft SQL Server 2012 http://www.pass4sureexam.co/70-461.html

About Pass4sureexam.co •

BigData Consultant & Trainer  –  –  –

•

2012 Awards  –  –  –  –

•

Google Developer Expert  – Google Cloud MongoDB Master – 10Gen ACM Distinguished Speaker - BigData Melissa Data MVP – w/DQS

Publications  –  –

•

With Customers as Architect for Manufacturing, Education, Finance, Startups Production work on SQL Server 6.5 -> 2012, MongoDB, AWS Hadoop, GAE Former Microsoft Developer Evangelist (4 years)

Articles on BigData in MSDN Magazine 3 books on SQL Server BI (latest on 2008)

Certifications  –  –

MSFT – MCT,  MCT, MCITP MCIT P, MCSD, MCDBA, MCSE, M CSE, MSF MS F Cloudera (Hadoop)  – CCDH

http://www.pass4sureexam.co/70-461.html

3 Core Areas + 1 more… Mission-Critical • Always On • Engine Enhancements

Breakthrough Insights • Business Intelligence / Reporting • Beyond Relational - NoSQL

Cloud on your terms • Azure Integration

Engine Enhancements • Core engine – T-SQL • Beyond Relational – XML, Hierarchy, more

Mission Critical •

HADR – better mirroring via Availability Group

•

Easier partitioning, compression, encryption

•

Management via policies and tools  –

UCP health monitoring

 –

Policy-based management

 –

DacPac improvements

 –

New DMVs, extended events

 –

New Profiler events http://www.pass4sureexam.co/70-461.html

Mission Critical = Always On Availability Groups

High Availability

Policy-based failover Mirroring (failover) of groups of databases

Data Distribution

Multiple (readable) Secondaries

Async Secondaries

http://www.pass4sureexam.co/70-461.html

http://www.pass4sureexam.co/70-461.html

How To set up HADRON – Availability Groups

Breakthrough Insights = Better Reports

http://www.pass4sureexam.co/70-461.html

http://www.pass4sureexam.co/70-461.html

Demo Columnstore Columnstor e Index

NoSQL on SQL Server •

•

xVelocity •

Wide-Column NoSQL store

•

Stores data in memory

Types •

Excel 2013 as PowerPivot PowerPivot

•

SQL Server 2012 as BI Semantic Model

Demo PowerPivot in Excel 2013

Demo PowerView

EIM on SQL Server Server •

DQS – Data Quality Services

•

MDS – Master Data Services

•

DE – Data Explorer

•

CT – Change Tracking

•

CDC – Change Data Capture

•

SSIS Enhancements

http://www.pass4sureexam.co/70-461.html

http://www.pass4sureexam.co/70-461.html

Demo New BI Semantic Model in SSAS

Demo SSDT – SQL Server Data Tools (new BIDS)

http://www.pass4sureexam.co/70-461.html

http://www.pass4sureexam.co/70-461.html

Demo New in EIM - Data Quality Services

http://www.pass4sureexam.co/70-461.html

Demo Data Explorer – ETL for all

Cloud on your Terms = SQL Azure SQL Server Data Tools for Visual Studio Version targeting Stand-alone or integrated into VS2010

Data Sync

Cloud

SSRS hosted on Azure

CTP

On Premises

http://www.pass4sureexam.co/70-461.html

SQL Azure improvements

Federations

Max size increase to 150 GB