training

Improving the Performance of Third-Party Vendor SQL Server Databases

Microsoft Certified Master Bob Pusateri leads this full-day 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.

This session is part two of a two-part training class. More details are here!


Performance Tuning Third-Party Vendor SQL Server Databases

Microsoft Certified Master Bob Pusateri leads this full-day 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.

This session is part one of a two-part training class. More details are here!


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!


Reminder - SQL Saturday Chicago Precon

We just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic and David Klee are holding precons the Friday before the event. The SQL Saturday in Chicago this year has hit peak capacity two months before the event. However, if you enroll in one of the precons, and hopefully my “The Complete Primer to SQL Server Infrastructure and Cloud” session, email the SQL Saturday coordinators with your EventBrite receipt and your admittance will be guaranteed!

This event 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!


VMware Expert Database Workshop Wrapup

Two weeks ago, Heraflux was proud to be part of the next wave of the SQL Server Expert Workshop hosted by VMware Corporation in Sofia, Bulgaria. These sessions are driven from VMware Corporation’s desire to produce the best hypervisor for mission-critical applications. Periodically, VMware invites a number of SQL Server and Oracle experts from around the world to meet for a three day interactive workshop on all aspects of database virtualization. The goals are two-fold: to educate these individuals on where VMware is going with database virtualization, and to learn from them on the current challenges they face and their experiences with enterprise virtualization so they can improve the platform and features.

This session was held at the VMware Sofia Bulgaria office, where a number of the technical experts who build the various platforms and features that VMware users utilize every day.

vmware-corp-sofia-bulgaria

This session’s attendees come from the SQL Server community from all over the world, including Netherlands, Slovenia, United Kingdom, Germany, Austria, Bulgaria, Poland, Italy, Kosovo, Norway, South Africa, and United States.

In addition to the attendees are a number of veterans of the class, including Michael Corey of Corey & Associates, Allan Hirt of SQLHA, Denny Cherry of Denny Cherry & Associates Consulting, and David Klee from Heraflux.

Many individuals from VMware Corporation push very hard for months to make these sessions happen, including:

  • Don Sullivan, Product Line Marketing Manager, VMware
  • Mohan Potheri, Senior Solutions Architect, VMware
  • Deji Akomolafe, Staff Solutions Architect, VMware
  • Niran Even-chen, Staff Solutions Architect & Double VCDX, VMware
  • Harry Girgorov, Events and Program Manager, VMware
  • Ralitsa Drumeva, Management Assistant, VMware

Michael Corey took some amazing photos during the event, and they are available here:

Day 1 Day 2 Day 3

Twitter #VMWSQL

This event is Heraflux’s third iteration of this training session, and like previous sessions David Klee assisted in the class by giving multiple training sessions on the inner workings of the VMware platform and tuning for performance.

These sessions are world-class, and the knowledge transfer is bidirectional.

Heraflux would like to thank VMware for letting us continue to be a part of these sessions, and would like to thank the VMware staff in Bulgaria for their incredible hospitality and comradery.

20161117_205345

20161114_081635

20161115_21233020161115_212442

20161115_152208

We look forward to the next one, wherever in the world it is held!


SQL Server Infrastructure and Virtualization Boot Camp

Heraflux is 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


Heraflux Presenting at USENIX LISA16 in December

lisa16_button_neat_180Heraflux is proud to present that Deji Akomolafe from VMware Corporation, and Cody Chapman and David Klee will be presenting at this year’s USENIX LISA16 conference in Boston, MA, from December 4-9th!

The three of us are presenting a half-day workshop entitled “Designing Your VMware Virtual Infrastructure for Optimal Performance, Resilience and Availability – Straight from the Source” from 1:30p – 5:00p on Monday, December 5th.

akomolafe_deji_100x115  chapman_cody_100x115  klee_david_100x115Read more


Special Discount for PASS Summit Precon

Heraflux is honored to be speaking at the PASS Global Summit again this year in Seattle during the week of October 24th. David Klee is presenting two sessions on our favorite topic – the convergence of infrastructure and data. We have a special discount code for you if you have not already registered for this exciting class!

Read more


Heraflux at IT/Dev Connections This Week

ITnDevConnections_logo_TylerOptimized_236x59This is just a friendly reminder that Heraflux is speaking at this year’s IT/Dev Connections conference held at the ARIA Resort in Las Vegas this week!

The first session is to be held on Wednesday, October 12th, at 11:00am, and is titled “Business Continuity for Virtual SQL Servers“.

Session Abstract: Do your SQL Servers have a different high availability or disaster recovery strategy than the rest of the servers, and the differences cause some friction with the infrastructure admins? SQL Server provides many features for improving high availability and disaster recovery resiliency, and they continue to evolve and change with each release. However, do these strategies and features complement or conflict with the current infrastructure strategy? How do these layers work together to protect the business? What if you can augment (or possibly replace) a complex SQL Server BC solution with a simpler, but just as effective, solution using some of the virtualization features available in today’s virtualized environments? This session will discuss strategies for improving your SQL Server uptime while reducing the complexity of your overall SQL Server continuity strategy.

The second session is to be held on Thursday, October 13th, at 10:30am, and is titled “SQL Server Infrastructure Performance“.

Session Abstract: The compute infrastructure beneath your critical SQL Servers is just one layer in the application system stack, but if issues are rampant under your data, your database performance is guaranteed to suffer, and your end user application performance experience is sure to be poor. As a DBA, we are usually at the mercy of the groups managing this hidden layer, but it does not have to be this way. Learning more about these layers of the system stack – physical compute server, virtualization, storage, interconnects, and networking – will help you understand how the infrastructure responds to a query request, and will make you a stronger database professional. You can also indirectly (or even directly) measure the performance of these layers to gain critical insight into their peculiarities.

This conference is not one to miss! Contact us if you want to meet up at the event to talk tech!