Friday full-day Pre-Conferences
We’re excited to offer FOUR Friday pre-cons this year! These pre-cons will be held at a separate location from Saturday’s event.
Location: 310 S. Westfield Rd, Madison, WI 53717
Cost: $130 (Lunch Included)
You've been working with SQL Server for a few years, and you're sick and tired of not being able to understand how it all works. Every day, you stare at monitoring tool charts and graphs, wait stats, and widgets, and none of it seems to add up. In this fast paced full day of demos, I'm going to show you how queries interact with your server, and each other. You'll discover that concurrency isn't just about locking and blocking; concurrency is also about hardware. I'm going to teach you how to diagnose your worst server issues and practical ways to solve them.
Technology author Brian Larson brings his experience architecting and implementing Power BI solutions across multiple industries, including insurance, manufacturing, and financial, to provide a day-long instructional session covering each aspect of Power BI. We will cover:
• Data collection using the Query Editor and the M language
• Data modeling
• Measures using basic and intermediate DAX formulas
• Visualizations with an emphasis on user interactivity including the latest interactive and drill through features
• Deployment and management in a secure, shared environment
Along the way we will look at tips and tricks as well as best practices for each of these facets of Power BI. Participants will leave with an understanding of the full range of capabilities of Power BI along with the confidence to use Power BI to create and securely share meaningful analytics.
PowerShell for the DBA is all the rage. You may have learned a little or a lot about using PowerShell as a DBA and that is GREAT! Now is the time to level up and get moving in a more practical fashion. This day long event will take you through actual DBA tasks and functions using many different methods. From Modules that exist like DBAtools and SqlServer to custom scripts or functions that you may use every day. I will take you through 2 different paradigms, the Execution side of PowerShell and the Building side of PowerShell. I will be sharing real world scenarios and sharing my code that I use every day to keep my tasks simple and click free. Join me for a demo filled day and you are even welcome to bring your laptop and get some help getting it set up on your system during lunch and breaks. Continue your journey to becoming a Real PowerShell DBA.
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 in the industry on how to move to Azure for you 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 the architecting a modern enterprise data warehouse in Azure including getting those services to work together and how to use that data effectively!