I’m very pleased to announce that one of my sessions submitted for this year’s PASS Summit in Seattle, held from November 6 to 9th, called On-Prem SQL Servers, Interstellar Performance, has been selected and one of the first sessions to be announced for the conference. On-premises virtualization is still the principal location for your organization’s mission critical SQL Servers. Even during the journey to the cloud, improving the performance while on-prem improves your life and makes your databases more efficient.

Session Abstract: Your business-critical SQL Servers should not suffer from infrastructure-related bottlenecks. When properly architected and managed, the principal bottleneck to performance of these SQL Servers should be only limited by code. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. Layers like virtualization, storage, and networking can all detract from database performance, and they are tough to identify. This session is packed with many live examples of tips and tricks gained from years of experience for getting the most performance from your physical and virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure teams so that you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

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.

This is just a quick reminder to encourage you to attend my next round of all-day precon training session at the upcoming SQL Saturday in Minnesota on Friday, October 6 called ‘The Complete Primer to SQL Server Infrastructure and Cloud‘.

The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with the concept and purposes 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 will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

The following topics will be addressed during the course:

Datacenter Fundamentals

Cloud versus On-Premises

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

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.

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.

I just realized that our two SQL Server on VMware sessions that I co-presented on Tuesday at VMworld USA, both of which made the top 10 sessions of the day list at the conference, are now on YouTube! They are free to watch for everyone!

For those of you with virtualized SQL Servers, regardless of platform and cloud or on-premises, I urge you to watch these two sessions at your convenience.

I’m prepping for VMworld EMEA in Barcelona next week and will do a wrap up post for both events afterwards, but wanted to share something with the world. I’m proud to announce that the two SQL Server on VMware sessions that I co-presented on Tuesday at VMworld USA made the top 10 sessions of the day list at the conference! As such, they are recorded and now available for non-attendees to watch! For those of you with virtualized SQL Servers, regardless of platform and cloud or on-premises, I urge you to watch these two sessions at your convenience.

Thank you for everyone that attended these sessions, and special thanks to those who submitted your kind and supportive comments in the session reviews. We are looking forward to an amazing Barcelona experience!

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.