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

MSDN

The Scripts

May 11th, 2010
by Aaron Nelson.
Comments are off for this post

Last week I did a podcast for geekSpeak and a similar session at SQL Saturday #38 in Jacksonville.  I’ve already blogged about most of the scripts in those sessions but here is a download of a bunch of those scripts.  I have changed them a little from the way they were written in my session so that they can run independently without worrying about whether or not you need to load a snapin or module.  If you need it to run the script, it’s in there.  Don’t forget that for all but one of them you will either need to have SSMS 2008 installed or the SQLPSX codeplex project.

If you don’t remember which script it was that you were interested in, here’s the recording of the session that I did for geekSpeak.

Enjoy!

PoSh

Oh, and don’t forget Buck Woody’s disclaimer about running scripts you find on the internet:

Script Disclaimer, for people who need to be told this sort of thing:
 
 Never trust any script, including those that you find here, until you understand exactly what it does and how it will act on your systems. Always check the script on a test system or Virtual Machine, not a production system. All scripts on this site are performed by a professional stunt driver on a closed course. Your mileage may vary. Void where prohibited. Offer good for a limited time only. Keep out of reach of small children. Do not operate heavy machinery while using this script. If you experience blurry vision, indigestion or diarrhea during the operation of this script, see a physician immediately.

 

I’ll be speaking at SQL Saturday #38 in Jacksonville

May 6th, 2010
by Aaron Nelson.
3 comments

If you didn’t make it to my webcast on MSDN’s geekSpeak yesterday you can catch me at SQL Saturday #38 in Jacksonville this weekend.  As always I’ll be including a few new scripts since the last time I gave this presentation.  There will be a lot of great speakers down in Jacksonville and the last I heard, there were over 550 people registered.

image

In addition to my PowerShell for Data Professionals session I will also be doing a presentation on using Hyper-V and SCVMM to manage your Dev and Test environments called Virtualize This! 

Oh, and please remember to bring lots of good questions.

Start Time 1202 (Auditorium) 1400 1402 1404 1406 Business Intelligence -1102
9:00 AM Plamen Ratchev Andy Warren Dean Richards Jorge Segarra Michael Antonovich Brian McDonald
  Common SQL Programming Mistakes Introduction to Statistics Tuna Helper for SQL Server DBA’s SQL University 101: Starting the SQL Journey XML 101 for the SQL Developer Introduction to SQL Server Reporting Services 2008
10:15 AM Dean Richards Jorge Segarra Jared Nielsen Brandie Tarvin Michael Antonovich Bradley Schacht
  Response Time Analysis of SQL Server Performance Policy-Based Management: Administration Made Easy SQL and SEO – Database Design and Web Marketing T-SQL 102: Aliases and Table Joins Publishing Access Applications to SharePoint Introduction to SQL Server Integration Services
11:15 AM           Michael Flora
            Mini – SSIS for the DBA
12:00 PM Rodney Landrum Timothy McAliley Eric Wisdahl Troy Gallant Jonathon Moorman Devin Knight
  Demystyfying SQL Code and Object Deployments ITIL V3 for the Database Administrator SSIS Configurations, Expressions and Constraints Introduction to Transactional Replication Basics of Sql Server Profiler Introduction to Data Warehousing
1:15 PM Aaron Nelson Steve Schneider Robby Robertson Shawn Harrison Sumeet Bansal Mike Davis
  Virtualize This! Encryption How-To 101 SSIS Deployment Strategies Using Parameters in SSRS Accelerating SQL with Solid State Technology Building your First Cube in Analysis Services 2008
2:30 PM Plamen Ratchev Jeff Cole Vikas Hawaldar Eric Wisdahl Mustika Nengah Adam Jorgensen
  Refactoring SQL for Performance Heterogeneous Data Integration with SSIS & CDC Introduction to Data Mining using SQL 2008 An Introductory Look at Execution Plans Accessing Cube using ADOMD.NET Introduction to SharePoint 2010 BI and PowerPivot
3:45 PM Jonathon Moorman Elijah Baker Aaron Nelson Shawn McGehee Eric Humphrey Brian Knight
  Everything you wanted to know about IDENTITY colum Table Partitioning: The Basics PowerShell for the Data Professional SQL Server 2008 Resource Governor  High Anxiety with ORMs Iron Chef Competition: Loading a Data Warehouse

I’ll Be Speaking at geekSpeak

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

Next week I am giving a PowerShell for Data Professionals session on MSDN’s geekSpeak.  If you haven’t heard of  geekSpeak all you really need to know is they have one primary rule for presenters:Your webcast is limited to only 1 Power Point slide. geekSpeak presentations focus on practical live examples and interactive question and answer sessions that allow you to learn from a presentation in a way that you can immediately start applying to your job.

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032449694&EventCategory=4&culture=en-US&CountryCode=US

geekSpeak

If you haven’t caught this presentation at a SQL Saturday yet, or if you want to see it again, then this is a chance to watch from your desk and follow along in Powershell for yourself.

The show is at 3pm Eastern/Noon Pacific.  You can see previous geekSpeak shows and subscribe to their feed here.  Please stop by and heckle me check it out. :-)

I’ll Be Speaking at geekSpeak

Apr 29th, 2010
by Aaron Nelson.
1 comment

Next week I am giving a PowerShell for Data Professionals session on MSDN’s geekSpeak.  If you haven’t heard of  geekSpeak all you really need to know is they have one primary rule for presenters:Your webcast is limited to only 1 Power Point slide. geekSpeak presentations focus on practical live examples and interactive question and answer sessions that allow you to learn from a presentation in a way that you can immediately start applying to your job.

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032449694&EventCategory=4&culture=en-US&CountryCode=US

geekSpeak

If you haven’t caught this presentation at a SQL Saturday yet, or if you want to see it again, then this is a chance to watch from your desk and follow along in Powershell for yourself.

The show is at 3pm Eastern/Noon Pacific.  You can see previous geekSpeak shows and subscribe to their feed here.  Please stop by and heckle me check it out. :-)