Welcome to the virtual 2020 SQL Saturday in Los Angeles event!
REGISTER | PRESENT | SPONSOR | VOLUNTEER | DOWNLOAD EVENT FLYER!
Pre-Conference Full Day Training Sessions
Pre-Conference - Performance Tuning in 21 Demos by Brent Ozar
When: Friday, June 12, 2020 9 AM to 5 PM
Where: Loyola Marymount University, 1 LMU Dr., Los Angeles, CA 90045, Life Sciences Building, Room LSB #120 (lot D parking)
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.”
Prerequisites: In one demo-filled day with me, Brent Ozar, you’ll see SQL Server 2017 and 2019 make questionable lifestyle choices. They’ll 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. I will show you how to coach the database engine into better performance and less problems.
- You should be comfortable writing queries, but not at all comfortable with making them go faster.
- If you want to follow along on your own computer, get the free Stack Overflow 2013 database
- Some of the demos will only work on specific SQL Server versions, like 2019 or 2017 – we’ll note that where applicable
Pre-Conference - AzureSQL and AzureSQL Managed Instance interactive workshop by Anna Hoffman, Buck Woody, and Bob Ward
Friday, June 12, 2020 9 AM to 5 PM
Loyola Marymount University, 1 LMU Dr., Los Angeles, CA 90045, University Hall, 3rd floor, McIntosh Room (University Hall building parking)
In this one day, hands-on, scenario-driven workshop, members of the SQL engineering team will help you translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL managed instance. At the end of the day, you should have a foundational knowledge of what to use when, as well as how to configure, monitor, and troubleshoot the “meat and potatoes” of SQL Server in Azure: security, performance, and availability. You will learn about not only the “what”, but also the “how” and the “why”. You’ll also walk away with resources and tools so you can go as deep as your scenario requires.
After the workshop, you should be able to…
- Determine which Azure SQL deployment option (virtual machines, single databases, serverless databases, elastic pools of databases, hyperscale databases, and managed instances) and service tier should be used for scenarios that meet the needs of your application.
- Deploy, configure, monitor, and troubleshoot security, performance, and availability scenarios in Azure SQL using both familiar and new tools and techniques.
- Harness the “power of the cloud” including automation and intelligent capabilities of Azure SQL.
- Translate your existing SQL Server expertise to Azure SQL expertise.
** Remember that if you register for a pre-con it does NOT automatically register you for SQL Saturday. Don't forget to register for our free day of training on Saturday as well!
STEM classes for kids (7-17 year olds)
Saturday, June 13, 2020 9 AM to 5 PM (excluding a lunch break)
Loyola Marymount University, 1 LMU Dr., Los Angeles, CA 90045, Malone Center
A complete iD Tech experience
Photography and Video Recording
When you attend SQL Saturday in Los Angeles event, you enter an area where photography, audio, and video recording may occur. By entering the event premises, you consent to interview(s), photography, audio and video recording and its/their release, publication, exhibition, or reproduction to be used for news, web casts, promotional purposes, telecasts, advertising, inclusion on websites.
Solicitation at events by non-exhibitors is strictly prohibited. As an attendee I agree that I will not approach other attendees or exhibitors in the exhibit hall or on the grounds of the conference venue for the purpose of offering to sell, demonstrate, or show products or services. I will not have in my possession or distribute product samples, brochures, marketing materials, videos, presentations, or any other representation of items or services for sale, for the purpose of displaying, showing, or selling to an attendee or exhibitor. This does not include the exchange of business cards through the course of normal networking. I understand that if I am found violating this policy the conference organizers may take any action they deem appropriate. These actions include but are not limited to, a warning, removal from the conference, and/or being prohibited from attending or speaking at future SQL Saturday in Los Angeles events.
Code of Conduct
All participants (including volunteers, sponsors, and speakers) must register through the SQL Saturday site and must agree to abide by the PASS Anti-Harassment Policy.
We will also be enforcing this policy at any official pre-or -post-event activities.
Please report any incidents to a volunteer or any organizer so we can take appropriate action.
Need a place to stay for SQL Saturday in Los Angeles? The following hotels have a special rate for LMU Guests:
||Distance from/to venue
|Crowne Plaza LAX
||WiFi, Parking for 1 vehicle, LAX shuttle
||WiFi, Parking for 1 vehicle, Breakfast
||WiFi, 1-Hour bike rental
Use the following link to reserve the room - https://bus.lmu.edu/otherservices/localhotels/