SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V Rotating Header Image

Code

Scripts for presentation today at the 2011 PASS Summit

Oct 13th, 2011
by Aaron Nelson.
Comments are off for this post

I’m presenting at the PASS Summit today and just wanted to post the scripts I plan on using.  If you’re following along and you’re new to PowerShell I recommend that you have a look at this article I wrote earlier this year: Day Zero with PowerShell

  1. Table Size
    1. Store Results
  2. Compress Tables
    1. Compress Indexes
    2. Store Results
  3. Process Cube
  4. Backup Database –PassThru
  5. Download Denali CTP
  6. Grab Configuration Info
  7. New Get-DisksSpace try to pass from Reg servers w/ Group
  8. Email Space Report
  9. CSV with Bulk Insert
  10. Import CSV with Out-DataTable
  11. Allen Kinsel – Logs
  12. SQL Saturday – Navigate Event Schedule XML

Whats in my PowerShell Profile

Oct 11th, 2011
by Aaron Nelson.
2 comments

Here are two zip files.  The first file is my profile and the second zip file is the scripts that my profiles references.  These are just some of the tools I find useful for enhancing PowerShell.

PowerShell Grab Bag Code

Dec 15th, 2010
by Aaron Nelson.
Comments are off for this post

Thanks to everyone who took the time to check out my PowerShell Grab Bag session today for the PowerShell Virtual Chapter of PASS.  Here’s a zip of all the code that I used and the two links I promised to include.

Today’s Code

Quest’s Free PowerShell Commands for Active Directory

Shay Levy’s ( blog | twitter ) WinRar blog post

Happy Scripting!