SQLSaturday 719

Chicago, 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 Mar 17 2018 at Benedictine University, 5700 College Rd, Lisle, Illinois, 60532, United States

Register Now

Pre-conference Sessions

We are thrilled to welcome four distinguished industry experts: Aaron Nelson, Cathrine Wilhelmsen, Ed Leighton-Dick and Eddie Wuerch, who will be hosting pre-cons this year. Come attend an amazing in-depth day of training, the day before SQL Saturday!

  • If you register for a pre-con: you must still register to attend SQL Saturday.
  • If you register for a pre-con and are on the SQL Saturday wait-list: please e-mail a copy of your pre-con registration receipt to sqlsaturday719@sqlsaturday.com.
  • Aaron Nelson presents: Hands-On Power BI : Monitoring Your SQL Server Environment

    Power BI has amazing reporting capabilities, but you may not know where to start. This precon will show you multiple real-world solutions, from start to finish. By the end of the day, you’ll know how to fully implement a Power BI solution.

    In this hands-on session, you will learn to Get, Model, Visualize, & Share your data! You will learn how to start from nothing and turn it into an engaging, interactive visualization. This session will show practical examples of how to visualize data from your SQL Server environment, by using data collected from dbareports.io processes, dbachecks.io, and other popular sources.

    If you’re not into monitoring server performance don’t worry! This session will also include data examples from publicly available data sets like airline flight delays. At the end, you will walk away with all of the example files, so you can continue to get your hands dirty when the session is over.

    Register For Aaron's pre-con here.


    Cathrine Wilhelmsen presents: Level Up! From Basic Biml to Automated Data Warehouse Frameworks

    Have you ever wanted to build a Data Warehouse simply by pushing a button? It might not be quite that simple yet, but gone are the days of repetitive development. Biml (Business Intelligence Markup Language) helps you create powerful Data Warehouse frameworks using SSIS in just days instead of months.

    This full-day workshop will give you a solid understanding of Biml and how you can use it to improve your own work day: From the basics of Biml, to generating hundreds of SSIS packages using BimlScript, to creating metadata-driven frameworks for automating Data Warehouse development. Along the way, you will learn about best practices, coding techniques and how you can gradually adopt Biml in existing small or large projects.

    Bring your laptop to get some hands-on experience, participate in discussions with your fellow attendees, and learn how to work better with Biml. If you're a new SSIS Developer or an experienced Data Warehouse Architect, working in-house or as a consultant, or even if you're a Jack of All Trades - you will leave this workshop with new ideas for your projects :)

    Register For Cathrine's pre-con here.


    Ed Leighton-Dick presents: 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. Whether you’ve already moved to the cloud or are just thinking about it, this is a session you won’t want to miss!

    Register For Ed's pre-con here.


    Eddie Wuerch presents: Performance Tuning with Waits and Queues: a Full Day of Waits

    Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? Your process could be waiting on many different things – a lock, memory, disk, CPU, and much more. When a process waits, SQL Server logs it. There are hundreds of wait types, and they’re a gold mine for finding and solving problems. If you’re not using this approach, then you’re flying blind. If you’ve looked at Activity Monitor and seen all those crazy codes like CXPACKET, PAGEIOLATCH_SH, LCK_M_IX, ASYNC_NETWORK_IO, WRITELOG, SLEEP_BPOOL_FLUSH, and wondered what they mean and what to do with that info, then this seminar is for you. Those cryptic codes are the key to solving performance issues with the least effort - quickly find not just what is slow, but why it is slow. These techniques work on any size database, physical or virtual, on-prem or in the cloud.

    Join Microsoft Certified Master Eddie Wuerch as he reveals the simple but critical techniques experts use to troubleshoot and tune SQL Server systems and workloads of every size. Stop guessing, start knowing!

    Register For Eddie's pre-con here.

    On-Site Lunch

    We are pleased to offer on-site lunch on Saturday, March 17. Lunch is optional and available for $15 pre-paid. Lunch will not be available for purchase on the day of the event. Lunch fees are not refundable.

    Hotel Blocks are open! Book by February 23rd to secure the rate. Room block is "SQL Saturday"

    HILTON LISLE/NAPERVILLE for $95 USD per night
    http://group.hilton.com/chicagosqlassociation (Group code is CSQL)

    Chicago Marriott Naperville  for $119.00 USD  per night
    Book your group rate for SQL SATURDAY CHICAGO

    Event Location

    Event news

    Call for Pre-Cons is Open! 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