VMworld 2017 USA SQL Server Sessions

Heraflux is proud to announce that our SQL Server sessions for this year’s VMworld 2017 conference in Las Vegas have turned up in the VMworld Content Catalog! David Klee has four exciting sessions at the conference, and for those DBAs with VMware administrators attending this conference, tell them to attend these sessions so they can help build a better platform for your data.

ALL DAY SQL Server on VMware Boot Camp

The second revision of our business critical applications and databases pre-conference workshop is to be held at VMworld 2017 US this year on August 26th!

We 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 workshopwill 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! Add the training course at the bottom of the VMware Education courses during the registration process.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right [VIRT1309BU]

with Michael Corey

VMware vSphere 6.5 has made a lot of changes to enhance the performance of Monster virtual machines (VMs). Databases by their very nature are the classic 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 will teach you how to properly virtualize Monster VMs/databases with vSphere 6.5. We will discuss why you should virtualize and take a look at some installation issues as well as how to architect for performance in terms of vSphere 6.5 specifics, including the storage layer, the processor, memory considerations, and the network layer. Topics will also include NUMA, memory reservations, and how to avoid common mistakes. These lessons will help you optimize any workload you are virtualizing.

Performance Tuning and Monitoring with Virtualized Database Servers [VIRT1430BU]

with Thomas LaRock

Business-critical database platforms are the last holdouts to enterprise virtualization. These systems are the most resource-demanding and latency-sensitive applications, and at the first symptoms of infrastructure challenges the DBAs blame the infrastructure. Successful virtualization of these platforms requires a different approach to virtualization from other applications. The speakers will share their years of experience in virtualizing data platforms. You will learn how to validate your VMware environment and manage the performance properly. Scalability concerns will be addressed through discussions on scaling database VMs upwards and outwards as you work with the DBAs to manage the data lifecycle. Key talking points will help you learn how to perfect database virtualization from a technical, an organizational, and people level.

SQL Server on vSphere: A Panel with Some of the World’s Most Renowned Experts [VIRT1930PU]

with Niran Even-Chen, Thomas LaRock, and Allan Hirt

Continuing from last year’s successful session, learn from some of world’s most renowned SQL Server experts’ real-life experiences gained while virtualizing the most demanding SQL Servers! In this panel discussion, you will also have the chance to ask your own questions about SQL Server on VMware vSphere and get answers from the SQL Server gurus.

For those of you who don’t manage SQL Servers in a VMware environment, check out all of the fantastic sessions in the performance tuning areas, as they are sure to help you boost performacne across your vSphere farms.

Register for VMworld USA today, and make sure to select the SQL Server on VMware boot camp as part of registration! We look forward to seeing you all there!

 

 


Webinar with Rubrik: Simplifying SQL Server Data Protection - Near Zero RTO

Heraflux is proud to contribute to a new webinar with Rubrik on Thursday, June 22 at 8AM PT / 11AM ET where we talk about the trials and tribulations of living as a Database Administrator and the challenges when handling SQL Server backups with the same tools as a VM-level backup.

If you’re a SQL DBA, you know that protecting and restoring your databases is critical. Plus, there are a lot of related items – ad hoc queries, test/dev queries, etc. – that the business needs but can be very time-consuming and/or expensive to handle. With the Alta Release, Rubrik is proud to announce SQL Live Mount – simply put, a very cool feature but also very powerful in day-to-day usage.

Join Andrew Miller, Technical Marketing Manager at Rubrik, Mike Fal, Database Solutions Engineer at Rubrik, and David Klee, SQL Server MVP and Founder and Chief Architect of Heraflux Technologies, as they walk through the simplicity of using Rubrik’s Cloud Data Management platform to protect, secure, and manage your SQL Server workloads. With demos throughout, we’ll cover:

Protect

  • Using Rubrik to protect SQL Overview
  • Creating + Applying SLA policies
  • Protection best practices from Andrew and David

Restore

  • Classic Restore Options – In Place Restore & Export
  • SQL Live Mount – Specific Use Cases & Demo
  • Restoration best practices from Andrew and David

When: Thursday, June 22 at 8AM PT / 11AM ET

Presenters: David Klee, Heraflux Technologies | Mike Fal, Rubrik | Andrew Miller, Rubrik

Register for this exciting free webinar today!


PASS Summit Precon on Virtual SQL Server Performance

PASS has just announced this year’s precon sessions for the PASS Summit in Seattle this October, and I am humbled to announce that my session, “Virtual SQL Servers – Right to Ludicrous Speed” has been selected for one of the Tuesday precon slots. 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 16 years of performance tuning.

If you are less interested in SQL Server infrastructure than other topics, I urge you to check out the other precons being presented at this conference. The topics and presenters are world class, and if I was not presenting this precon on Tuesday, I’d be in one of the other precons!

I hope all of you can attend what I consider the best SQL Server ecosystem conference in the world. I’ll never miss it, and I look forward to meeting you all there!

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!


Improving the Performance of Third-Party Vendor SQL Server Databases

Heraflux is proud to announce our next installment of live online training with Bob Pusateri (@SQLBob). The focus of this training session is called “Improving the Performance of Third-Party Vendor SQL Server Databases“, and focuses on how to help you get the most out of your vended databases without voiding the warranty.

In order to accommodate most DBA schedules, the session will be held in two four-hour blocks on the following dates and times.

Part 1: Tuesday, July 18th, 2017 from 1:00PM to 5:00PM (Central)

Part 2: Wednesday, July 19th, 2017 from 1:00PM to 5:00PM (Central)

DESCRIPTION

Microsoft Certified Master Bob Pusateri leads this course on improving SQL Server performance for third-party vendor applications. It’s not uncommon for applications to demonstrate lousy performance due to suboptimal schema design or poorly-performing database queries, and you know how to make it better. However, many vendors make it either impossible or outright forbidden to change that code. This all-day course will focus on the many options that Microsoft SQL Server offers to improve the performance of an application without altering its queries. Attendees will be exposed to numerous performance tuning practices at both the SQL Server and infrastructure levels, and will learn how to review key points of their stack to ensure optimal SQL Server performance for almost any vendor application.

The event runs in two four-hour windows, 1-5pm on Tuesday, July 18th and Wednesday, July 19th, so that data professionals can attend without having to take an entire day away from their ongoing responsibilities.

The following topics will be addressed during the course:

  • Wait Statistics
  • Execution Plans
  • Query Store
  • Plan Guides
  • Monitoring
  • Blocking and Locking
  • Primary and Foreign Keys
  • Parallelism
  • Server Configuration
  • Indexing & Statistics
  • Routine Maintenance
  • Hardware & Infrastructure
  • Tools & Scripts

More details about this exciting training class are available at Heraflux.com. We look forward to having you learn from our own certified Master!