Exploring Microsoft SQL Server 2012

with Don Kiely


Course Description: With each new release of SQL Server, Microsoft makes the product better and bigger, and SQL Server 2012 is no exception. This new version has new and better features that support even more data scenarios than ever before, while keeping your data more secure, available, and even cleaner. Transact-SQL is better than ever before, and there are better tools for letting both admins and users make better use of the data to support critical decisions. There’s a lot to like, even as the product grows enormous.



8+ hours of media runtime

Introducing SQL Server 2012

  • Editions
  • Operating System Requirements
  • SQL Server Installation

Manageability and Administration

  • SQL Server Configuration Manager
  • Management Studio Enhancements
  • Restore Pages
  • SqlCmd in XML Mode
  • New and Changed DMV's
  • Changes to PowerShell Support
  • Partially Contained Databases
  • Data Quality Services
  • Data-Tier Application (DAC) Enhancements
  • Master Data Services
  • Column Store Indexes

Development and Programming

  • Native XML Web Services Removed
  • Full-Text Search
  • Statistical Semantic Search
  • FileTables in FILESTREAM
  • SQL Express LocalDB
  • SQL Server Data Tools

T-SQL Enhancements

  • EXECUTE Statement Metadata
  • Ad-hoc Query Paging
  • Spatial Data Enhancements
  • Sequence Numbers
  • New Built-in Functions
  • Window Functions in the OVER Clause
  • New Analytic Functions
  • New Query Optimizer Hints
  • THROW Statement

Security

  • Data Protection
  • Security Management
  • Authentication
  • Auditing

Business Intelligence Enhancements

  • Analysis Services
  • Integration Services
  • Reporting Services

Get our entire learning library

ONLY

$49
.99
per year

Visual Studio, ASP.NET, SQL, SharePoint and more...
  • 3,400+ video tutorials
  • Microsoft MVP's and experts
  • Future video releases FREE
  • 100% money-back guarantee


Not ready to buy? Try now