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 ...
GitHub

work-with-sql-server-powershell-paths.md

You can run Windows PowerShell cmdlets that operate on nodes, such as Rename-Item. You can call the methods from the associated [!INCLUDEssNoVersion] management object model, such as SMO. For example, ...
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 ...
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 ...
Redmond Magazine

PowerShell-Based SQL Server Backups Revisited, Part 2

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...
InfoWorld

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

Use PowerShell a group of servers when their registration properties are different from what you would ordinarily keep, or when it’s changing constantly. In other words, if you have certain server ...
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 ...