Sep 022014

My summer event hiatus is coming to a close, and we’re now back into the conference and event season! I’ve spent the summer making some wild plans for new posts and research articles (and more) that I’ll be releasing on here this fall. Stay tuned for some exciting announcements!

I do have a number of upcoming events that I would like to share with you. Hopefully I’ll see you at some of these!

First, on September 13th I will be in Kansas City for their next SQL Saturday #300 event. The event is being held at Cerner Corporation’s Riverport Campus, 6711 NE Birmingham Road, Kansas City MO. I’ve been to this event every year for quite a while now, and it’s definitely one of my favorites. My session this year is the SQL Server Virtualization 101 session, and I always look forward to presenting this one. It’s a great introduction to virtualization for any DBA who has never had any exposure to the details on the virtualization layer. Register today for this event here!

I go from there to Las Vegas for this year’s IT/Dev Connections conference held at the ARIA Resort on September 15-19. I am very lucky to have been selected to present two sessions this year – “Make Your Virtualized SQL Server Machines Top Performers” and a joint session with my friend Ben DeBow entitled “Scaling Your Virtualized SQL Servers Up and Out“.

I fly straight from IT/Dev Connections to this year’s SQL Saturday #331 in Denver! It’s being held at the University of Denver – Driscoll Student Center, 2055 East Evans Avenue, Denver CO on September 20. I’m presenting the followup to the 101 session aptly entitled “SQL Server Virtualization 201“. Register today for this event here!

Hopefully I can catch a few zzzz’s after this event, because just one week later I’ll be at the next SQL Saturday #318 in Orlando on September 27th at Seminole State College, 100 Weldon Blvd, Sanford FL. I’m excited to attend this event for the first time. I’m hitting the tail end of the massive session lineup with my “Easy SQL Server Benchmarking” session. Register for this event here!

Heraflux-Logo-Color-SMAfter a short break, I’m presenting a preconference session entitled “Virtualization for SQL Server DBAs” on October 24th in front of the next SQL Saturday #332 in Minneapolis. The all-day training is designed to help you, the DBA, understand the intricacies of virtualization from a DBA’s perspective, and give you the foundation to take back all the tips and tricks needed to maximize your system’s performance and availability when virtualized. Seats at this all-day class are a steal at just $99. To register for this precon, click here.

I’m not the only one presenting at this event! Argenis Fernandez, Jason Strate and Adam Jorgensen, and Mark Vaillancourt are all presenting fantastic preconference training sessions. If virtualization is not your thing, please check out the other precons.  This is the best training that you can get – without having to travel – at an incredible price!

The following day is Minneapolis’ next SQL Saturday on October 25th. It is being held at the University of Minnesota – Keller Hall – 200 Union Street SE, Minneapolis MN. It’s my first time at this event too! The schedule has yet to be posted, but I know the lineup will be great based on the submissions and tales from previous events. I can’t wait! Register for this event here.

2014_header_logoA little over a week later I’ll be in Seattle for this year’s infamous SQL PASS Summit 2014 from November 2-8th. I was fortunate enough to be selected to present a really tough session – “Right-Sizing Your SQL Server Virtual Machines“. I’ve got a lot of fun demos for this session, and I can hardly wait! November will be here before we know it. If you have never made it to the SQL PASS Summit conference before, it is the defacto event for SQL Server professionals each year. I’ll never miss it again. Period. Register today to lock in a lower rate than if you wait until the last minute!

If you’d like to have me speak for your user group, either in person or remote, feel free to contact me! I’d love to talk with your group and spread the word about how DBAs can use virtualization to their advantage!

Aug 202014

VMWorld-blogCan you believe that this year’s VMworld conference is just around the corner? It’s next week – August 24 – 28 – at the Moscone Center in San Francisco!

If you have never been to VMworld before, it’s an amazing event. VMware has a great guide for first-timers on their site for you to reference so you can get the most out of the conference. The schedule is intense and participating in the sessions and surrounding events will really help you immerse yourself in the VMware ecosystem and community.

The full content catalog is live here. Below are some of the sessions that I think you should check out if you are interested in or work with the convergence of databases and virtualization technologies.

BCO1296 – A Blueprint for Disaster Recovery of Business Critical Applications (SAP, Oracle, SQL & Exchange)

VAPP2979 – Advanced SQL Server on vSphere Techniques and Best Practices

STO3008-SPO – Decoupled Storage: Practical Examples of Leveraging Server Flash in a Virtualized Datacenter

BCO3028-SPO – Designing Virtual Environments for Efficient Recovery and DR

INF1420 – Extreme Performance Series: Understanding Virtualized Memory Management Performance

INF1469 – Extreme Performance Series: Monster VM Performance

INF2427 – DRS : Advanced Concepts, Best Practices and Future Directions

VAPP2305 – Extreme Performance Series – Understanding Applications that Require Extra TLC for Better Performance on vSphere – Deep Dive

INF1972 – Managing Database Size Growth for vCenter Server

VAPP2389 – Use Storage Virtualization to Protect Business Critical Functionality with vSphere and Oracle Extended Distance Clusters

I’ll be floating about the conference all over the place, and feel free to contact me if you want to meet up! No matter what, not only enjoy the conference but enjoy the festivities around it tooI hope to see you there!

Aug 132014


Next Wednesday, August 20th, at 7:30pm Central I will be presenting a webinar for the Professional VMware #vBrownBag entitled “SQL Server Virtualization for VM Admins“. The #vBrownBag webinar series covers a number of VMware-related topics, and I am very pleased to be able to present my session to the group.

This webinar goes into great detail on how virtualization professionals can stop fearing the resource consuming SQL Server platform and virtualize them as painlessly as possible. Performance data collection, host validation, proper VM design, and SQL Server configuration best practices, tips, and tricks are to be presented. Best yet, a solid approach on how to discuss virtualization with your DBAs will be presented, so that you can talk with your DBAs and get them excited about virtualizing their mission-critical database systems!

To register for this free webinar, simply click here. I look forward to seeing you on this webinar!

Aug 072014

SQL Server CentralI’m proud to announce that yesterday the first installment of my new Stairway series at SQL Server Central has been released – Stairway to SQL Server VirtualizationVirtualization is becoming more and more common, and without an understanding how virtualization works, the DBA will have blind spots when attempting to resolving performance issues, such as reduce resource contention, or improve the backup and restore operations, and so on.

The first Level in this series answers the questions surrounding just what is virtualization, and how does it relate to SQL Server DBAs. The differences that it makes in terms of day-to-day operations, high availability, agility, and standardization are all discussed.

I hope you enjoy reading this article, and stay tuned for more Levels coming soon!

Jun 302014

2014_header_logoThe SQL PASS Summit 2014 community sessions were recently released. I’m very pleased and honored to announce that I will be presenting a 75-minute session entitled “Right Sizing Your Virtual Machine” at the Summit this November. It’s a topic that I spend many hours a week on in my professional duties with my company, and I am very excited about sharing the fundamentals of the topic and the methodology that I use to perform a right-sizing analysis on a SQL Server virtual machine. If you have a virtualized SQL Server anywhere in your environment – this topic will matter to you.

Abstract: Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM (Virtual Machine) is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the “right” amount of resources to allocate? What happens if the workload changes a month from now? Join this session and find out!

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly “right-size” the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

If you did not get selected for the Summit this year, don’t fret. Keep up the great work in the community and keep submitting. Refine your topics and speaking style at various events, like SQL Saturdays, PASS Virtual Chapter presentations, or SQL Server user group sessions. All of the experience adds up, and with the right presentation background, topic, and some luck, we’ll all be speaking there next year.

I really hope that you are able to attend the Summit this year – and every year after. I consider it the most professionally important conference of the year for any SQL Server professional. Attending the conference over the last three years has changed my career and my life in a number of fantastic ways, and it can do the same for you.

Jun 252014

ThSQL Saturday Maineis coming weekend is the SQL Saturday #293 in Portland, Maine with my precon on Friday. I am really looking forward to attending this event. I have never been to Maine but have always wanted to go.

I am very excited to be presenting two sessions at this event!

Easy SQL Server Benchmarking - Room 211 at 8:30am

Abstract: Do you have a new piece of hardware going into service and want to see how well it performs? Or do you have a few systems and want to see how they compare against each other? Multiple free and easy ways to stress test your SQL Servers exist by simulating an OLTP workload against a real SQL Server and the infrastructure underneath. In this session we will demonstrate how to test your storage and SQL Server instances to get raw performance numbers that you can use to compare performance of machines across your enterprise. The utilities DVDStore, HammerDB, and SQLIO will be demonstrated in depth. 

Session Level: Beginner

Squeezing Top Performance from Your Virtualized SQL Servers - Room 113 at 3:05pm

Abstract: Just about anyone can click through a SQL Server installation and get it working, but more than a little tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered in detail.

Session Level: Intermediate

Virtualization for SQL Server DBAs Precon

Also, if you are interested, there are just a few seats left for my Preconference training session on Friday, aptly entitled ‘Virtualization for SQL Server DBAs’.

Session Information:

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.

This Summer

This summer I am slowing down my weekend travel so I can get caught up on some side projects that I hope to be able to announce by the end of the summer. I also plan to spend some time spoiling my nieces! I’m taking about two months off of the SQL Saturday rounds (I know – I’ll be going through withdrawal!) so I can accomplish those goals, and then will jump back into things starting with VMworld and IT/Dev Connections in September and a whirlwind of activities planned after that!

I still have a number of webinars planned though! Stay tuned for more details on those events.