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

Slide Deck

SQL Saturday #46 Raleigh Code and Slides

Sep 18th, 2010
by Aaron Nelson.
Comments are off for this post

SQLSaturday46Raleigh Well I don’t know about the attendees but I sure had a lot of fun during my PowerShell session at SQL Saturday #46 in Raleigh.  I promised some folks that I would blog out my code and slides that I used ASAP.   Here are the slides I used and more importantly here are the scripts. 

Grant Fritchey ( blog | twitter ) was nice enough to snap a shot of me telling a Developer in the audience what I thought about how many steps it takes in PowerShell to use ADO.Net :-)

I’ll post some more details about the event later since I want to get this code out however while I’m at it I’d like to mention that:  For the first time in my short speaking career (and quite possibly the last) I had the largest audience of any session in my room. :-D :-D

Columbus and Edmonton Code and Slides

Aug 26th, 2010
by Aaron Nelson.
Comments are off for this post

I spoke in Columbus, GA and Edmonton, um…, somewhere in Canada on back to back nights this Tuesday and Wednesday. (I’m kidding, I know it’s in Alberta, and you guys like the Jets right? ;-) ) I used the same slide deck for both sessions; well, for Edmonton I didn’t even use a slide deck, but the scripts I covered were a little different.

image I’ve recently learned that if you only have PowerPoint 2007 you’ll need to download this viewer because I built the slides in PowerPoint 2010. Here are the scripts for Columbus and Edmonton.

I think both events went really well and got a lot of people saying: ‘Hey, this PowerShell stuff could work in my environment’. I really hope they catch the fever! I’d love to speak to each of these groups next year and see what questions they come up with and see how much they’re using it. I’ve got a more advanced session that I will be debuting a little later this year so hopefully I’ll get to share it with them too.

Huge thanks to Jonathan Boulineau ( twitter ) and Colin Stasiuk ( blog | twitter ) for all they do for their groups all year long.

CodeStock Slides and PowerShell Scripts

Jun 27th, 2010
by Aaron Nelson.
Comments are off for this post

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.

image

PowerShell for Windows Admins – Code and Slides

Jun 18th, 2010
by Aaron Nelson.
Comments are off for this post

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.

IMG00287-20100604-1057

Oh and thanks to all the sponsors!

image

PowerShell for Windows Admins – Code and Slides

Jun 18th, 2010
by Aaron Nelson.
Comments are off for this post

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.

IMG00287-20100604-1057

Oh and thanks to all the sponsors!

image

Hyper-V SCVMM Slide Deck for PASS

Apr 9th, 2010
by Aaron Nelson.
Comments are off for this post

As promised here is my slide deck for the Virtualization VC of PASS that I used in my presentation on April 7th.  Hopefully the recording should be up soon.  If you have any questions about the deck please drop me a comment below.

HyperV ResourceKit

By the way, if you happen to be in the Richmond area this weekend I’ll be speaking on Virtualization at SQL Saturday #30.

Start Time Track 1 Track 2 Track 3 Track 4
08:30 AM Brett Tomson
Introduction to SSRS 2008		 Bob Lambert
The Business End of Data Modeling		 Jeremiah Peschka
Fundamentals of SQL Server Internals		 Jason Hall
Things Your Mom Never Told You About SSMS
09:45 AM Tom Robinson
SSAS Basic Cube and dimension design		 Bob Lambert
Normalize Metadata for Data Integration Analysis		 Ashton Hobbs
Compression in SQL 2008		 Mike Femenella
Introduction to Performance Tuning
11:00 AM Brian Garraty
Integration Services in the Real World		 Brett Tomson
Growing Pains – A Cautionary Tale		 Dan Crawford
SQL Service Brokers		 Jeremiah Peschka
A Dynamic World Demands Dynamic SQL
01:00 PM Tom Robinson
Building SSRS Reports from SSAS Cubes		 Louis Davidson
Database Design		 Mike Femenella
Loading Data In Real Time		 Janis Griffin
Tuner Helper – A Proven Process In Tuning For DBAs*
02:15 PM Steve Wright
Memory Management in SQL Server Analysis Services		 Louis Davidson
Database Design Patterns		 Allen White
Automate SQL Server Administration with PowerShell		 Dan Crawford
SQL Server Spatial Data
03:30 PM Brock Beatty
SQL 2008 Change Data Capture Tips and Tricks		 Aaron Nelson
Virtualize This!		 Allen White
Gather SQL Server Performance Data with PowerShell		 Susan Lennon
Using SSRS to report on IIS Web Logs
LiveJournal Tags: