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

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

Microsoft Windows PowerShell is a command-line shell and scripting language with more than 130 standard command-line tools and consistent syntax and utilities. The new feature runs on Windows XP, ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Back in 2008, I wrote a piece called PowerShell Tips and Tricks, which covered the then-relatively new Windows scripting language and some cool things you could do with it. Although PowerShell has ...

PowerShell can save you a lot of time on Windows admin tasks, but to use it effectively you need to understand how it works. Here’s a crash course in Windows PowerShell scripting basics to get you ...