Summary: Microsoft MVP Sean McCown shows how to use Windows PowerShell to administer remote SQL Servers using easy commands. 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 of the Window...
Hey, Scripting Guy! I have several items I have to check daily on my SQL 2008 servers. I currently have some VBScripts that do many of my tasks, but there are some new things I want to do. I figure that Windows PowerShell would be easier. Do you have any pointers?- SC Hi SC, It is becoming late as Ed continues plowing through almost 200 e-mail m...
Hey, Scripting Guy! One thing I do not understand is why the SQL Server team wrote its own version of Windows PowerShell. I thought Windows PowerShell was supposed to standardize things. But the SQL Server team has one version of Windows PowerShell, the Exchange team has another, and then of course there is the Windows PowerShell that we can down...
Hey, Scripting Guy! I am a SQL database administrator, and in the past I have enjoyed using VBScript for many tasks related to my computers that are running SQL Server. What capabilities does Windows PowerShell provide to make working with SQL Server 2008 easier?- OS Hi OS, Ed is neck deep in work for the 2009 Summer Scripting Games. He is sippi...
Hey, Scripting Guy! I recently saw that SQL Server 2008 has Windows PowerShell built into it. I looked at, but I am not really impressed. Why should I be interested in using Windows PowerShell with SQL Server 2008?- JJ Hi JJ, For some unknown reason, it has turned cool down here in Charlotte, North Carolina, in the United States. Not that Ed is ...
