Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Use PowerShell to Clean-up SQL Server Jobs

Summary: SQL Server MVP, Sean McCown, shows how to use Windows PowerShell to clean-up SQL Server jobs. Microsoft Scripting Guy, Ed Wilson, is here. Today we wrap up the weekend with the last of three blogs by guest blogger, Sean McCown. You can read more about Sean and his previous guest blogs on the Hey, Scripting Guy! Blog site. Take it away...

Use PowerShell to Examine Dirty and Expensive SQL Server Properties

Summary: SQL MVP, Sean McCown, talks about using Windows PowerShell to examine Dirty and Expensive SQL Server properties. Microsoft Scripting Guy, Ed Wilson, is here. Here is blog two of three in a series from guest blogger, Sean McCown. Yesterday, we published Use PowerShell to Work with SQL Server Instance-Level Properties. You can read more...

Use PowerShell to Work with SQL Server Instance-Level Properties

Summary: SQL Server MVP, Sean McCown, talks about using Windows PowerShell to work with SQL Server instance-level properties. Microsoft Scripting Guy, Ed Wilson, is here. Today is the first of three blogs written by guest blogger, Sean McCown. You can read more about Sean and his previous guest blogs on the Hey, Scripting Guy! Blog site. Here&...

Using PowerShell to Add a Group of Users to a SQL Database

  Summary: Learn how to use Windows PowerShell to add a group of users to a SQL Server database.   Today is the final day of SQL guest blogger week. It was great to enter the SQL side of life. Sean McCown is our guest blogger for today. Sean McCown holds a double MCITP in SQL Server 2008 for both Administration and Development. He is...

Use PowerShell to Administer SQL Server 2008

  Summary: Microsoft MVP Sean McCown shows how to use Windows PowerShell to administer remote SQL Servers using easy commands.   (image) Hey, Scripting Guy! I am an extremely busy database administrator (DBA), and at a recent SQL Saturday event, I heard several people talking about Windows PowerShell. I did not, however, attend any ...