To wrap up this series of PowerShell articles, let's take a look at a few tips ... using this script: This script simply creates an array, which holds all of the SQL Server related assemblies ...

let's take a brief look at all of the nodes in the PowerShell provider for SQL Server. Along the way, I'll highlight particularly useful areas. To explore the provider, simply open SQLPS.exe.

Either way, you can choose to spend time working in SQL Server Management ... database or you can look at alternative approaches that leads to automating some of your repetitive day-to-day activities.

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

When I (along with many other people) had a lot of trouble trying to install SQL Server ... looks pretty darned GUIish to me. TechNet seems to agree with me, as it says, "In Windows PowerShell ISE, ...

It is, however, a good starting point to show you the types of tasks that make sense for PowerShell. Sean McCown is a Certified Master in SQL Server and a SQL Server MVP with 20 years of ...