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

Jul 292016
 

vmworld_2016

This year’s involvement in VMware‘s VMworld conference is up on the content catalog! I am extremely proud to announce my participation in the inaugural SQL Server workshop at this year’s VMworld US on August 27th. If your SQL Servers are running in a VMware environment, this course is critical to your success!

The first business critical applications and databases pre-conference workshop will cover all pertinent aspects of best practices for deployments and ongoing management of MS SQL Server running in virtualized infrastructure. This deep-dive full-day workshop will be delivered by VMware technical SQL Server specialists working in concert with world renowned external SQL Server and Virtualization experts, including me! The attendee will experience a workshop rich with technical content to include subjects such as vMotion for Failover Cluster Instances, Availability groups, SQLaaS with vRealize Automation and Site Recovery Manager. The content will be focused on best practices for design, implementation and management augmented with anecdotes of successful customer implementations.

SQL Server professionals, listen up. If your infrastructure admins are attending VMworld this year, please let them know about this course. Training them in the intricacies of the VMware platform as it relates to SQL Server, and having the training come from SQL Server professionals, is going to make your virtualization experience better.

AND – It’s not just SQL Server! A terrific Oracle on VMware session is being held on the same day as well. If you are running Oracle on VMware, I highly recommend your administrators head to this session as well!

I’m also presenting on a number of sessions during the main event!

Monster VMs (Database Virtualization) Doing IT Right – VIRT8290R – with Michael Corey

Databases by their very nature are Monster VMs. If Monster VMs are not virtualized properly, they will never perform well and can negatively impact the performance of other VMs on the hosts. In this presentation, we teach you how to properly virtualize Monster VM Databases. We will discuss why you virtualize, installation issues, how to architect for performance, the storage layer, the processor, memory considerations, and the network layer. Topics include NUMA, memory reservations, and how to avoid common mistakes. Lesson learned here help you optimize any workload you are virtualizing, with special emphasis on Monster VMs.

Performance Tuning and Monitoring for Virtualized Database Servers – VIRT7511 – with Thomas LaRock

Business-critical database platforms like Oracle and Microsoft SQL Server are among the last holdouts to enterprise virtualization, and the first to exhibit symptoms of infrastructure challenges. Is your VMware environment ready to accommodate them properly? Are your DBAs ready to virtualize them? Have you virtualized these, and now the DBAs complain about performance or lack of control? Successful virtualization of these platforms requires a different approach to virtualization than for other applications. The speakers will share their years of experience in virtualizing these data platforms so that you know how to validate your VMware environment for these systems and manage the performance properly. Scalability concerns will be addressed through discussions on scaling an individual database VM upwards and outwards as you manage the lifecycle of these database VMs. Key talking points will be presented so you can not only perfect the database virtualization from a technical level, but also from an organizational and people level by knowing how to convince the DBA that database virtualization — done right — is here to stay.

Running Business Critical Applications and the Software Defined Data Center on Hyper-Converged Infrastructure at the Speed of Flash – STO9607-SPO – with Patric Chang, Jase McCarty, Jason Pederson, and Nanjunda Somayaji

Virtualization has advanced beyond the hypervisor to include software-defined storage, hyper-converged infrastructure software (such as Virtual SAN), and workload migration across data centers and cloud services. This panel session will discuss how to take full advantages of evolving SDS and HCIS capabilities with new flash-enabled architectures, including a number of reference configurations and architectures running the most demanding business applications, OLTP databases and VDI workloads. Panel speakers will provide their real-world insights on key decision criteria to include when considering a flash-enabled HCIS or SDS technology, including performance, density, manageability, and financial considerations. Extensive opportunities for audience Q&A will be included in this session as well.

SQL Server on vSphere: A Panel with Some of the World’s Most Renowned Experts – VIRT7654 – with Denny Cherry, Niran Even-Chen, Allen Hirt, and Thomas LaRock

Learn from real-life experience about virtualizing the most demanding SQL Servers from some of world’s most renowned SQL Server experts! In this panel discussion, you also have the chance to ask your own questions about SQL Server on vSphere practices and get your answers from the SQL Server gurus.

Register for VMworld here!

May 232016
 

vmworld_2016I am extremely proud to announce my participation in the inaugural SQL Server workshop at this year’s VMworld US in Last Vegas on August 27th. If your SQL Servers are running in a VMware environment, this course is critical to your success!

The first business critical applications and databases pre-conference workshop will cover all pertinent aspects of best practices for deployments and ongoing management of MS SQL Server running in virtualized infrastructure. This deep-dive full-day workshop will be delivered by VMware technical SQL Server specialists working in concert with world renowned external SQL Server and Virtualization experts, including me! The attendee will experience a workshop rich with technical content to include subjects such as vMotion for Failover Cluster Instances, Availability groups, SQLaaS with vRealize Automation and Site Recovery Manager. The content will be focused on best practices for design, implementation and management augmented with anecdotes of successful customer implementations.

SQL Server professionals, listen up. If your infrastructure admins are attending VMworld this year, please let them know about this course. Training them in the intricacies of the VMware platform as it relates to SQL Server, and having the training come from SQL Server professionals, is going to make your virtualization experience better.

Register for VMworld here!

AND – It’s not just SQL Server! A terrific Oracle on VMware session is being held on the same day as well. If you are running Oracle on VMware, I highly recommend your administrators head to this session as well!

Apr 302015
 

vmwareThis past week I had the pleasure of being part of the second SQL Server virtualization workshop held by VMware. The first workshop, held last year, was a tremendous success and we all wanted to keep the momentum going with more SQL Server gurus. Over the last few months, I worked closely with Michael Corey, Founder of Ntirety, Don Sullivan, Product Line Marketing Manager for Business Critical Applications at VMware, and multiple engineers from Tintri to make the second workshop as great as the first one. Special thanks goes to Mike Adams, Director of Product Marketing at VMware, for continuing to support this fantastic workshop through its second iteration.

Sean and Wendy (c/o @Michael_Corey)

Sean McCown and Wendy Pastrick (c/o @Michael_Corey)

The goals of the workshop are simple: to educate the SQL Server professionals from around the country that contribute to the SQL Server community and/or deal with the largest and highest performing SQL Servers in the world on the topics and features of VMware’s product lineup that can complement and contribute to their success. In turn, these professionals will help educate the SQL Server community on how to successfully virtualize every SQL Server out there in the wild.

The attendees at this event are second to none:

Three of us are alumni:

Allan Hirt In Action (c/o @Michael_Corey)

Allan Hirt In Action (c/o @Michael_Corey)

The speakers, topic lineup, and discussions were unbelievable. The best of the best were brought in to educate on the nuances of the various features of VMware vSphere. Industry greats such as Richard McDougall, Francois Tallet, Gurusimran Khalsa, and Rawlinson Rivera were all present to discuss the topics that are on the bleeding edge of virtualization technologies today. The conversations got pretty intense as the best DBAs and VMware technologists in the world sparred on the differences and complementary nature of some of the features of their respective products.

The technical labs were also incredible. I helped walk the attendees through a number of self-guided technical lab exercises where attendees got to experience the advanced tuning techniques and processes that can improve the performance and availability of their virtual environments.

Once again, VMware, you have an incredible set of technologists that put together one of the best workshops I have ever attended.  Thank you for such an amazing opportunity to help educate some of the people that I’ve been learning from for so many years.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close