PowerShell Core for SQL Server: Automating Your Transact-SQL Scripts

Access SQL Server using PowerShell Core. This video will teach you how to execute Transact-SQL queries and return results, how to insert, modify and delete data from the database, as well as how to export and import data to and to SQL Server. You will be able to automate database administration tasks and other maintenance tasks by using PowerShell. These scripts are stored in files you can edit to meet changing business requirements. The video shows you where to download PowerShell Core and the Visual Studio Code environment, which is often used as a development platform. Next, you'll learn how install the module that allows communication between PowerShell Core and SQL Server. The fun begins when you learn how Transact-SQL statements can be executed and the results returned. The import and export of data is a common use case for PowerShell and SQL Server. This course concludes with examples that show how to do this. Transact-SQL scripts are also covered. These scripts are stored in text files that can be edited, making it easy for you to keep up with changing automation needs.