From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 25,300 courses taught by industry experts.
Set up Stretch Database - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Set up Stretch Database
- [Instructor] In this section, we're going to talk about a new feature in Microsoft SQL Server 2016, and it's called Stretch Database. When we stretch a database, it allows us to store some of the data on the local server and some of the data in the Microsoft Azure cloud. We'll need to do a little preparation for this. Your Azure account will need to have access to the namespace Microsoft.SQL. If you've ever used the SQL Azure service, that namespace has probably already been added to your account. If not, you can add access via PowerShell or the Azure CLI. You can download the Azure CLI from Microsoft. Once you've done that, you can open a Command Prompt, type in "azure" and then type in "azure provider register Microsoft.SQL." And when you run that, the provider will be registered, and you'll now have access to the Microsoft.SQL namespace. That should be all you need to do to your Azure account. We'll also need to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.