SQL Saturday

SQL Saturday Minnesota 2017

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Oct 07 2017 at Saint Paul College, 235 Marshall Avenue, Saint Paul, Minnesota, 55102, United States


SQL Saturday Minneapolis Precon Training

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.


SQL Saturday Atlanta 2017 Precon - Virtualization for SQL Server DBAs

Microsoft MVP, VMware vExpert and SQL Server performance expert David Klee leads this full-day, hands-on introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure 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, and will learn how to construct the entire stack with the focus on SQL Server performance.

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
  • SQL Server in the Cloud
  • High Availability and Disaster Recovery
  • Performance Investigation and Tuning of the Entire Stack

Upon completion of this course, attendees will be able to:

  • Understand key infrastructure, virtualization, and cloud 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

Register for this exciting event here!


SQL Saturday Iowa City 2017

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free - all costs are covered by donations and sponsorships. Lunch is available on-site for $10. Our Solutions Architect Bob Pusateri will be presenting a session at this exciting event!


SQL Saturday Iowa City 2017 Precon - 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 in advance of this year's SQL Saturday Iowa City. 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 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

Upon completion of this course, attendees will be able to:

  • Monitor relevant metrics and calculate a performance baseline for an application
  • Review their own enterprise infrastructure for performance bottlenecks
  • Determine the optimal SQL Server configuration for best performance of an application

SQL Saturday New York City 2017

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships (however, there is a $10 charge to help offset the cost of lunch). Please register soon as seating is limited, and let friends and colleagues know about the event.


SQL Saturday Atlanta Precon - The Complete Primer to SQL Server Virtualization & Cloud

If you are attending this year’s SQL Saturday in Atlanta, GA, on July 15, I urge you to attend my preconference training session – “The Complete Primer to SQL Server Virtualization & Cloud“. The architecture of the infrastructure underneath your mission-critical SQL Servers is vital to the well-being of your databases, and if any little component underneath is not running at its peak potential, your SQL Servers are artificially bottlenecked and your performance suffers. For any DBA out there who claims the infrastructure underneath the data, no matter if it's in the cloud or your own datacenter, is someone else's job, this session is going to show you just how important a working knowledge of these layers is to your livelihood.

Session Details
Microsoft MVP and VMware vExpert David Klee
leads this full-day introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure 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, 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
  • Virtualization and Infrastructure Fundamentals
  • The SQL Server Virtual Machine
  • Networking, Support, and Licensing
  • Performance Investigation and Tuning of the Entire Stack
  • Similarities and Differences with Cloud versus On-Prem

Course Objectives
Upon completion of this course, attendees will be able to:

  • Understand key virtualization and cloud concepts
  • Determine the optimal infrastructure configuration for best performance
  • 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 virtualized SQL Server performance killers
  • Understand proper virtualized 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 virtualized SQL Server in your own environments.

I look forward to seeing you all there! Registration for this event is located at EventBrite.


SQL Saturday Madison 2017

The Sixth annual SQL Saturday Madison returns to the beautiful Pyle Center! We welcome data professionals from far and wide to learn new skills and make new connections within the SQL Server community. Admittance to this event is free, but we do charge a lunch fee of 15.00 so that we can provide a lunch - not pizza! Once paid, lunch fees are non-refundable. Lunch is optional - you're welcome to do lunch on your own!

Please register soon as seating is limited, and let friends and colleagues know about the event!


Heraflux at SQL Saturday Madison April 8

Heraflux is proud to support the next SQL Saturday in Madison, WI this coming Saturday, April 8th. Both Bob Pusateri and David Klee from Heraflux will be presenting sessions at this exciting event.

Starting sharp at 9:00am, Bob is presenting a session entitled "Supercharging Backups and Restores For Fun and Profit", where he'll be showing tuning techniques for your routine SQL Server backups.

Abstract: Super-fast queries are an essential part of any business process, but speed will never be more important than during a disaster when you need to restore from backup. Come and see how both backups and restores can be tuned just like a query. In this demo-intensive session, we will discuss the different phases of the backup and restore processes, how to tell how long each of them is taking, and which are the easiest to significantly speed up. You just might be surprised how simple it is to achieve dramatic results - cutting your backup and restore times by 75% or more is absolutely possible using the methods covered here.

Also at 9:00am, David is presenting a session entitled "SQL Server Infrastructure – Cloud and On-Prem Options". He'll discuss the nuances of the infrastructure underneath SQL Server, and the similarities and differences with the regular options we've all used for years.

Abstract: Years ago, DBAs worked side-by-side with the infrastructure teams who managed the equipment their databases ran on. Today, organizations are more siloed than ever, and DBAs have less visibility into this layer than ever before. What is actually under the OS? Why does it matter? Physical servers, enterprise virtualization, and cloud servers all provide solid platforms for you to run your databases on, but improperly configured and tuned platforms can lead to performance nightmares. Let’s explore the various layers, options, and performance characteristics of the different systems underneath SQL Server so you can improve the performance of your systems.

We look forward to seeing each and every one of you at this event! If you'd like to meet up and talk about SQL Server performance and infrastructure, contact us!


SQL Saturday Chicago 2017

Heraflux is proud to contribute to this year's SQL Saturday in Chicago Illinois! SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.