SQLSaturday 978

Los Angeles, 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 Jun 13 2020 at Loyola Marymount University ("LMU"), 1 LMU Drive, Los Angeles, California, Los Angeles, California, 90045, United States

Register Now

Welcome to a virtual 2020 SQL Saturday in Los Angeles event!

REGISTER | PRESENT | SPONSOR | VOLUNTEER | DOWNLOAD EVENT FLYER!

See the source image

Email SQLSatLA SQLSatLA on Facebook SQLSatLA on Twitter SQLSatLA on Linkedin SQLSatLA on YouTube SQL Sat LA on Instargam SQL Sat LA on Pinterest SQLSatLA on Reddit Follow us #SQLSatLA

 

 

 


Pre-Conference Full Day Training Sessions

performance_tuning_in_21_demos_2019-1

CANCELLED - 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)

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.”

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

RSVP here: https://www.brentozar.com/product/performance-tuning-in-21-demos/

microsoft-precon1

CANCELLED - Pre-Conference -  AzureSQL and AzureSQL Managed Instance interactive workshop by Anna Hoffman, Buck Woody, and Bob Ward

When: Friday, June 12, 2020 9 AM to 5 PM

Where: Loyola Marymount University, 1 LMU Dr., Los Angeles, CA 90045, University Hall, 3rd floor, McIntosh Room (University Hall building parking)

What

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.

RSVP here: https://azuresqlandazuresqlmanagedinstance-handsonworkshop.eventbrite.com

** 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 - CANCELLED


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 (Suitcasing)

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:

Hotel Distance from/to venue Complimentary
Custom Hotel 1.8 miles WiFi
Crowne Plaza LAX 3.2 miles WiFi, Parking for 1 vehicle, LAX shuttle
Embassy Suites 4.8 miles WiFi, Parking for 1 vehicle, Breakfast
Courtyard Marriott 3.5 miles WiFi
Hilton-Garden Inn 3.3 miles WiFi
Jamaica Bay 3.3 miles WiFi, 1-Hour bike rental

Use the following link to reserve the room - https://bus.lmu.edu/otherservices/localhotels/

Event Location

Event news

In-person event is cancelled! Stay tuned for information on our virtual event! Read More

CANCELLED - Pre-con with ABBA Team Read More

CANCELLED - Pre-con with Brent Ozar Read More

Contact

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
cage-aids
cage-aids
cage-aids