آموزش ویژگی های جدید در اس کیو ال 2012

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 Introduction 2m 0s Welcome 55s What you should know 35s Using the exercise files 30s 1. Getting Started 7m 40s Finding and downloading SQL Server 2012 Express edition 1m 52s Setting up the SQL Server 2012 Express edition environment 5m 48s 2. Database Engine Improvements 28m 20s Using FileTables to enhance FileStream 8m 38s Exploring the new semantic search for unstructured data 10m 4s Exploring enhancements to full text search 2m 16s Implementing ad-hoc paging with offset and fetch 2m 57s Using the new throw statement to enhance try-catch blocks 4m 25s 3. Improvements to SQL Server Management Studio Debugging 12m 50s Using breakpoint condition, breakpoint hit count, breakpoint filter, and breakpoint action 5m 23s Exploring the Watch, Quick Watch, and Quick Info windows 3m 8s Reviewing Transact-SQL IntelliSense improvements 4m 19s 4. Changes to the Scope of Objects 12m 24s Understanding changes to user passwords and logins 5m 37s Creating user-defined server roles 2m 21s Understanding auditing 4m 26s 5. High Availability from the Developer's Point of View 7m 23s Exploring AlwaysOn 5m 6s Examining changes to replication 2m 17s 6. Licensing 12m 56s Choosing an edition 4m 53s Licensing SQL Server 2012 in a non-virtual environment 5m 19s Licensing SQL Server 2012 in a virtual environment 2m 44s 7. Additional Changes 24m 38s Introducing new conversion, logical, and string functions 7m 9s Understanding changes to hardware and operating system support 3m 26s Exploring new types of indexes and new options on indexes 5m 10s Understanding new administrative options 6m 12s Accommodating changes to database structure 2m 41s Conclusion 2m 1s Goodbye 2m 1s