SQLSaturday 885

Sacramento, United States

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 Aug 17 2019 at Patrick Hays Learning Center, 2700 Gateway Oaks Drive, Suite 2600, Sacramento, California, 95833, United States

Register Now

Event schedule is not published yet.

Welcome to SQLSaturday Sacramento 2019

Sacramento Skyline

Register

What's that? You say you're a Microsoft Data Platform specialist in Sacramento, the Central Valley or the Bay Area, working with SQL Server, Power BI, Azure and related technologies, and you're looking for a full day of free training on Saturday, August 17, 2019? You've come to the right place!

SQLSaturday Sacramento 2019 is a unique opportunity to learn, hang out and network with 250 of your soon-to-be closest friends! We're planning to offer 30+ hours of fun, packed into a nine hour event, with local, national and possibly even international guest speakers, covering a variety of Microsoft Data Platform topics. If you've ever wanted to attend PASS Summit in Seattle but just can't make the trip, this is the next best thing, and it's right here in Sacramento!

This is a full day of FREE training with dozens of sessions to choose from, covering a wide variety of Microsoft Data Platform topics. Register today!

When:
Saturday, August 17, 2019, 7:30 AM to 5:30 PM

Where:
Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, CA 95833

What:
SQLSaturday Sacramento 2019 is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admission is free. An optional lunch is $10.00. Please register soon as seating is limited, and let friends and colleagues know about the event.

Schedule:
The event schedule will be published at a future date.

Social Media:
Use the #sqlsatsac hashtag on Twitter and other social media!

Pre-Conference Seminars

We are pleased to offer two pre-conference seminars on Friday, August 16, 2019.  Choose either Brent Ozar's "Performance Tuning in 21 Demos" or join Kalen Delaney for "SQL Server Query Plans: Reuse or Recompile".  Each pre-con is a full day of training available for purchase via the Eventbrite links below.

Pre-Con 1:
Brent Ozar: Performance Tuning in 21 Demos

SQLSatSac885 Brent Ozar PreCon

Pre-Con 1 When:
Friday, August 16, 2019, 8:30 AM to 5:00 PM

Pre-Con 1 Where:
Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, CA 95833

Pre-Con 1 What:
You're a developer or DBA who wants to tune indexes and queries to make your application go faster. You don't like learning by watching slides or reading white papers - you want to jump right into the code and see what happens. You're the kind of person who loves watching YouTube videos that start with, "Hold my beer and watch this."

In one demo-filled day with Brent Ozar, you'll see SQL Server 2019 make questionable lifestyle choices. It will wildly underestimate the work required with a query, pick the wrong indexes, and jump off the roof into the pool while holding the TV - all in an effort to deliver the right query results. Brent will show you how to coach the database engine into better performance and less problems.

Prerequisites: You should be comfortable writing queries, but not at all comfortable with making them go faster. If you bring a laptop running SQL Server 2016 or newer, you can follow along with the demos - but you don't have to. Brent will lend out the Stack Overflow 2013 (50GB) database on USB drive during class for you to restore.

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.

Blog - BrentOzar.com
Twitter - @BrentO

Pre-Con 1 Registration:
For more information, or to register for this precon event, please click here:
Eventbrite - Performance Tuning in 21 Demos, SQL Saturday #885 Sacramento Precon with Brent Ozar

 

Pre-Con 2:
Kalen Delaney: SQL Server Query Plans: Reuse or Recompile

SQLSatSac885 Kalen Delaney PreCon

Pre-Con 2 When:
Friday, August 16, 2019, 8:30 AM to 5:00 PM

Pre-Con 2 Where:
Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, CA 95833

Pre-Con 2 What:
The seminar includes extensive demonstrations that illustrate the details of SQL Server plan caching and recompilation. We’ll look at the metadata available to help us explore the plan cache and discuss the various mechanisms that SQL Server uses to decide when and how to cache and reuse a plan.

This seminar will be presented on SQL Server 2017 and cover features specific to that version, but most of the information is relevant to SQL Server 2016, SQL Server 2014 and some earlier versions as well.

Topics:
  • Overview of Query Plans
  • Optimization and Recompilation
  • Exploring and Managing the Plan Cache
  • Parameter Sniffing
  • Determining when recompilation is preferable to plan reuse

Kalen Delaney has been working with SQL Server for over 30 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2016 Internals: In-memory OLTP, from Red Gate.

Blog - SQLServerInternals.com/blog
Twitter - @sqlqueen

Pre-Con 2 Registration:
For more information, or to register for this precon event, please click here:
Eventbrite - SQL Server Query Plans: Reuse or Recompile, SQL Saturday #885 Sacramento Precon with Kalen Delaney

 

SQLSaturday Sacramento 2019 Registration

To register for SQLSaturday Sacramento 2019 in Sacramento on August 17, 2019, click here:
Register

PASS Summit 2019 Discount Code:  LGDIS6HUR
Attending PASS Summit 2019 in Seattle this November? Use discount code LGDIS6HUR to save $150 and support the Sacramento SQL Server User Group when you register for the Full 3-Day PASS Summit!

Event Location

Event news

No Event News entered. Please come back later and check again

Contact

Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us


What is SQLSaturday?

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, and most costs are covered by donations and sponsorships. At some events you will have the option to pay for lunch at the time of registration. Please register soon as seating is limited, and let friends and colleagues know about the event.

Back to Top cage-aids
cage-aids
cage-aids
cage-aids