September 2018 Training Opportunities

The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars!  We are very proud of our team and their efforts to share knowledge and experiences.  Be sure to say hello and ask questions when you see them!

GroupBy September 7, 2018

We are proud to announce that Martin Perez, close friend of Procure SQL, will be joining John Sterrett in presenting for GroupBy.Org!  GroupBy is FREE online SQL Server training by the community, for the community!  This month’s training  is scheduled for September 7, 2018 beginning at 8:00 AM Eastern, with the last session starting at 2:15 PM!

Registration is free! 

Martin Perez (11:45 AM Est)

Martin will be presenting “T-SQL Tools: Simplicity for Synchronizing Changes” at 11:45 AM Eastern.
Any DBA or developer that has ever faced the problem of moving data changes across databases will surely benefit from this session.  One of the most common problems a DBA or database developer may face is finding an syncing data changes efficiently between multiple systems.  He will explore different methods focusing on effective use of TSQL, and how these methods can be mixed and matched in your ETL workflows:

• Brute Force
• Log Shipping/Read Only Standby
• Rowversion datatype
• Change Tracking
• Change Data Capture
• Temporal Tables

Martin hopes to assist the DBA or Developer free up time and energy by understanding all the available options.  Come find out why brute force is not the only path forward!

John Sterrett (1:00 PM Est)

Directly following Martin, John Sterrett will be presenting “Make Your Own SQL Server Queries Go Faster” at 1:00 PM Eastern.
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster?  It is how John stumbled into his career in performance tuning.  In this session, you will learn some T-SQL performance tuning tips that can be used in the office immediately. You will learn how to identify top offender queries and be able to benchmark queries. Finally, he will cover some coding patterns that are developer friendly (but are not SQL Server database engine friendly) and show you how to rewrite them so they can run faster.

SQL Saturday #774 – Denver, CO September 15, 2018

If you are in the Denver, Colorado area, be sure to register for SQL Saturday #774!  The free training event will be held on Saturday, September 15, 2018 at the University of Denver in Sturm Hall.  Registration is free!

Two of our team members will be presenting!  Both John Sterrett and Angela Tidwell will be presenting at 9:00 AM.  

John Sterrett

John will be presenting “Automate the Pain Away with Adaptive Query Processing and Automatic Tuning“
In this Intermediate level session, John will explore how tuning SQL Server workloads is changing. In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events. In SQL Server 2012 Columnstore indexes were introduced; In SQL 2014 the cardinality estimator got a huge overhaul. With SQL Server 2016 we were given query store to allow us to get more insight into our performance pains and execution plan changes. SQL Server 2017 gave us Automatic Tuning and Adaptive Query Processing to help automate performance improvements. In this session, he will harness ways to improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.

Angela Tidwell

Angela will be presenting “Become the Most Valuable Player: Soft Skills for the Hard Market“
This session is for beginners and seasoned pros alike.  Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success. Often times we focus on showing how smart we are instead of showing what a good team member we can be.  In this session, Angela will discuss the role and types of soft skills needed to showcase your X-factor.  Need to hone your skills?  She will explore innovative and fun ways in which to do just that!  Get ready, Angela likes to wake you up and make you think: she likes to have fun in this session!

SQL Saturday #802 – San Diego, CA September 22, 2018

Planning to be in San Diego on September 22, 2018? If so, you can catch Jay Falck speaking at SQL Saturday #802!
SQL Saturday San Diego will be held at UCSD Extension – University City Center and Registration is free!

Jay Falck

Jay will be presenting “Introduction to Linux for SQL Server“
SQL Server is now available on Linux but you only know Windows, now what?  In this beginner level course, Jay will introduce the Linux version of Windows commands used on a daily basis for administering SQL Server.  He will explore updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another.  Also he will dive into default file locations for SQL Server and what can be moved and how to accomplish that.

SQL Saturday #770 – Pittsburgh, PA September 29, 2018

Pittsburgh Technical College will be hosting SQL Saturday #770 on September 29, 2018.  As always, registration for SQL Saturday is free!

John Sterrett

John will be presenting Automate the Pain Away with Adaptive Query Processing and Automatic Tuning at 10:00 AM Eastern.
The way you tune your SQL Server workloads are changing.  In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events. In his intermediate level session, John will explore the ways to improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.