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

SCVMM

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 SQL Saturday #41 in Atlanta

Apr 23rd, 2010
by Aaron Nelson.
1 comment

Because simply helping organize the event isn’t enough Stuart ( blog | twitter ) decided that I should speak at SQL Saturday #41 in Atlanta too.  I’d like to take this opportunity to point out that not only is he not speaking at this SQL Saturday but he scheduled me for 2 sessions!  OK, enough smack-talk.

image

This year we will be hosting over 30 speakers including 6 MVPs, and around a half-dozen speakers from Microsoft.  We’re lucky enough to have planned on having David Rodriguez present 3 session on SQL Server 2008 R2 right after it launched earlier this week (yep we planned the whole thing out that way ;-) ).  We’ve got 250 registered and 65 people on the wait list so the next time we do this “we’re gonna need a bigger boat”.  If you’re one of those people on the wait list we’ll be glad to have you join us if we have room after 9 am. 

If you’re not anywhere near Atlanta there are SQL Saturdays happening in New York and Southern California this weekend as well.  My sessions are going to be on Virtualization using Hyper-V and SCVMM (Systems Center Virtual Machine Manager) and Windows PowerShell.

Start Time
 
 

 

1 Centennial Park
 
 

 

1 Grant
 
 

 

1 Piedmont Park
 
 

 

2 Buckhead
 
 

 

2 Chastain Park
 
 

 

2 Highlands
 
 

 

2 Midtown
 
 

 

08:30 AM
 
 

 

Mike Femenella
Introduction to Performance Tuning
 
 

 

Robert Cain
Introduction to Data Warehousing / BI
 
 

 

Louis Davidson
Database Design Fundamentals
 
 

 

Jonathan Kehayias
Auditing User Activity 101
 
 

 

Michael Clifford
When GEO meets SQL: Hotwiring Data to Locations
 
 

 

Dan Murray
Ad Hoc Visual Analysis
 
 

 

Kendal Van Dyke
Getting started in blogging and technical speaking
 
 

 

9:45 AM
 
 

 

Kevin Boles
SQL Server Memory Deep Dive
 
 

 

Tejas Patel
Introduction to Data Mining
 
 

 

Whitney Weaver
Solving Real World Problems With DMVs
 
 

 

Geoff Hiten
Clustering for Mere Mortals
 
 

 

Ryan Duclos
Common Table Expressions
 
 

 

Mike Femenella
Loading Data In Real Time
 
 

 

Janis Griffin
Tuna Helper for SQL Server DBA’s
 
 

 

11:00 AM
 
 

 

David Rodriguez
SQL Server 2008 R2 Overview – Session 1
 
 

 

Mark Tabladillo
SS2008 Data Mining with Excel 2010 and PowerPivot
 
 

 

Kevin Boles
Advanced TSQL Solutions
 
 

 

Geoff Hiten
Scale Out the DBA (Enterprise Policy Management)
 
 

 

Chris Eargle
RESTful Data
 
 

 

Chris Skorlinski
Q&A with MS SQL Escalation
 
 

 

Kendal Van Dyke
The (Solid) State Of Drive Technology
 
 

 

01:00 PM
 
 

 

Whitney Weaver
A Lap Around SQL Server 2008 Master Data Services
 
 

 

Evan Basalik
Troubleshooting SSRS Performance
 
 

 

Kevin Boles
Common TSQL Programming Mistakes
 
 

 

Aaron Nelson
PowerShell for the Data Professional
 
 

 

Troy Gallant
Introduction to Transactional Replication
 
 

 

Robert Cain
Off and Running with PowerPivot for Excel 2010
 
 

 

Meredith Ryan-Smith
Work/Life Balance? Just A Myth?
 
 

 

02:15 PM
 
 

 

David Rodriguez
SQL Server 2008 R2- BI Drill Down Session 2
 
 

 

Ryan Duclos
Can you control your reports?
 
 

 

Louis Davidson
Database Design Patterns
 
 

 

Chris Skorlinski
Introduction to Change Data Capture
 
 

 

Aaron Nelson
Virtualize This!
 
 

 

Janis Griffin
Wait-Time Based SQL Server Performance Management
 
 

 

Evan Basalik
SQL Azure: Data in the Cloud is a Good Thing
 
 

 

03:30 PM
 
 

 

David Rodriguez
SQL Server 2008 R2- DBA Drill Down Session 3
 
 

 

Robert Cain
Full Text Searching – A Guide for DBAs & Devs
 
 

 

Jennifer McCown
T-SQL Code Sins
 
 

 

Chris Skorlinski
Introduction to Merge Replication
 
 

 

Audrey Hammonds
The Art and Science of Data Modeling
 
 

 

Jonathan Kehayias
Troubleshooting SQL with Event Notifications
 
 

 

Glen Gordon
Survey of Windows Azure Platform Storage Options
 
 

 

04:45 PM
 
 

 

Dave Turpin
De-mystifying Execution Plan Analysis
 
 

 

Noah Subrin
Data Warehouse Assessments – What,Why, and How
 
 

 

Jack Corbett
Why I Use Stored Procedures and You Should Too!
 
 

 

Kendal Van Dyke
Configuring SQL Access for the Web Developer
 
 

 

Jennifer McCown
T-SQL Starter Kit
 
 

 

Tejas Patel
What is Microsoft StreamInsight?
 
 

 

Evan Basalik
Diagnosing Connectivity Issues with SQL Server
 
 

 

Remember to dress in layers and I hope to see everyone there tomorrow.

Map picture

Speaking at the Virtualization VC of PASS Today

Apr 7th, 2010
by Aaron Nelson.
1 comment

pass_logoPASS in online today and we’ve got a great presentation for you.  We’ve teamed up with Dushyanth Nataraj from VMware to put together a session that should help DBAs get their feet wet with using some of the common features/strengths of Virtualization.  I’ll be doing a short presentation on Microsoft’s System Center Virtual Machine Manager showing folks how to move storage, copy machines, snapshots and reverts, and anything else I can squeeze into 20 minutes (Maybe some PowerShell?).

Dushyanth is presenting an overview of VMware vCenter Lab Manager demostrating how VMware vSphere and Lab Manager can help you build a internal cloud for dev/test. We finish up with a demo of Lab Manager running a SQL workload showcasing how you can use the product for test/dev.

Using Virtualization to Solve Common Dev/QA Environment Problems
April 7th Noon Eastern (GMT -4)
Presenters: Aaron Nelson & Dushyanth Nataraj
How do I view the presentation?
Click here to join the webcast.

This will be my first time trying to switching presenting between two different presenters with seperate demos, but we are pretty sure we can pull it off.  If we want to follow along note that everything I’m presenting is done in SCVMM and everything Dushyanth does is in VMware; hopefully that works out as well. A big hat-tip goes out to my awsome coworker, Adeel Abbas, for helping me get this presentation working quickly by setting up my Domain Controller for me.

By the way…did you see the Scripting Guys articles from last week?

2010 Scripting Games

Grab this badge here!