What's new in SQL Server 2012 - free virtual seminar

Microsoft Training Partner QA is a running free 90-minute virtual seminar on 21 and 23 March (am and pm), highlighting what's new in SQL Server 2012.

An outline is provided below, or you can find more information and booking details on the QA website.

Overview

A complete and integrated database server and information platform, the much anticipated release of Microsoft SQL Server 2012 enables organisations to get more value out of existing IT skills and assets, increase the productivity and agility of IT departments, and quickly build flexible, innovative applications.

As a cloud-ready information platform, Microsoft SQL Server 2012 will help organisations build solutions to extend data across on-premises and public cloud backed by mission critical confidence. Overall SQL Server 2012 brings higher levels of database server performance, availability, and security; more productive management and development tools; and increased business intelligence (BI) capabilities.

This 90 minute virtual seminar will provide attending delegates an overview of the new and improved features of Microsoft SQL Server 2012 an insight into the new features that could impact current and future SQL implementations. The seminar will close by providing an update on the latest Microsoft Official SQL Server 2012 Courses and Certifications – and how QA can help with your SQL Server 2012 skills needs.

SQL Server 2012 New Features – Administration

  • Always-On for availability and disaster recovery – Always On
  • Improved security and role assignments
  • Self-contained and manageable databases – Contained databases

SQL Server 2012 New Features – Business Intelligence

  • Power View to enhance user insight into the data using rapid data exploration
  • BI Semantic Model : a different way of creating and maintaining data structures to allow data exploration
  • Enhanced change data capture (CDC) using SSIS for incremental data warehouse loads
  • Improving the quality of data during the loading process using Data Quality Services (DQS)
  • Maintaining the integrity of important data which is central to your company and shared by many systems using the enhanced – Master Data Services (MDS)

SQL Server 2012 New Features – Development

  • ColumnStore indexes
  • Window frames and improved analytic functionality
  • Improved spatial data
  • Filetable
  • Sequences
  • Semantic searches
  • Distributed replay

SQL Server 2012 Training Courses and Certifications