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.