Friday full-day Pre-Conferences
We're excited to offer FOUR Friday pre-cons this year! These pre-cons will be held at a seperate location from Saturday's event.
Location: 2650 Novation Parkway, Madison, 53713
Cost: $125.00 (lunch included)
Paul Turley - Mastering Power BI Solutions - Basics and Beyond
In this Power BI hands-on Workshop, you will learning essentials and some advanced techniques to transform, model and analyze business information with this powerful platform. Techniques and best practices presented are from several prior workshops and years of field experience. Learn to use self-service and enterprise-scale Power BI capabilities; gain valuable skills to integrate, wrangle, shape and visualize data for analysis. Beginning and intermediate level users will learn to address data and reporting challenges with advanced design techniques. At the conclusion of the workshop, you will have a complete solution built from real business data, shaped, cleansed & modeled; with a dashboard and interactive report visuals ready for analysis.
Topics & skills include: Power Query/M, modeling and calculations/DAX, standards & custom visuals, R visuals. Data sources: CSV, JSON, SQL Server; query folding, scheduled refresh & DirectQuery.
Kevin Boles - Tune Like a Guru!
In this Pre-Con event we will cover a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work. As a long-time relational engine consultant I have repeatedly found that the majority of clients I work with get amazing improvements by simply putting to use a fairly small collection of knowledge and tools. We will cover many topics, including:
- Server, virtualization and database configuration
- Optimization processes
- Understanding query plans
- Improving design
- Improving code
- Profiler use and analysis
- Temp object usage
- Waits and IO stall analysis
- ORM Badness
We will look at all of these things and more from a variety of angles, while also covering many of the tips, tricks, tools, etc. I have collected in my almost 45,000 man hours of working with SQL Server. I promise you will come away with lots of immediately-applicable information which you can take back to work and Tune Like A Guru!
Ben Miller - PowerShell for SQL Server
PowerShell is becoming a very powerful tool for SQL Server professionals. This session focuses on uses for PowerShell for managing, changing and gathering data in your SQL Server instances. I will cover from beginning to having tools in your hands when you leave that will increase your efficiency. From Backup, Restore, LogShipping to Availability Groups, Disk Space, Database Free Space and everything in between. This is a popular session across the country, join me for a great time in diving into the technology that will change the way you manage SQL Servers.
Ed Leighton-Dick - Securing the Data Platform: Crafting a Strategy That Works
Your database servers are insecure, and you know it. Unfortunately, so does the person upstairs who just wants to take a peek. That executive who wants a copy of the database to build some reports on the plane knows it. So does the call center rep who’s trying to provide great service to the customer on the phone. And the hacker who’s attacking your website? Yeah, they know it, too. We can no longer rely solely on the same old security practices to protect our data. We need to secure the data at its source.
In this full-day course, we will take a tour of security for the Microsoft data platform, particularly SQL Server. The complex security needs of SQL Server itself will be presented as a series of layers to give participants a framework for planning and implementation. A significant portion of this discussion will focus on ensuring that all participants, regardless of past experience, gain a common, thorough understanding of the critical authentication and authorization struct