Alejandro Cobar

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.