SQLSaturday 724

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

Register Now

Welcome to SQLSaturday Madison 2018!

The Seventh 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 
Western Wisconsin PASS - Eau Claire, WI
WausauPASS - Wausau, WI
WI SSUG - Waukesha, WI


Friday full-day Pre-Conferences

We're excited to offer FIVE Friday pre-cons this year! These pre-cons will be held at a separate location from Saturday's event.

Location: 2650 Novation Parkway, Madison, 53713

Cost: $125.00 (lunch included)

Tom Pizzato: Moving your on-premise SQL Server workload to Azure

This pre-conference will look at what it takes to move your SQL Server workload to Azure. We’ll start with an overview of the Modern Data Estate, explaining the different data technologies from Microsoft in order to level set your data options in Azure. We’ll then take an on-premise SQL Server data warehouse and move it to SQL Server in an Azure VM (IaaS), Azure SQL Database (PaaS), and SQL Data Warehouse (PaaS). We’ll show you how to work with Azure storage, management tasks, security, networking, performance and data loading. Finally, we’ll address moving SSAS workloads to Azure as well as introduce you to Azure Data Factory for orchestration.

Kevin Feasel - Enter the Tidyverse: R for the Data Professional

In this day-long training, you will learn about R, the premiere language for data analysis.  We will approach the language from the standpoint of data professionals:  database developers, database administrators, and data scientists.  We will see how data professionals can translate existing skills with SQL to get started with R.  We will also dive into the tidyverse, an opinionated set of libraries which has modernized R development.  We will see how to use libraries such as dplyr, tidyr, and purrr to write powerful, set-based code.  In addition, we will use ggplot2 to create production-quality data visualizations.
Over the course of the day, we will look at several problem domains.  For database administrators, areas of note will include visualizing SQL Server data, predicting error occurrences, and estimating backup times for new databases.  We will also look at areas of general interest, including analysis of open source data sets.
No experience with R is necessary.  The only requirements are a laptop and an interest in leveling up your data professional skillset.

Rick Lowe - Keeping Your DBA Happy. Why Some Practices Drive Admins Crazy

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.
Query hints, indexing, LINQ to Entities, common table expressions, looping vs set-based operations and more

Ben Miller - PowerShell Modules for the SQL DBA

Ever wonder what the buzz is about using SQL Server and PowerShell together? If you have wondered, you are not alone. This day long precon goes into the PowerShell modules that are out there that make your life so much better. From the SQLServer module from Microsoft to the DBATools module from the SQL Server Community (created by Chrissy LeMaire) there are so many good Functions out there that you will love. We will be diving into the commands and where you can get the most bang for the buck out of them. Join me for a great look at these modules and how they can make your DBA work more productive. On the journey to become a PowerShell DBA

Ed Leighton-Dick - Data Security For the Cloud

Have you moved your application to the cloud? Are you thinking about it? Great! Now… how are you securing it?
Security becomes paramount when you move your data to the cloud - after all, it is a much more public resource than the corporate network you’re accustomed to using. Depending on the platform you choose, the vendor may take care of part of the security needs, but they don’t handle all of them. So what, exactly, is your responsibility? And where do you start?
Microsoft MVP Ed Leighton-Dick will answer these questions and more in this full-day workshop on how to best secure your data in the cloud. Topics will include the most common vulnerabilities your data will face on a cloud platform; differences between the current offerings on the major cloud platforms; and the implementation of technical necessities like authentication, encryption, connection security, and monitoring.


Event Location

Event news

No Event News entered. Please come back later and check again


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