SQLSaturday 842

Madison, 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 Apr 06 2019 at Edgewood College, 1000 Edgewood College Dr, Madison, Wisconsin, 53711, United States

Register Now

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)

Erik Darling – Total Server Performance Tuning

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.

Brian Larson – Powering up with PowerBI

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.

Ben Miller – Leveling up with PowerShell for the DBA

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.

Joshuha Owens - The Modern Enterprise Data Warehouse in Azure

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!

Event Location

Event news

Pre-Cons Announced! Read More

One Step Closer 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