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 firstname.lastname@example.org.
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.
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.
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.
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.
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