| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:45:00 | Karen Lopez | Application Database Development | The Tricky Part of Doing Tricky Things in your Database |
| 08:45:00 | Kirill Kravtsov | Enterprise Database Administration Deployment | The wonders of modern SQL Server administration |
| 08:45:00 | Mike Diehl | BI Platform Architecture, Development Administration | Introduction to Power BI |
| 10:15:00 | Karen Lopez | Cloud Application Development Deployment | Who's Pissing in Your Data Lake? |
| 10:15:00 | Patrick Flynn | Enterprise Database Administration Deployment | Database Corruption - Advanced Recovery Techniques |
| 10:15:00 | Mike Diehl | BI Platform Architecture, Development Administration | Building measures in Power BI (and SQL Server Analysis Services tabular models) |
| 12:45:00 | Karen Lopez | Application Database Development | A Database Designer's Favorite Features in SQL Server: Security, Privacy, and More |
| 12:45:00 | Brian Hansen | Enterprise Database Administration Deployment | Get Your Optimizer to Give up All Its Secrets |
| 12:45:00 | Phillip Labry | BI Platform Architecture, Development Administration | Why do I need Analysis Services? |
| 14:15:00 | Patrick Flynn | Application Database Development | GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects |
| 14:15:00 | Nem Schlecht | Application Database Development | Maximizing SQL Server Management Studio for Developers and DBAs |
| 14:15:00 | Melody Zacharias | Cloud Application Development Deployment | Introduction to Azure AI - The Art of the possible |
Event Date: 02-03-2019 - Session time: 08:45:00 - Track: Application Database Development
We'll demo tricks that we've seen in our database design reviews and show you how they work and talk about the trade offs for using them. You' learn about: Building a database engine inside your database, Implementing Hierarchies, Dealing with data structures that don't do as well in RDBMSs, Generating code out of the database, Optimizing the developer versus the data or the app, Using design patterns that don't reflect modern architectures and tools, …and a lot more.
Event Date: 02-03-2019 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment
Surprisingly, each of the tasks above - tasks that require a lot of manual effort and attention to details - can be done with writing just a few lines in a Powershell console! During this session you will see by yourself how easy it is to automate mundane processes using collective knowledge of SQL community. The session will introduce dbatools Powershell module that was written by DBAs for DBAs, and will showcase many regular DBA tasks converted to a concise scripting language:
Event Date: 02-03-2019 - Session time: 08:45:00 - Track: BI Platform Architecture, Development Administration
With Power BI Desktop, we will import data from several sources, then perform some cleanup and transformation of the data. We will build a model from the data and then some visualizations of it. Then we will publish the model to the Power BI Service and build a dashboard from it, then look at how it can be used in collaboration scenarios and distribution in your organization.
Event Date: 02-03-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
These errors in design, oversights and old school, traditional practices can impact the success of your projects, even if you don't use any data lakes.
We'll look at end-to-end processes, data capture issues, impractical designs, balancing performance against data quality. I'll be using examples from my own personal data to show you just how my data has been mistreated in IT systems. Plus we'll talk about your data and your data stories.
We will build a list of good pracitices and tools to use to spare you from a flood of data issues in your organization.
Event Date: 02-03-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
In this session we will walk through the techniques required to detect and repair various forms of Corruption Using a number of example corrupted database we will explore how to determine and fix corruption while avoiding some of the common mistakes. Warning: Hex Editors and DBCC Page dumps will be involved!
Event Date: 02-03-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
We'll look at measures for Time Intelligence, such as Year To Date, Previous Year, Year over Year, Moving Annual Total, Rolling Averages. We'll also look at measures that handle different dimensional granularities, like Forecast/Budget measures. The DAX language is designed to look like Excel functions, so if you don't have any Power BI experience, but you are an Excel wizard, you should be able to follow.
Event Date: 02-03-2019 - Session time: 12:45:00 - Track: Application Database Development
We'll look at the features, why you should consider them, where they work, where they don't, who needs to be involved in using them, and what changes, if any, need to be made to applications or tools that you use with SQL Server.
Event Date: 02-03-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 02-03-2019 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
In this session we will go over use cases for Analysis Services and highlight the differences and strengths of each flavor of SSAS. We will review typical BI architectures and show how adding Analysis Services can turn your report users into happy and self sufficient data analysts. If you have a data warehouse(or even if you don't) and aren't using SSAS, come learn how SSAS will make your users love you.
Event Date: 02-03-2019 - Session time: 14:15:00 - Track: Application Database Development
With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!
In this session we will investigate the setup and use of GitHub and Git for source control. Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!
Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github
Event Date: 02-03-2019 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 02-03-2019 - Session time: 14:15:00 - Track: Cloud Application Development Deployment