[MUSIC]
Hi, my name is Luis Vargas.
I am principal program manager on the SQL Server team.
I work with Azure to make sure that Azure is the best platform in
the world to run SQL Server.
So I'm gonna show you a demo how easy it is to open a free trial and
start using SQL Server on virtual machines in Azure.
So let's check the demo.
The first thing to do is open a free trial in Microsoft Azure,
you can do this at azure.microsoft.com.
Here you can start a free credit of $200.
And after this, we can go into the Azure portal, portal.azure.com, and
create a virtual machine with SQL Server.
So you can see here I have a free trial.
And all I have to do is go to New, Databases,
See all feature apps, and there you'll find SQL Server.
Here you will see the list of all the different images that we have
for all the version of SQL Server, and all divisions of SQL Server.
Given that this a trial, I want to start with the free license
SQL Server Developer Edition.
This means that I won't have to pay any SQL licensing, and
I simply will pay for the cost of the running the virtual machine.
So I'm going to start with SQL Server 2016 SP1.
I hit Create, and I wanna specify some basic information for
the virtual machine.
For example, my SQL Server virtual machine,
I'm gonna specify the type of the storage.
So gonna select SSD as the fastest storage, the name for
my administrator.
A password.
Then the resource group which is just a logical container for
the resources that I will create inside of Azure.
I'm gonna say my resource group, and then the location.
So we have many different locations around the world
where you could create your virtual machine with SQL Server.
So we're gonna select West US in this case.
Next, I will select the size of the virtual machine.
So there are many different sizes, all right?
I can select View All, and
see even a longer list of virtual machine sizes.
In this case, I'm going to select DSV2, which is a small
virtual machine with just one core and 2.5 gigabytes of memory.
So I'll select this one.
Now there are many
different settings associated with the virtual machine.
For example if I want to create an IP address that is available over
the Internet, I'm going to select OK.
I'm moving to SQL Server settings.
Here you will find the SQL Server configuration for
your virtual machine.
You can specify how to connect to SQL Server.
For example,
if I want to connect from my laptop using SQL Server Management Studio,
I will select Public, then the port where you'll connect to SQL Server.
If you want to authenticate to SQL Server using a specific
user name in SQL.
So in this case given that I'm going to connect from a different domain,
I will specify authentication with SQL Server.
Next, you can configure the storage.
So I'm just going to use the default storage, which is 3,200 IOPS,
48 megabytes per second, and 1 terabyte of storage.
And finally I could configure automated patching, for example,
if I want to patch SQL Server and Windows at specific point in time.
And automated backup, if I want to automatically take backups for
my SQL Server virtual machine.
I can specify to keep backups for
30 days, to encrypt my backups if I want to, to backup system databases.
And also to specify when exactly when my full backups and
low backups should be taken, or if I want SQL Server to decide for me.
I'm gonna select this, and
here you can see a summary of all the settings that I have specified.
I a virtual machine running with SSD drives, it's
connected to SQL Server 2016.
The SQL port is gonna be 1433.
I'm going to enable SQL authentication to connect from
a different domain, and I'm gonna have 1 terabyte of storage.
Automated patching is enabled on Sundays at 2 in the morning.
Automated backup is enabled as well, and my backups are gonna be kept for
30 days.
At this point, I can click OK, and in approximately five minutes or so,
I'll have a virtual machine running SQL Server that I can start using.
Now that you have watched the video,
take advantage of the $200 free trial in Azure.
Spin a free SQL developer image, and finally, try SQL Server on Linux.
Thanks for watching this video, I hope you find it useful.
[MUSIC]