Summary: Learn how to combine two arrays in Windows PowerShell. How can I use Windows PowerShell to combine two arrays stored in two different variables? Use the + operator, for example: [array]$a = @('a','b','c') [array]$b = @(1,2,3) [array]$c = $a + $b...
Summary: Guest blogger and PowerShell MVP, Teresa Wilson talks about Windows PowerShell community events.Microsoft Scripting Guy, Ed Wilson, is here. It is the last Saturday of October, and that means it is PowerShell Spotlight day with guest blogger, Teresa Wilson.Hello everyone. I hope you are having a scriptastic day! The MVP Summit starts ...
Summary: Use Windows PowerShell to back up system databases. How can I use Windows PowerShell to dynamically back up all of the system databases on my servers? Combining provider lookups with the Backup-SqlDatabase cmdlet makes this simple: $instances = @(‘KIRK’,’SPOCK’,’PICARD’,’RIKER’) ...
Summary: Guest blogger, Mike Fal, talks about leveraging the SQL Server PowerShell provider. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Mike Fal. He blogged yesterday (see Getting Information from the SQL Server Provider with PowerShell), and he continues today... In my previous post, I covered how to gather and view ...
Summary: Use Windows PowerShell to find versions of SQL Server. How can I use Windows PowerShell to see all the versions of SQL Server I have installed? Use the provider and a list of instances to look them up as if they were files in a directory:$instances = @(‘KIRK’,’SPOCK’,’PICARD’,’RIKER&rsquo...
