SQL Server 2012 New Features

SQL Server 2012 is the first cloud-ready information platform for Microsoft. In this course, author Martin Guidry explores its new possibilities, showing you how to protect, unlock, and scale the power of your data, and work with a variety of devices and data sources. The course also provides an overview on obtaining, installing, and running SQL Server 2012 and will be of immense interest to anyone considering upgrading or installing this latest edition.

 Topics include:

• Choosing an edition
• Finding and downloading SQL Server 2012
• Using FileTables to enhance FileStream
• Searching unstructured data semantically
• Searching text
• Exploring the Watch, Quick Watch, and Quick Info windows
• Creating user-defined server roles
• Understanding the changes to replication
• Exploring new types of indexes and new options on indexes
• Accommodating changes to database structure

Table of content 

Introduction

• Welcome
• What you should know
• Using the exercise files

Getting Started

• Finding and downloading SQL Server 2012 Express edition
• Setting up the SQL Server 2012 Express edition environment

Database Engine Improvements

• Using FileTables to enhance FileStream
• Exploring the new semantic search for unstructured data
• Exploring enhancements to full text search
• Implementing ad-hoc paging with offset and fetch
• Using the new throw statement to enhance try-catch blocks

Improvements to SQL Server Management Studio Debugging

• Using breakpoint condition, breakpoint hit count, breakpoint filter, and breakpoint action
• Exploring the Watch, Quick Watch, and Quick Info windows
• Reviewing Transact-SQL IntelliSense improvements

Changes to the Scope of Objects

• Understanding changes to user passwords and logins
• Creating user-defined server roles
• Understanding auditing

High Availability from the Developer’s Point of View

• Exploring AlwaysOn
• Examining changes to replication

Licensing

• Choosing an edition
• Licensing SQL Server 2012 in a non-virtual environment
• Licensing SQL Server 2012 in a virtual environment

Additional Changes

• Introducing new conversion, logical, and string functions
• Understanding changes to hardware and operating system support
• Exploring new types of indexes and new options on indexes
• Understanding new administrative options
• Accommodating changes to database structure

Conclusion

• Goodbye

Letitbit.net

1. http://bit.ly/1dNP90D

 Uploaded.net

1. http://ul.to/ev1h7mbw

Cloudzer.net

1. http://clz.to/file/lmuorgz0

Rapidgator.net

1. http://bit.ly/1buXAvu