This course covers how to manage your Azure SQL instance from PowerShell. You'll learn how to set up and configure SQL Servers, migrate local databases to Azure, and run SQL Scripts against your Azure SQL servers.
Azure SQL is a powerful database platform, providing a stable environment to migrate your local SQL Server databases to the cloud. PowerShell is key to that effort, letting you automate the migration process as well as maintenance. In this course, Azure PowerShell Playbook: Azure SQL, you'll explore how to set up a SQL Server in Azure SQL and configure its firewall. First, you'll learn how to migrate an on-premises database to your new Azure SQL Server. Along the way, you'll discover how to set up resource groups and storage accounts, as well as automating the export of your local databases to bacpac files. Next, you’ll learn how maintenance is a key component to managing your Azure SQL installation, so you will see techniques for applying multiple SQL scripts against your Azure SQL. Finally, Azure can get expensive, so you'll learn how to remove everything you've created, both individually and in bulk, so you can manage your valuable resources only using them when needed. By the end of this course, you'll have a better understanding of how to utilize PowerShell to manage your Azure SQL databases.
Robert C. Cain (arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books.
Course Overview Hi everyone. My name's Robert Cain. Welcome to my course, Azure PowerShell Playbook: Azure SQL. I am the owner of Arcane Training and Consulting, and a Microsoft Data Platform MVP. PowerShell is an essential tool in working with Azure. As a data professional, it will be vital that you know how to interact with the Azure SQL platform with PowerShell. Some of the major topics that we will cover include creating resource groups and storage accounts; creating a SQL Server in Azure SQL, including the creation of firewall rules; migrating a local SQL Server database to Azure SQL; applying additional SQL scripts against your Azure SQL databases; and finally, removing the Azure SQL objects you've created in order to save money. By the end of this course, you should be comfortable with the terminology and concepts in working with Azure SQL. In addition, the code samples will make for a useful code library as you begin working with Azure SQL. Before beginning the course though, you should be comfortable with the basics of PowerShell, as well as how to log in to Azure from PowerShell. I hope you'll join me on this journey to learn how to use PowerShell with Azure SQL with my course, the Azure PowerShell Playbook: Azure SQL.