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

Hyper-V

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

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

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
 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

9:45 AM
 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

11:00 AM
 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

01:00 PM
 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

02:15 PM
 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

03:30 PM
 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

04:45 PM
 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

 
 

 

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

Map picture

Early March 2010 PASS VC Presentations


Free Training from Virtual Chapters:
AppDev: Jessica Moss on “Adding SSRS Report Bells and Whistles,” March 9, noon ET (GMT-5)
DBA: Clifford DibbleMicrosoft SQL Server 2008 R2 Application and Multi-Server Management,” March 10, 12-1pm MT (GMT-7)
Virtualization: Microsoft Hyper-V” presented by Sylvia Vargas. March 16, noon ET (GMT-5)

_____________________________________________________________________
JMMossSmall
Adding SSRS Report Bells and Whistles
March 9th at 12:00 PM Eastern (GMT -5)
Presenter: Jessica M. Moss
Add to Calendar

Producing a good looking report will wow your business users even if your data isn’t all that impressive. If you’ve ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008. With the knowledge in this session, you won’t ever need to show a plain, boring report again.

Jessica M. Moss

Jessica M. Moss, an architect with Ironworks Consulting and a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and authored technical content for multiple magazines, websites, and the book “Microsoft SQL Server 2008 Integration Services Problem-Design-Solution. Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences. You can read about her work on her blog,http://www.jessicammoss.com.

How do I view the presentation?
Attendee URL:  Live Meeting link

_____________________________________________________________________
Microsoft SQL Server 2008 R2 Application and Multi-Server Management
March 10, Noon Mountain Time (GMT-7)
Presenter: Clifford Dibble

Are you missing critical utilization insights into your growing database environment? Attend this session to learn how the application and multi-server management capabilities shipping with SQL Server 2008 R2 will expose resource utilization data and help streamline consolidation management. New extensions in SQL Server Management Studio allow DBAs to quickly create SQL Server control point and enroll instances them into multi-server management. Once enrolled, DBAs can define utilization policies across applications and Database Engine instances and view resource utilization to maximize investments. Meanwhile, the introduction of a single unit of deployment helps accelerate deployments, moves and upgrades associated with consolidation management.

Clifford Dibble:

Clifford Dibble has been a program manager in SQL Server since 2002.  Among other things, he was the active PM for “system views”, “DMVs”, “DDL triggers”, and “resource database” during the 9.0 release.   During the 10.0 release, Clifford was off working on an incubation project.  For the 10.5 and 11.0 releases, he is focused on multi-instance manageability and SQL management packs.

Live Meeting Link (just paste into your browser):
https://www.livemeeting.com/cc/usergroups/join?id=P7FJ9Z&role=attend

_____________________________________________________________
Microsoft Hyper-V
March 16th at 12:00 PM Eastern (GMT -5)
Presenter: Sylvia Vargas

Overview of how Microsoft IT uses, configures, and manages their virtualization environment.  Learn how Microsoft leverages Virtualization for their SQL Server environments using System Center VMM.

  • Sylvia is a Microsoft certified SQL Server professional and  Senior Systems Engineer in Microsoft IT’s Virtualization Engineering group.  Prior to joining Microsoft in 2006, Sylvia spent 24 years in various management and technical roles specializing in the architecting, development and deployment of data based solutions for companies including Areva, Boeing, ORACLE, Merrill Lynch,  Nestle and Texaco.  Sylvia has been a contributing author on The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit by Syngress and an instructor at the University of Washington SQL Server Certificate program.
  • Mark Pohto is the Principal Service Engineer responsible for the IT Cloud organization which provides virtual server engineering and delivery in Microsoft data centers. Previous to his current role, Mark was instrumental in architecting corporate monitoring systems, database administration automation solutions and IT SQL Server consolidation.  As the Group Manager for the Microsoft SQL Server Center of Excellence, Mark managed the team responsible for the Microsoft Certified Architect program and the SQL Risk Assessment program.
  • Event Link:
    https://www.livemeeting.com/cc/usergroups/join?id=QB6GSJ&role=attend&pw=Fz8b%7BT%27jN