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
- Table Size
- Store Results
- Compress Tables
- Compress Indexes
- Store Results
- Process Cube
- Backup Database –PassThru
- Download Denali CTP
- Grab Configuration Info
- New Get-DisksSpace try to pass from Reg servers w/ Group
- Email Space Report
- CSV with Bulk Insert
- Import CSV with Out-DataTable
- Allen Kinsel – Logs
- SQL Saturday – Navigate Event Schedule XML