SQLSaturday 882

Iowa City, 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 22 2019 at University of Iowa - University Capitol Centre, 201 S Clinton St, Iowa City, Iowa, 52240, United States

Register Now

Pre-Conference Sessions

Our pre-conference sessions are now available for purchase! Each session is a full-day, in-depth session on that topic, taught by an experienced instructor. This year, we're proud to present two sessions for you to choose from:

  • The Modern Enterprise Data Warehouse in Azure (Joshuha Owen)

    With the smorgasbord of Azure service available, how do you approaching building a modern enterprise data warehouse?

    In this pre-con we will be covering both architecture patterns from Microsoft and actual implementations in the industry on how to move to Azure for your data warehousing needs. We'll cover the various offerings of Azure including storage, data ingestion and orchestration, databases , NoSQL, and streaming.

    We'll also cover how to analyze all of this data with tools and services like Power BI and Databricks. Finally, we'll cover strategies on how you get there; Lift-and-shift, hybrid, or brand new implementations will all be discussed.

    By the end of this pre-con you should have a thorough understanding of architecting a modern enterprise data warehouse in Azure including getting those services to work together and how to use that data effectively!

  • SQL Server Database Administration Best Practices (Rick Lowe)

    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? Any 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.

    Topics covered include query hints, indexing, LINQ to Entities, common table expressions, looping vs set-based operations and more.

Reserve your seat today for just $125!

Pre-Conference Session Registration

Event Location

Event news

Recommended hotels Read More

Pre-conference session call for speakers Read More


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