SQL Server 2012 Top Features
Querying Microsoft SQL Server 2012 http://www.pass4sureexam.co/70-461.html
About Pass4sureexam.co • BigData Consultant & Trainer – 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)
• 2012 Awards – Google Developer Expert – Google Cloud – MongoDB Master – 10Gen – ACM Distinguished Speaker - BigData – Melissa Data MVP – w/DQS
• Publications – Articles on BigData in MSDN Magazine – 3 books on SQL Server BI (latest on 2008)
• Certifications – MSFT – MCT, MCITP, MCSD, MCDBA, MCSE, MSF – 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 http://www.pass4sureexam.co/70-461.html
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
Mf
or S S
AS
http://www.pass4sureexam.co/70-461.html
Pow e rV iew
Sem & F antic ilet abl Searc h e
Ma Ser ster D vice ata s
Dat Ser a Qua vice lity s
B IS
C ol Ind umn-s fast ex (10 tore er) x-1 00x
Breakthrough Insights = Better Reports
http://www.pass4sureexam.co/70-461.html
Demo Columnstore Index
NoSQL on SQL Server
• xVelocity
• Wide-Column NoSQL store • Stores data in memory
• Types • Excel 2013 as PowerPivot • SQL Server 2012 as BI Semantic Model
http://www.pass4sureexam.co/70-461.html
Demo PowerPivot in Excel 2013
Demo PowerView
EIM on SQL 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
http://www.pass4sureexam.co/70-461.html
Demo SQL Azure – updated web portal
Data in the Cloud
http://www.pass4sureexam.co/70-461.html
Cloud on your Terms = Cloud Services Import / Export from SQL Azure Uses Windows Azure BLOBs
Simple data upload page To SQL Azure –OR-
ETL in the Cloud Data Explorer CTP
To Windows Azure
http://www.pass4sureexam.co/70-461.html
NoSQL Integration Connector for Hadoop Local Instance of Hadoop (beta)
http://www.pass4sureexam.co/70-461.html
Demo SQL Server 2012 on AWS RDS
AWS RDS with SQL Server 2012
http://www.pass4sureexam.co/70-461.html
Demo Windows Azure Marketplace
http://www.pass4sureexam.co/70-461.html
Big Data • HDInsight – Hadoop on Azure • Hadoop connectors for – SQL Server 2012 connector – download here – Excel Hadoop Interface (Hive or HQL integration)
http://www.pass4sureexam.co/70-461.html
Demo HDInsight (Hadoop on Azure)
http://www.pass4sureexam.co/70-461.html
Hive Connector to Excel
http://www.pass4sureexam.co/70-461.html
SQL Server Tooling Updates • • • •
SSMS = minor improvements SSDT replaces BIDS SSDT adds SDLC support for OLTP Powershell enhancements
http://www.pass4sureexam.co/70-461.html
Demo SSDT – SQL Server Data Tools for OLTP
http://www.pass4sureexam.co/70-461.html
T-SQL Enhancements Sequence generation Page Data (OFFSET/FETCH) Add ‘Throw’ to SEH Enhanced ‘Execute’ http://www.pass4sureexam.co/70-461.html
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) http://www.pass4sureexam.co/70-461.html
Engine and Data Type Enhancements Contained Databases • Partial containment • Support for HADR and SQL Azure Better Geospatial Types • • • •
Complex Shape Support Better Precision Adds Aggregates (i.e. UnionAggregate, more….) Spatial Index Improvements
XML and Hierarchy Data types • Methods and indices
Demo T-SQL and engine enhancements
http://www.pass4sureexam.co/70-461.html
Looking Forward – beyond 2012 • Writable Columnstore indices • Hadoop on Azure will go RTM • Data Explorer update for Excel 2013 • Other SQL PASS Summit 2012 announcements
http://www.pass4sureexam.co/70-461.html
An Overview Of MCSA: SQL Server 2012 • recipes)
http://www.pass4sureexam.co/70-461.html
Keep up with SQL Server 2012 admin@pass4sureexam.co
RSS my blog www.pass4sureexam.co Hire me • To help build your BI/Big Data solution • To teach your team next gen data solution
http://www.pass4sureexam.co/70-461.html
Pass4sure.co is a leading provider of IT certification and exams preparation materials, including labs imitations, guides, samples, Q&A, explanations, audio and video materials, case studies, etc. Practice 70-461 exam questions with answers. Instant 70-461 download. Updated frequently - free updates for 120 days 24/7 customer support. Real 70-461 exam environment simulation. Experience of more than 6 years The Astounding Pass Rate of 99.3% 71589 completely satisfied clients Pass 70-461 Exam in First Attempt
IT training, certification exam braindumps, PDFs, MP3 guides, video training. FREE downloads from Pass4sureexam. http://www.pass4sureexam.co/640-461.html
Pass4sureexam.co Exam Features:
50000+ Customer feedbacks involved in Product. Average 100% Success Rate. Over 170 Global Certification Vendors Covered. Services of Professional & Certified Experts available via support. Free 90 days updates to match real exam scenarios. Instant Download Access! No Setup required. Exam History and Progress reports. Verified answers researched by industry experts. Study Material updated on regular basis. Questions / Answers are downloadable in PDF format. Practice / Exam are downloadable in Practice Test Software format. Customize your exam based on your objectives. Self-Assessment features. -Guaranteed Success.
Fast, helpful support 24x7.
http://www.pass4sureexam.co/640-461.html
http://www.pass4sureexam.co/640-461.html