PowerShell

In this article, we look at how to query multiple Azure SQL Databases and store all the results in a centralized location.

Learn how to schedule and automate your PowerShell scripts using either SQL Server Agent or Windows Task Scheduler.

Learn using these PowerShell scripts in SQL Server to get instance details, create backups, manage SQL Server jobs, start an instance and more.

In this article we look at how to use PowerShell pipelines to pass output from one command to another PowerShell command along with several examples.

In this article we learn about the basics of PowerShell cmdlets, what they are, how to use them and what is available specifically for SQL Server.

In this article we look at how to get started writing functions in PowerShell along with several basic examples to get you started.

In this article we look at how to iterate over code in PowerShell using several different methods like: for, foreach, while, do until, and do while.

In this article learn how to use if then logic in PowerShell scripts with several examples of using if, if/else and switch statements.

Learn about using variables in PowerShell scripts with these different examples that cover data types, scope, naming, assigning values and more.

In this article we cover some basics about getting started with PowerShell and different ways that a PowerShell script can be executed.

Learn about some of the uses for PowerShell when managing SQL Server and why a DBA should be using PowerShell to manage SQL Server.

In this article we look at a PowerShell that will help you automate testing of your SQL Server database backups.

In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.

Learn how to execute SSIS packages with PowerShell stored in the cloud and how to execute packages with PowerShell that use Package Deployment Model.

In this article we look at a PowerShell script that will read SQL Server build numbers from a web page and present the data in a easy to use manner.

In this tip we cover how to run an SSIS package using PowerShell with an environment from the SSIS catalog and with T-SQL stored procedures from the SSIS catalog.

In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.

In this tip we look at different ways to create a new SQL Server database using PowerShell.

In this tip we will look at the basics of file encoding, both for reading and writing using PowerShell.

In this tip we look at how we can use PowerShell to validate input values into SQL Server stored procedures prior to execution of the stored procedure.

In this tip we look at how to use PowerShell scripts to work with files to get properties, copy, update and delete.

In this tip we will look at getting started using PowerShell with stored procedures.

In this tip we look at some PowerShell commands you can use to create file contents whether directly entered or queried from a SQL Server database.

In this tip we look at a PowerShell script that can be used to compare actual files that exist against a list of files that should exist for a project to identify any missing files.