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

  Register Now!

Welcome to SQLSaturday #540
Sacramento 2016

Sacramento Skyline

Register

Click here to visit the SQLSaturday Sacramento 2017 event page

SQLSaturday Sacramento 2016 (SQLSaturday #540) is a free event hosted by the Sacramento SQL Server User Group.  The event will feature over 30 one-hour technical sessions presented in five concurrent tracks over seven time slots on Saturday, July 23, 2016, in Sacramento.

Microsoft SQL Server Professionals specializing in Business Intelligence, Database Development, Database Administration and more, will find sessions which address the Database Engine, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS) as well as other product areas.  Additionally, expect to find general Professional Development sessions.  Last year, our speaker lineup included numerous local speakers, two Microsoft Certified Masters of SQL Server and seven SQL Server MVPs; we're expecting another fantastic speaker lineup this year.

The event is also a great opportunity to talk with representatives from our sponsors which offer products and services in a variety of categories.   Whether you choose our convenient catered box lunch for $8 or provide your own lunch, you won't want to miss the informative lunch-time product sessions while you eat.  When the technical sessions have concluded for the day, we will meet outside on the front steps of the venue to select winners of the many raffle prizes which will be available.  We hope you'll choose to join us for some free coffee, donuts, a diverse training schedule and a unique networking opportunity.

When:
Saturday, July 23, 2016, 7:30 AM to 5:30 PM

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

What:
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, but we do charge a lunch fee of $8.00 so that we can provide a lunch. Please register soon as seating is limited, and let friends and colleagues know about the event.

Schedule:
Click here to see the schedule for this event.

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 22, 2016.  Choose either Kalen Delaney's "SQL Server Query Plans -- Reuse or Recompile?" or join Angel Abundez and Eric Bragas for "Power BI Kick Start".  Each pre-con is a full day of training available for purchase via the Eventbrite links below.

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

Pre-Con 1 When:
Friday, July 22, 2016, 8:30 AM to 4:30 PM

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

Pre-Con 1 What:
What determines when a plan is reused?  When is it better to recompile?  Reusing an inappropriate plan cause a huge reduction in query response time.  On the other hand, recompiling a frequently run query every time it's executed can also cause big performance problems.

In this seminar, we'll discuss how SQL Server decides to recompile or reuse an existing plan, and how you can tell if that's a good choice.  We'll also look at how you can 'encourage' SQL Server to do what you want it to do.

The seminar includes extensive demonstrations that illustrate the details of SQL Server plan caching and recompilation, as well as the internals of the plan cache and the metadata available for examining its contents.

This seminar will be presented on SQL Server 2014 and cover features specific to that version, but most of the information is relevant to SQL Server 2012 and SQL Server 2008 as well.

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


Pre-Con 2:
Angel Abundez and Eric Bragas
Power BI Kick Start

Pre-Con 2 When:
Friday, July 22, 2016, 8:30 AM to 4:30 PM

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

Pre-Con 2 What:
How do you take advantage of Power BI community custom visuals?  When should you choose to use a Power BI data model over a SSAS Tabular model?  In this full day session, we'll be learning the answers to all of these questions and more through hands on exercises driven by industry experience.

Join Angel Abundez and Eric Bragas of DesignMind as we guide you through building a full Power BI implementation.  We'll begin with the end in mind by first working with an existing Power BI model to explore the various visualizations get familiar with analyzing data using a well-built model.  Then, we'll develop our own workbook from a variety of data sources using the functionality of Power BI Queries and DAX measures in your Data Model.  So bring your laptop, grab a cup of coffee, and get ready to learn.

Topics:
Visualize Data with Power BI Desktop
Build a Data Model with Power BI Desktop
Publish reports to the Power BI Service
Power BI Model or SSAS Tabular Model? Which do I choose?
Advanced Data Shaping
Build advanced visualizations with R
File management with OneDrive
Intermediate DAX Patterns

Pre-Con 2 Registration:
For more information, or to register for this precon event, please click here:
Eventbrite - Power BI Kick Start, SQL Saturday #540 Sacramento Precon with Angel Abundez and Eric Bragas


 

SQLSaturday #540 Registration

To register for SQLSaturday #540 in Sacramento on July 23, 2016, click here:

Register

Event news

  • Wednesday, July 20, 2016 11:19:00 PM

    SQLSATSAC Speaker Anthony Nocentino mentioned his session in a blog post.

  • Monday, July 18, 2016 8:20:00 PM

    Check out SQLSATSAC Speaker Cathrine Wilhelmsen's blog post about her Biml and Data Warehouse presentations!

  • Wednesday, May 25, 2016 9:15:00 AM

    Call for speakers deadline extended to May 31st!  We have approved all 25 speakers that have submitted sessions to date, but still have room for a few more!  Register by May 31st if you'd like to be a speaker at SQLSaturday Sacramento 2016!

  • Saturday, April 23, 2016 3:16:00 PM

    Second pre-con added: "Power BI Kick Start" with Angel Abundez and Eric Bragas.  Register by May 31st to get the best rate!

  • Saturday, April 23, 2016 3:11:00 PM

    Pre-con added: Kalen Delaney: "SQL Server Query Plans -- Reuse or Recompile?"  A full day of training with Kalen Delaney for under $150 for early-bird registrants!

Event Location

Contact the Organizer

Click here to view the event XML feed.

SQLSaturday