Jan 302015

I am pleased to announce that I have an upcoming preconference training session on Friday, February 27th, the Friday before SQL Saturday Phoenix.

Virtualization for SQL Server DBAs

Session Information: Microsoft MVP, VMware vExpert, and SQL Server performance expert David Klee leads this full-day introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with the focus on SQL Server performance.

Upon completion of this course, attendees will be able to:

  • Understand key virtualization and cloud concepts
  • Determine the optimal infrastructure configuration for best performance
  • Construct a SQL Server virtual machine template with best practices for agility and performance
  • Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement
  • Identify and remediate common virtualized SQL Server performance killers
  • Understand proper virtualized capacity management techniques for long term management

Attendees with the following experiences will benefit the most from this course:

  • Basic familiarity with the core components of a server
  • SQL Server installation and configuration
  • Exposure to SQL Server performance metric measurement and identification

A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for prospective reference in working with virtualized SQL Server in their own environments.

Seats are limited, so register today for this great event!

If this topic is not too intriguing to you, check out the other precons! This is world-class training at a low price!

Architecting the Modern Data Warehouse – Adam Jorgensen

SQL Internals Deep Dive – Bradley Ball

Tune Like a Guru – Kevin Boles

SQL Saturday Phoenix

Phoenix’s next SQL Saturday is Saturday, February 28th, at the Black Canyon Conference Center, 9440 North 25th Avenue, Phoenix AZ. This event is huge! They have 11 full tracks covering topics from application development to business intelligence to DBA and development topics. I’m fortunate enough to have a session at 10:45am in the Boulder Room entitled “Achieving Peak Performance from your Virtual SQL Servers“, and will cover a high level overview of some of the topics that I go in-depth on during the precon. If you can’t make the precon, come see me during this morning session and I’ll gladly spend as much time as possible answering any questions that you might have about SQL Server virtualization!

Register today for this event, as seats are limited and I know it is going to fill up soon! I can’t wait to see you all there!

Jan 212015

vmug_evalexperienceThe VMware Users Group VMUG just announced a partnership with VMware, called the EVALExperience, to offer VMware technology pre-production 365-day licenses as part of the VMUG yearly subscription! It’s now included in the $200 annual VMUG Advantage Subscription fee! WOW!

evalexperiencevmwareYour tech lab can now include with the following products:

This is a huge announcement. Tech labs are my favorite method to keep up with the dramatically changing technology for as long as I have been in the industry, and fiddling around with constantly-expiring license keys is sometimes more of a hassle than it is worth. Microsoft’s MSDN has helped a lot over the years, and I am pleased to see VMware and VMUG now offering a similar offering.

You can get the hardware for such a lab for a lot less than you’d think! Check out my home lab page for more details.

If you are not already a VMUG subscriber, this should be the final incentive to get out the wallet and sign up!

Jan 142015

VMware has recently announced an online event for February 2nd that you don’t want to miss! Whatever it is, it’s going to be big! It also kicks off the 28 days of February event, whatever that is. You don’t want to miss this!vSphere6-event

Date: February 2, 2015
Time: 1:00 – 2:00 PM PST / 4:00 – 5:00 PM EST

Date: February 3, 2015
Time: 9:00 – 10:00 AM GMT / 10:00 – 11:00 AM CET

ASIA PACIFIC – ASEAN, Western Australia, Hong Kong
Date: February 5, 2015
Time: 10:00 – 11:00 AM SGT

ASIA PACIFIC – Sydney, Australia
Date: February 5, 2015
Time: 10:00 – 11:00 AM AEDT

ASIA PACIFIC – Mumbai, India
Date: February 5, 2015
Time: 10:30 – 11:30 AM IST

Register here!

Nov 282014

PASS_VC_VirtualizationOn December 10 at 11am CST I will be presenting the next PASS Virtualization Virtual Chapter monthly webinar, where you can ask me any of the burning questions about virtualized SQL Server that you’ve been just itching to ask! It’s an open questions and answers session. Please submit your questions to Tom Norman, chapter lead, at armordba@gmail.com, and we’ll be sure to get them answered for you! RSVP here for this free webinar, and I’ll see you all then!

Nov 142014

PASS Summit 2014 Logo_930x260This past week of conferences was simply amazing. It was the best week of my career. Period. Now that I’m close to being recovered, I thought I’d put together a short recap of the week.

(I seem to say this after every PASS Summit. Every year has been better than the last. What will next year bring? I am excited to find out!)

microsoft mvp tallThe first part of the week, I attended the Microsoft MVP Global Summit from Sunday to Tuesday. The details of the Global Summit and the topics that we covered are all unfortunately under NDA, but rest assured, I am very excited for the future of the products that I have dedicated this portion of my career to.

Tuesday evening to Friday was the PASS Summit 2014 at the Seattle Convention Center, the largest SQL Server conference of the year. My goals were simple – network, present, and network some more.

Welcome to the PASS Summit 2014

Welcome to the PASS Summit 2014

My company, Heraflux Technologies, co-sponsored a booth with Denny Cherry and Associates, SQLHA, and Fortified Data, which we called Consultants Corner.

Ben DeBow relaxing in our booth

Ben DeBow relaxing in our booth

We had a blast meeting everyone that stopped by the booth! I thoroughly enjoyed the varied conversations around virtualization migrations, performance tuning, and rubber chickens.

The largest presentation that I’ve had so far was Wednesday at 1:30pm. Have you ever had one of those moments where you stop what you are doing and “is this really happening” starts going through your head? I had this moment when I was approaching the doorway for the room where I presented the session. The room had all six doors open and I saw nothing but chairs covering the entire view. I had to stop and pause for a moment because of the wave of emotion. Exhilarated… excited… humbled… Nothing clearly describes how I felt. It was a very surreal moment. When I walked through the room and onto the stage about 45 minutes early, this is the view I saw.

summit 2014 view from stage

This session, “Right-Sizing Your Virtual SQL Server”, was presented to solid attendance in one of the very large conference rooms. It was also broadcast live to the world on the streaming video page at PASStv, which you can watch here. That’s no self-imposed pressure at all, right? The audience and I had a fun time with the 75-minute session going through all of the nuances of why and how virtual SQL Servers should be “right-sized” to maximize the performance and consolidation. The attendees were engaged and energetic, and asked some wonderful questions throughout the session. I really appreciate each and every one of you who came to see me speak!

It was in this session that I announced my company’s intention to release a product that can run in the background on a physical or virtual SQL Server and determine an approximate number of virtual CPUs and memory allocation for the server. I am proud to announce that it will be available for FREE. If you would like to sign up to become a beta tester once it is ready to release, please sign up by just sending me a quick message with your email address at the contact me page here.

Throughout the week, I attended a number of great gatherings after hours. Denny Cherry, SQL Sentry, Fortified Data, SIOS, and others all had some fantastic gatherings at venues near the convention center. Your contributions to community building are much appreciated! We all had a blast, and you helped us all stay out WAY too late most evenings!

On Friday at 4pm I presented another session entitled “Achieving Top Performance with your Virtual SQL Servers” to a great group of die-hard attendees in the last session block of the conference. Being the last session of the conference, I was going to be genuinely thrilled if a single person showed up, but much to my amazement, the room was mostly full! You all were great. The interaction level was high, the questions top notch, and I wanted to keep going until midnight to make sure that I had everyone’s questions answered.

Saturday morning wrapped up the week with a nice, quiet breakfast at Pike’s Market overlooking the waterfront and friendly banter with a few friends from the #sqlfamily. I did not want the week to end. I spent the rest of the day on two uneventful flights back to Omaha.

The week of this conference is the most amazing week of the year for me, and I am going to attend this conference each and every year going forward. This event is created by the SQL Server community, for the community, which is quite unique in the tech field. For those of you who have never been, or are looking for the best SQL Server ecosystem training in the world, I cannot stress enough the value of this conference. You should leave the conference with at least three things that will directly improve something you are working on or manage in your environments. The friends you make will last a lifetime. The professional contacts will help you when you’re in a bind in your business.

As for next year, the next PASS Summit is back in Seattle on October 27-30, 2015. I can’t wait to see you all there!

Landing at Seatac airport (cleaned up by Brandon Leach)

Landing at Seatac airport (cleaned up by Brandon Leach)

Chris Shaw and John Morehouse setting up for their precon

Chris Shaw and John Morehouse setting up for their precon

Saturday morning breakfast on the water

Saturday morning breakfast on the water

See you all next year!

See you all next year!

Nov 062014

PASS Summit 2014 Logo_930x260Today I presented my SQL Server virtual machine “right-sizing” session at the SQL PASS 2014 Summit to a fantastic audience. I really appreciate each and every one of you for attending. This session was also broadcast on the Summit PASStv live video streaming session, and thanks to all of you who tuned in to watch!

As promised, I have attached the schema and scripts from the session, available to download here. These scripts will help you take Perfmon data that you have loaded into the database (use the Midnight DBAs code available here to do so, demo how-to video here) and run a statistical analysis on the data. The end goal is to help you understand the resource consumption of your SQL Servers, both physical or virtual, and take this data to determine the appropriate amount of CPU and memory needed to keep this SQL Server performing well while minimizing the size of the VM.

Also announced in this session is the target date of the end of the year for the beta release of a FREE standalone utility to run on your SQL Servers that will profile the performance trends of the server and present an estimation of the “right” amount of CPU and memory needed to balance the VM’s performance with the VM’s size. If you’d like to be added to the beta tester list, just contact me here and request to be added. Keep an eye on this blog for more details as the project nears a release date!