SQLSaturday #604 - Madison 2017 > Event Home

SQLSaturday 604

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 08 2017 at The Pyle Center, University of Wisconsin-Extension, 702 Langdon Street, Madison, Wisconsin, 53706, United States

Register Now

Welcome to SQLSaturday Madison 2017!

The Sixth annual SQL Saturday Madison returns to the beautiful Pyle Center! We welcome data professionals from far and wide to learn new skills and make new connections within the SQL Server community. Admittance to this event is free, but we do charge a lunch fee of 15.00 so that we can provide a lunch - not pizza! Once paid, lunch fees are non-refundable. Lunch is optional - you're welcome to do lunch on your own!

Please register soon as seating is limited, and let friends and colleagues know about the event!

Remember to check out Wisconsin's PASS Chapters to stay connected with your fellow SQL Server professionals all year round: 


FoxPASS - Appleton, WI
MADPASS - Madison, WI 
Microsoft BI Professionals - Wisconsin: Greendale, WI
Western Wisconsin PASS - Eau Claire, WI
WausauPASS - Wausau, WI
WI SSUG - Waukesha, WI


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
- Statistics
- Indexing
- 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


Event Location

Event news

WHERE DO I PARK? Live and interactive parking information can be found here and here. 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