Table of Contents. Presentation: Introduction to SQL Server This presentation provides an overview of the key improvements in SQL Server from a developer perspective in the context of Microsoft's overall platform strategy. SSDT makes it easy to develop powerful database solutions that target both your on-premise environment and the cloud.
In this four part demo, we'll take an initial look at some of the most exciting new improvements in this important release, and demonstrate how SQL Server can help cloud optimize organizations of all sizes. First, we'll show you how AlwaysOn support for readable secondary replicas improves resource utilization. Next, we'll show you how Data Quality Services and the Windows Azure Marketplace can help ensure that all of your data is accurate and compliant.
Then, we'll show you how SQL Server Data Tools delivers a rich new modern developer experience for building database applications that target your on-premise environment or the cloud.
Finally, we'll show you how SQL Azure Data Sync can help ensure that key data sets are available where you need them and when you need them. The Availability Group Listener provides the Virtual Network Name that enables the automated seamless failover capabilities to applications using the Availability Group databases, as well as the read-only routing capabilities for Read Only Secondaries. Demo: Maximizing Hardware Utilization with SQL Server AlwaysOn Readable Secondary Replicas This demonstration shows how to configure readable secondary replicas in an availability group to maximize hardware utilization by offloading read only workloads, and how to extend seamless failover capabilities to read only workloads using read only routing.
Presentation: Introducing SQL Server Columnstore Indexes Columnstore indexes provide an easy way to significantly improve data warehouse and decision support query performance against very large data sets. Demo: Accelerating Data Warehouse Queries with SQL Server Columnstore Indexes This demonstration shows how to implement Columnstore Indexes, establish the performance impact for a standard data warehouse query and lastly show how to modify rows for a table with a Columnstore Index using partitioning.
Presentation: Introducing SQL Server Table Partitioning Improvements SQL Server offers several important improvements that related to table partitioning, including more partitions per table, improved online operations, better index build performance and new wizards. Presentation: Introducing SQL Server Security and Auditing Improvements In this presentation we'll cover SQL Server improvements that impact security and auditing, including new support for default schema for groups, user-defined server roles and various auditing improvements.
In five minutes we'll walk through how to create a role, add members, remove a member, grant permissions to the role and change the role name. Along the way we'll validate the changes we've made using security catalog views. Presentation: Introducing SQL Server Spatial Improvements Developers who exploit spatial data types in their applications will find some helpful improvements in SQL Server , including support for new shapes and methods, full globe support and spatial index enhancements.
Once content is managed by SQL Server, exciting new search scenarios can be powered by full text search and statistical semantic search. LocalDb is a small shared component not a service that installs in five minutes or less that is ideal for applications or tools that need an embedded database that is API compatible with SQL Server. Hands-On Labs. It also shows how to create an offline database project based upon an existing database, make changes to it, and test it locally using the integrated Local Database Runtime LocalDb.
This presentation will talk about what's new with DAC Fx including support for in-place upgrades, integration with SSDT, support for new objects and more. Prior releases of DAC Fx only supported side-by-side upgrades. Assess your skills with practice tests. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook. Download the sample content. If you have problems attaching a sample database, you can find complete instructions for attaching databases here. We've made every effort to ensure the accuracy of this book and its companion content.
Any errors that have been confirmed since this book was published can be downloaded below. Download the errata. If you find an error, you can report it to us through our Submit errata page. Sign in. Your cart.
This eBook includes the following formats, accessible from your Account page after purchase: EPUB The open industry format known for its reflowable content and usability on supported mobile devices. Downloads Download the sample databases To complete the practices in this Training Kit, you need to download two sample databases. This eBook includes the following formats, accessible from your Account page after purchase: EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
Downloads Follow the instructions to download this book's companion files or practice files. Click the Download button below to start the download. If prompted, click Save. Locate the. Right-click the file, click Extract All, and then follow the instructions. Open the script file TSQL When the script finishes executing, you should find the database TSQL listed in the Available Databases drop down box. Errata We've made every effort to ensure the accuracy of this book and its companion content.
Download the errata If you find an error, you can report it to us through our Submit errata page.
0コメント