Sep 152017
 

PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual SQL Servers – Right to Ludicrous Speed” has a few open slots for this Tuesday session. This topic is near and dear to my heart, and I’m thrilled to be able to present to the group advanced SQL Server VM tuning techniques learned from over 17 years of performance tuning.

If any of you want to excel your DBA skills, not only for your on-premises SQL Server VMs but also your VMs in the cloud, I hope all of you can join me in what I consider the best SQL Server ecosystem conference in the world.

Session Details:

Join this full-day introduction session focused on managing and boosting the performance of a virtualized SQL Server environment. The focus of the course is to help those new to virtualization, infrastructure, and cloud-based infrastructure-as-a-service 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, no matter if on-premises or in the cloud, and will learn how to construct 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 a virtualization strategy for SQL Server, or managing business-critical SQL Servers that have already been virtualized.

Course Topics
The following topics will be addressed during the course:
• The Physical Infrastructure Underneath the VM
• Storage and SAN Concepts and Design
• Virtualization and Infrastructure Fundamentals
• The SQL Server Virtual Machine
• Networking, Support, and Licensing
• SQL Server Infrastructure in the Cloud
• High Availability and Disaster Recovery and SQL Server
• Performance Investigation and Tuning of the Entire Stack

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 virtualized SQL Server in their own environments.

Register today! Seats are sure to fill up for these precons!

Sep 072017
 

Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask great questions, I thought I’d extend an offer to everyone at the European show coming up in a week! Let’s talk SQL Server! We are going to crash the VMvillage hang space on Tuesday, September 12 at 3pm local time to hold an open-ended SQL Server on VMware Q&A session. This unscripted and unofficial session is for you, has no official agenda, and marketing is strictly off-limits.

Our illustrious experts include:


Michael Corey, Founder – Corey and Associates

Thomas LaRock, Head Geek – Solarwinds

Argenis Fernandez, Principal Architect – Pure Storage

Niran Even Chen, Double VCDX, VMware Corp.

… and me!

Mark your calendars, and bring your questions, specific challenges, or discussion points, and let’s do this! Anything goes – performance, availability, setup and configuration, conflicts between best practices for SQL Server and VMware, anything!

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!