SQLSaturday 757

Sacramento, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Jul 28 2018 at Patrick Hays Learning Center, 2700 Gateway Oaks Drive, Suite 2600, Sacramento, California, 95833, United States

Register Now

Welcome to SQLSaturday #757 Sacramento 2018

Sacramento Skyline

Click here to visit the SQLSaturday Sacramento 2019 event page


Do you work with the Microsoft Data Platform (SQL Server, Azure, Power BI)? Join us for SQLSaturday Sacramento 2018 (SQLSaturday #757) to enhance your technical skills and build your professional network!

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!

Saturday, July 28, 2018, 7:30 AM to 5:30 PM

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

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

The event schedule may be found here.

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, July 27, 2018.  Choose either Kalen Delaney's "SQL Server Internals for Performance" or join Rick Lowe for "Keeping Your DBA Happy and Understanding Why".  Each pre-con is a full day of training available for purchase via the Eventbrite links below.

Pre-Con 1:
Kalen Delaney: SQL Server Internals for Performance

SQLSatSac757 Kalen Delaney PreCon

Pre-Con 1 When:
Friday, July 27, 2018, 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:
We all know that the answer to almost any SQL Server tuning question is “It Depends!”

In this seminar, I’ll tell you what you need to know in order to figure out what it actually depends on! How can you answer these “It Depends” questions in your own environment? We’ll look at what kinds of tuning changes can be made to enhance your system or application performance, and what areas of SQL Server Internals you need to understand to make the best choice for you when trying to answer the following questions:

  • Should we build a clustered, nonclustered or columnstore index? We’ll compare the structure of these different kinds of indexes and looks and the best practices for using each type.
  • Is reusing cached query plans a good thing? We’ll look at the different ways SQL Server can cache and reuse plans and discuss how to tell when reuse is desirable. We’ll explore how to encourage SQL Server to recompile a plan when that that is the best option.
  • Should Read Committed Snapshot Isolation be enabled? We’ll explore what exactly happens internals when RCSI is enabled and that the uses cases are for this option. We’ll also talk about situations in which you might not want to use this.
  • How many files should tempdb be configured with? To understand why tempdb has concurrency considerations that aren’t applicable to other databases, we need to understand some of SQL Server’s internal allocation algorithms. We’ll look at how pages are allocated for temp tables and what changed in SQL Server 2016. With this information, we’ll be able to consider the best practices recommendations and determine what is best in your environment.
If time allows, their might be a few other questions we could discuss!

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 1 Registration:
For more information, or to register for this precon event, please click here:
Eventbrite - SQL Server Internals for Performance, SQL Saturday #757 Sacramento Precon with Kalen Delaney

Pre-Con 2:
Rick Lowe: Keeping Your DBA Happy and Understanding Why

SQLSatSac757 Rick Lowe PreCon

Pre-Con 2 When:
Friday, July 27, 2018, 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:
Ever used a NOLOCK hint, only to find that nothing broke the next day? Odds are most folks reading this have. So if fire and brimstone did not rain from the sky, why do we worry so much about this hint? What could actually go wrong? SQL Server supports two table types - heaps and tables with clustered indexes. We almost always create a unique clustered index on tables ... but why? Since heaps are part of the product they must have a use case but what is it? And what is the secret sauce in clustered indexes that makes them so popular? There is a substantial body of best practice information in the SQL Server community. Many of these practices are routinely ignored in some organizations, presumably because the consequences of not following aren't always clear. Come join this full day session for in-depth explanations of _why_ we give some of the advice that we do. Query hints, indexing, LINQ to Entities, common table expressions, looping vs set-based operations and more.

Rick is a Microsoft Certified Master with more than 15 years of experience working with SQL Server. He currently works as an independent performance DBA/Developer for clients across the USA and Canada. He started his career as a database developer, but over time became more and more interested in how the database engine operated ... eventually becoming more focused on operational and performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

LinkedIn - https://www.linkedin.com/in/rick-lowe-441228a/
Blog - https://dataflowe.wordpress.com/
Twitter - @DataFLowe

Pre-Con 2 Registration:
For more information, or to register for this precon event, please click here:
Eventbrite - Keeping Your DBA Happy and Understanding Why, SQL Saturday #757 Sacramento Precon with Rick Lowe


SQLSaturday #757 Registration

To register for SQLSaturday #757 in Sacramento on July 28, 2018, click here:




Event Location

Event news

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


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids