GitHub

sql-server-powershell.md

There are two SQL Server PowerShell modules; SqlServer and SQLPS. The SqlServer module is the current PowerShell module to use. The SQLPS module is included with the SQL Server installation (for ...
MCPmag

Introduction to SQL Server Management Objects with PowerShell

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...
GitHub

run-a-powershell-v3-script-from-a-sql-server-agent-job.md

As was just mentioned, PowerShell within SQL runs Version 2. If you were unaware that you could run PowerShell from within SQL Server Management Studio (SSMS), right-click on a folder, and select ...
MCPmag

PowerShell vs. SQL Server Management Studio

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...
Redmond Magazine

Getting Started with Dbatools for SQL Server

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...
Redmond Magazine

Under the Hood of the SQL Server PowerShell Provider

Throughout this series of posts there have been a number of examples of how to use the SQL Server PowerShell provider. However, these were always in context with a specific task (i.e. automating ...
InfoWorld

When you should and shouldn’t use PowerShell in SQL Server

PowerShell is cool, but it's not always appropriate. Here's a quick list to help you decide when to use it PowerShell is one of the coolest new things to come out of Microsoft in a long while, and ...