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

Presentation

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

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!

Presenting for the PowerShell Virtual Chapter of PASS

Dec 15th, 2010
by Aaron Nelson.
1 comment

pass_logo_thumbSorry for the late notice folks but I will be Presenting for the PowerShell Virtual Chapter of PASS today at Noon Eastern.  Today’s session is just going to be a bunch of cool things that I’ve been working on lately but haven’t gotten a chance to present or blog about yet.  I’m still working on one last script but I’ll post the code before the session if I can.  Hope to see you there!

PowerShell Grab Bag

Wednesday December 15, 2010, 12 Noon Eastern Time (GMT -5)
Speaker:  Me
Live Meeting Information Join the meeting

In this short grab bag session we’ll go over a bunch of new scripts that I’ve built over the last few weeks.  Things like:

  • checking free space on mount points,
  • checking SQL agent for failed jobs,
  • polling instances to make sure they’re available,
  • checking the status of log shipping across multiple targets,
  • emailing result sets and
  • scheduling all these with SQL Agent. 
  • Checking remote registries (including why on earth you would ever want to do that?!).
  • Zipping files, even better, we’ll go over how to not zip files that have already been zipped. 
  • The final grab from this session:  for all the Summit attendees out there, I’ll share with you my script to download all the session videos from the 2010 Summit