However, this time I specified a few different parameters instead to reflect it was using the vCore purchase model. Again, I created a resource group, deployed a logical server and used the New-AzSqlDatabase cmdlet. Next, I deployed an Azure SQL database based on the vCore purchase model. In addition, I was able to state that it was based on the AdventureWorksLT database and it still used the least number of parameters. So I had a decent amount of functionality without using too much Azure credit. Furthermore, I deployed the S0 performance tier. I deployed the database using the New-AzSqldatabase cmdlet, which is part of the Az module. I created the resource group, deployed the logical server and then finally the database.
Azure SQL Database DTU modelĭeploying a single Azure database using the Azure DTU model was certainly the easiest. Starting to the least complex to the most, which highlights things you should be aware of. You can read my previous review about ARM templates in detail here.īelow is an overview of how my testing went in order of complexity. Because at the end of the script I could delete the resource group ten minutes after the deployed items. However, I thought I would keep it simple with Powershell scripts. Of course, I could have used Azure Resource Manager templates instead. Which I discussed in a previous post here. To clarify, the Az module is the replacement for previous Powershell modules for Azure. In addition to using a standard Visual Studio Professional subscription, I decided to do all the deployments using the most recent Az module for Powershell. Powershell module used to deploy SQL Services to Azure Because Microsoft explain it clearly for most offerings here. I decided not to test virtual machine deployments and focused on PaaS offerings instead.įurthermore, I decided not to focus on the pricing much. I decided to focus on some of the Azure related services, which I had discussed in a previous post here.
Which subscription do you use for Dev/Test purposes the most?- Kevin Chant April 24, 2019 Doing an #Azure survey for those who work with Data Platform/ #sqlserver offerings.
0 kommentar(er)
