Jan 042017
 

Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago. The training class is entitled “The Complete Primer to SQL Server Infrastructure and Cloud” and is to be held on Friday, March 10th, at the DeVry University Campus in Addison, IL. This course has been updated to include key concepts about SQL Server in the cloud, including the similarities, differences, and performance characteristics.

Session Details: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment, whether on-premises or in the cloud. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure, virtualization, and cloud underneath SQL Server, from storage all the way through to the SQL Server instance and database, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

Registration is now open here, and seats are limited! Register today!

Nov 012016
 

I am proud to announce the availability of our new training offerings! We are launching a live web-based version of our one-day SQL Server infrastructure and virtualization master class. We are hosting an all-day training session before the end of the year to help you take advantage of quiet(er) times around the holidays. Select from one of the dates that works best for you and register today!

Tuesday, November 22nd – 10:00am to 6:30pm Eastern

Thursday, December 29th – 10:00am to 6:30pm Eastern

Looking to ramp up on the infrastructure and virtualization underneath your databases? Want to learn how to work effectively with the other silos in your IT organization? This live web-based training will help take you to the next level by understanding the architecture, performance characteristics, and performance tuning opportunities of the storage, physical server hardware, virtualization hypervisor, and VM layers underneath your critical SQL Server databases.

David KleeMicrosoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure and virtualization underneath SQL Server, from storage all the way through to the SQL Server instance, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

Intended Audience

The intended audience of this course is information workers (both business and IT-centric) involved with architecting an enterprise IT strategy for SQL Server.

Course Topics

The following topics will be addressed during the course:

  • Datacenter Fundamentals
  • Infrastructure Stack Fundamentals
  • Storage and SAN Concepts and Design
  • Networking and Interconnect Topologies
  • Physical Server Technologies
  • The SQL Server Virtual Machine
  • High Availability and Disaster Recovery
  • Performance Investigation and Tuning of the Entire Stack

Course Objectives

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

  • Understand key infrastructure concepts
  • Determine the optimal infrastructure configuration for best performance
  • Review their own enterprise infrastructure for performance bottlenecks
  • 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 infrastructure-related SQL Server performance killers
  • Understand proper capacity management techniques for long term management

Prerequisites

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 strategic reference in working with SQL Server and the infrastructure underneath in their own environments.

Seats are limited in this training offering, so register now!

Tuesday, November 22nd – 10:00am to 6:30pm Eastern

Thursday, December 29th – 10:00am to 6:30pm Eastern

Sep 162014
 

vmwareThis past week I was fortunate enough to attend a three-day special session at VMware Corporation’s corporate campus in Palo Alto, CA, specifically designed to help educate and inform SQL Server MVPs with some of the most detailed training on the convergence of the VMware ecosystem and SQL Server. This was not a vendor wine-and-dine, dog-and-pony show. This was the deepest, most technical training session that I have ever had since I attended the SQLskills Immersion Events. It’s everything that I need out of a technical training environment, without any of the persuasion or marketing that you usually expect with vendor-sponsored training.

The criticality of the convergence between the infrastructure and the database is evident with today’s converged and hyper-converged virtual infrastructures. Businesses depend on the data that these systems are delivering, and if the system has an inefficiency or misconfiguration in any one of the layers in the stack, everyone suffers. If the issue is large enough, the business can fail. The education of this group of individuals is key, as this is the group that is in the position to share the knowledge with the SQL Server communities.

Attendees

The DBAs attending this event are among the best technologists in the world, and have incredible skill and years of experience with maintaining their customers systems. However, virtualization and the infrastructure around it is usually a black box and inaccessible. What VMware is trying to do is educate the people in the SQL Server space with the nuances of the VMware ecosystem and its direction, who can then share this knowledge with the community. Education is key to removing the mystery and unknowns around the virtualization technologies, and VMware did an incredible job bringing together the right people and topics to make this event a complete success.

The attendee list for this inaugural event is simply amazing. VMware recruited a select list of folks from the SQL Server community who are hands-on and neck-deep in infrastructure technologies.

Technical Hands-On Experience

Not only was it a large number of technical deep-dive sessions with key VMware leadership and technical staff members, but we also had hands-on labs. VMware used a specialized set of packages around their HOL platform to provide us customized content targeted to this audience. No explicit directions were given for any of the labs. It was more along the lines of an end-state and a technology to explore, and we were left to our own devices to get there.

I loved it. I felt like I was back in my home lab exploring a new technology over a weekend, except their equipment was a LOT faster and we had teams to facilitate group learning.

Discussions

Again, these sessions were incredible. From a candid and quite frank with VMware CEO Pat Gelsinger (and thank you for a wonderfully insightful and candid response to the blunt question that I asked that has been in my head for years) and Pure Storage CEO Scott Dietzen and VP Matt Kixmoeller, to the key internal teams responsible for some of the features that I use in all of my mission-critical virtualization initiatives, the speakers were from all over VMware’s ranks and represented the best of breed from the company.

grant fritcheyThe discussions were not only centered around educating the attendees on the technical abilities and limitations of the core vSphere features, the speakers were also actively questioning us on how their products and technologies were being used, and each and every one of them wanted feedback on the features we wish could be improved and directions for future development. They wanted to know how things were being used in the field, what our primary observations were, and the scale of the systems being virtualized. I think we shocked them with the scale of some of the systems that we work on.

We also had a few outings at the end of the first two days, such as supper on the VMware campus front lawn, and then a SF Giants baseball game. Nice touch!

att park

Amazing

Now you all know by now that I am a huge proponent of complete SQL Server virtualization. I have attended and spoken at a number of SQL Saturdays, webinars, conference sessions, and post a lot of blog posts on this topic. This class has taught me even more about the inner workings of the platform and products that I have come to embrace and endorse. The fast pace of the sessions, the energy from the coordinators and other attendees, and the rush of knowing that you are helping to guide and improve one of the most important technologies on the planet, kept a smile on my face the entire week.

Thank you VMware. Your commitment to the platform and the applications that make your platform shine has never been more evident to me. I’m excited for the directions that your products are going, and am eager to continue to show the world that virtualizing mission-critical applications should just be an assumption instead of a point of contention.

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!

Sep 302013
 

sqlsat190_speakingI must admit… Denver is my favorite town in this country. The outdoor things to do, the wide variety of locals and transplants, and the thin air all are favorable to me. I’m looking to move here someday soon. With that said, this year’s SQL Saturday #190 in Denver was absolutely wonderful, and not just because I love Denver! Denver has such an incredibly strong SQL Server community, and the warmth that I received from the attendees, other speakers, volunteers, and coordinators just re-enforces my desire to relocate (the SQL Server community in my town of Omaha is stellar, but just look at those mountains!). 

Golden CO

At this event, I presented an all new session entitled “Virtualizing Critical SQL Servers” that discussed how virtualization helps DBAs, how to incorporate key virtualization concepts into the daily SQL Server management routine, and how to build the SQL Server VM so you can get the most out of the environment. Most of the attendees had already virtualized most, if not all, of their SQL Servers. The comments and questions from the attendees in the packed room were very good, and I hope that this session helps tear down some of the organizational silos that we discussed and allows the teams to work more closely so that virtualization can really be embraced by the SQL Server teams and operational practices improved as a result!

The slides from my session are available for you to download here. Please feel free to download and review them, and contact me if you have any questions.

The next stop for me is Charleston’s next SQL Saturday and then the SQL PASS Summit! I look forward to seeing you all there!