For those of you attending my presentation at TechEd North America today, here’s the scripts that we’ll be going through: http://SQLvariant.com/BlogSupport/PoShDirtyDozen/TechEdDozen.zip
Scripts
PowerShell Scripts for Pragmatic Works Webcast
I did a webcast for the folks over at Pragmatic Works for their Free Training series two weeks ago. As promised, here are the scripts I covered in that webcast.
I want to thank everyone who joined the webcast and especially all the people that asked the great questions at the end! I received some really awesome feedback from attendees about the webcast!! 
When I get some time in a few weeks, I will go back and write a blog post showing code to answer the questions from the webcast.
SQL Saturday Redmond Slides and PowerShell Scripts
I’m speaking at SQL Saturday #108 on the Microsoft campus in Redmond today. This post is just for those who would like the scripts & slides from today’s demos. Enjoy! 
PowerShell Presentation at SQLskills open-mic night
Kimberly Tripp ( blog | twitter ) and Paul Randal ( blog | twitter ) SQLsklls are here in Atlanta this week. Last night they held an ‘open mic’ night and allowed anyone who wanted to present a topic 15 minutes to show something to the rest of the class. Surprise, surprise I decided to talk about PowerShell.
I received multiple requests to post the scripts I used before I even had a chance to sit down so here they are.
If you were in the class and would like to use these and don’t even know where to start with PowerShell have a look at my “Resources for my SQL Server PowerShell Extensions webcast” post.
If you ever get a chance to attend one of their classes and present in front of Paul and Kim TAKE IT! 
Even if it’s just about your SSMS tips or how to work around a problem you encountered. The feedback you get is *more* than worth it!
Resources for my SQL Server PowerShell Extensions webcast
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.
CodeStock Slides and PowerShell Scripts
I had a really great time at CodeStock this weekend! I plan on doing a wrap-up post later this week but I just wanted take a moment and post my slides and scripts that I used during my PowerShell for Data Professionals session.
PowerShell for Windows Admins – Code and Slides
Two weeks back I had the opportunity to present a session on PowerShell Windows Admin Commands at the Atlanta TechStravaganza. I was a little worried about the presentation because I had never presented to a crowd of system administrators before. Luckily I pulled it off and believe the standing room only crowd learned a lot and discovered ways to make PowerShell relevant to their work. They did stump me with a question about opening ports but luckily Mark Schill ( blog | twitter ) was able to provide the correct answer for us all.
Thanks to everyone who took time out of their Friday to come by and see it. I got a lot of great comments from people in the hallway after my session. Some of them really liked the different approach I took to presenting it. As promised here are all of the Sildes and Scritps that I used during the session.
Oh and thanks to all the sponsors!
PowerShell for Windows Admins – Code and Slides
Two weeks back I had the opportunity to present a session on PowerShell Windows Admin Commands at the Atlanta TechStravaganza. I was a little worried about the presentation because I had never presented to a crowd of system administrators before. Luckily I pulled it off and believe the standing room only crowd learned a lot and discovered ways to make PowerShell relevant to their work. They did stump me with a question about opening ports but luckily Mark Schill ( blog | twitter ) was able to provide the correct answer for us all.
Thanks to everyone who took time out of their Friday to come by and see it. I got a lot of great comments from people in the hallway after my session. Some of them really liked the different approach I took to presenting it. As promised here are all of the Sildes and Scritps that I used during the session.
Oh and thanks to all the sponsors!