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