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
I did another webcast for the Secrets of SQL Server webcast series today. In the today’s webcast we built on some things I had demoed in a prior webcast and showed how PowerShell in conjunction with SQLPSX can really help you solve some common problems DBAs face. I showed how you could pull size and free space information from all of your data files, then used the same technique to pull size information from all of your tables across every database on an instance. Later we created a database and some tables, and then showed how to do some basic login comparisons, all with SQLPSX. In addition, we stored the results of the frees pace and table size information in a database using the Out-DataTable and Write-DataTable functions. Finally we wrapped up with a quick demo on how the new SQL Server cmdlets inside of the SQLPS Module in Denali combined with some new functionality in PowerShell v3 CTP1 can really make backing up a database with PowerShell a lot easier. Here’s what you’ll need to recreate today’s demos; Download and install SQLPSX The Out-DataTable function from the TechNet script repository The Write-DataTable function from the TechNet script repository and these scripts Oh, and here are the handful of slides that I had I hope I see you next week at the PASS Summit or next month during another webcast, this time on customizing your own functions to work with the SMO.