| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:00:00 | Ravi Kumar | BI Information Delivery | Power BI In a day Hands-On |
| 08:00:00 | Erik Darling | Analytics and Visualization | Total Server Performance Tuning |
| 08:00:00 | Jason Horner | BI Platform Architecture, Development Administration | Azure Data Factory Deep Dive |
| 08:20:00 | Thomas Grohser | Other | "Schadenfreude" - Let's enjoy the mistakes other people made... |
| 08:20:00 | Matt Cushing | Professional Development | Networking 101: Getting Ready for a SQL Event |
| 08:20:00 | Kevin Feasel | Application Database Development | Data Virtualization with PolyBase |
| 08:20:00 | Paresh Motiwala | Enterprise Database Administration Deployment | Moving to SQL 2019- A primer for the unaware! |
| 08:20:00 | Angela Henry | Application Database Development | Profiling Your Data |
| 08:20:00 | Kavitha Saravanan | Cloud Application Development Deployment | Azure SQL Managed Instance - Technical Overview, Deployment, Best Practices and Monitoring |
| 09:45:00 | Mohammad Darab | Enterprise Database Administration Deployment | Big Data Clusters for the Absolute Beginner |
| 09:45:00 | Kevin Boles | Application Database Development | Common TSQL Mistakes |
| 09:45:00 | Jason Horner | BI Platform Architecture, Development Administration | Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2 |
| 09:45:00 | Andy Mallon | Enterprise Database Administration Deployment | When to use Indexing Pro Features |
| 09:45:00 | Leonard Lobel | Application Database Development | Docker for the SQL Server Developer |
| 09:45:00 | Kat Edrington | Enterprise Database Administration Deployment | Recognizing Tempdb Performance Bottlenecks |
| 11:10:00 | Priscilla Camp | BI Information Delivery | How UCF IT uses Power BI to monitor our IT Services |
| 11:10:00 | Slava Murygin | Enterprise Database Administration Deployment | SQL Server on your fingertips |
| 11:10:00 | Jeremy Frye | BI Platform Architecture, Development Administration | PowerApps and AI: A Flow of Location Events |
| 11:10:00 | Andy Yun | Application Database Development | A Beginner's Guide to Seven Practices that Kill Performance |
| 11:10:00 | Eugene Meidinger | BI Information Delivery | Introduction to M (a.k.a Power Query) |
| 11:10:00 | Elizabeth Noble | Application Database Development | Streamline Database Deployments |
| 12:45:00 | Diane Schuster | BI Platform Architecture, Development Administration | CozyRoc: Dynamic Data Flows in SSIS Without Programming |
| 13:40:00 | Sarah Patrick | Application Database Development | Case Study: How I used SharePoint, Flow, PowerApps, and Forms to build a Speaker Database |
| 13:40:00 | Ganesh Lohani | Professional Development | Building your Microsoft Business Intelligence (MSBI) Career |
| 13:40:00 | Jamie Wick | Cloud Application Development Deployment | Integrating On-Premises Data with Azure-based Applications |
| 13:40:00 | Forrest McDaniel | Application Database Development | Query Plans For Visual Learners |
| 13:40:00 | Grant Fritchey | Strategy and Architecture | 10 Steps Towards Global Data Compliance |
| 13:40:00 | Sebastian Meine | Enterprise Database Administration Deployment | Performance Troubleshooting for the Accidental DBA |
| 15:05:00 | Ravi Kumar | BI Platform Architecture, Development Administration | Power BI and Analysis Services Tabular: How they work together a |
| 15:05:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Intro to Query Store |
| 15:05:00 | Erik Darling | Application Database Development | The SQL Server Performance Tasting Menu |
| 15:05:00 | Jonathan Stewart | Analytics and Visualization | Two Truths That's A Lie: Data Visualization Ethics |
| 15:05:00 | Warren Sifre | Strategy and Architecture | Introduction To Data Governance |
| 15:05:00 | Sarah Whitworth | BI Information Delivery | Speak Easy Snowflake |
Event Date: 14-12-2019 - Session time: 08:00:00 - Track: BI Information Delivery
Power BI Desktop: What is Power BI and what it is not Introduction Connecting to the data Shaping data at query time Modeling Data Dax Calculations Building Reports
Power BI Service: What is Power BI Service Publishing Power BI Desktop file to the Service (Instructor will provide logins to a test Power BI Service tenant) Get the online data Sharing reports and desktops Refreshing the data Mobile Reports
Power BI On Premises Server: How is Power BI On Premises server different from Power BI Service When should you use Power BI Server
SSAS Tabular: What it is and how it integrates with Power BI
Pre-requisite: Power BI Installed
Event Date: 14-12-2019 - Session time: 08:00:00 - Track: Analytics and Visualization
Event Date: 14-12-2019 - Session time: 08:00:00 - Track: BI Platform Architecture, Development Administration
We will start with a conceptual overview, and then explore using metadata to build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. We will look at how to leverage SSIS Lift and shift to maximize reuse for your existing code base and review the pros and cons of this approach. We will dive deep and cover the design patterns and architectures for modern data warehouses and big data pipelines. We will also review best practices for operationalizing solutions including configuring monitoring, logging and alerting and implementing DevOps and CI/CD. This day is everything you need to do amazing things with Azure Data Factory.
Event Date: 14-12-2019 - Session time: 08:20:00 - Track: Other
And yes you are welcome to have a laugh at the misfortune of other people (or as the german speaking population would call it: Let's have some "Schadenfreude"! After a log day, come in and have some fun before the evening event starts
Event Date: 14-12-2019 - Session time: 08:20:00 - Track: Professional Development
In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.
Event Date: 14-12-2019 - Session time: 08:20:00 - Track: Application Database Development
Event Date: 14-12-2019 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-12-2019 - Session time: 08:20:00 - Track: Application Database Development
Event Date: 14-12-2019 - Session time: 08:20:00 - Track: Cloud Application Development Deployment
Event Date: 14-12-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.
Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts
Event Date: 14-12-2019 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 14-12-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
Event Date: 14-12-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Over the years, Microsoft has given us many different indexing options and flavors. Today there are many more considerations beyond "clustered or non clustered". We'll cover all those different flavor options: Filtered, Compressed, Columnstore, included columns, and Partitioning.
We won't only talk about what these options are, we'll also cover how and when to use these different indexing options, and how to make sure you have enough--but not too many--indexes for your workload.
Event Date: 14-12-2019 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 14-12-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-12-2019 - Session time: 11:10:00 - Track: BI Information Delivery
Event Date: 14-12-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
In the first hour we'll go through the most common SSMS keyboard shortcuts and I'll show you how to setup your own shortcuts with your own queries. In the second hour I'll show you how to set the best SQL queries developed by the best brains in the industry in your own SSMS and apply it to your environment.
Event Date: 14-12-2019 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration
In this session, we will create an application using PowerApps and location services to track latitude and longitude coordinates on Bing maps. Attendees will learn how to configure and demonstrate it on a mobile device. I will also show two approaches using AI within the application by using Azure SQL Database, Cognitive Services and Flow. An end-user will be able to leverage Bing Search for location-aware web searches, while an administrator will be able to leverage the Azure SQL Database and Flow to send alerts based on predefined metrics.
Event Date: 14-12-2019 - Session time: 11:10:00 - Track: Application Database Development
Then join me for a survey of seven worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.
When you leave, you'll be armed with knowledge and tools to tackle your current workloads and hit the ground running.
Event Date: 14-12-2019 - Session time: 11:10:00 - Track: BI Information Delivery
In this session, we'll demonstrate how M is a linear series of transformations, just like a set of steps from a recipe. We'll show how 80% of what you will ever need to do can be done from the GUI. We'll also talk about how to write custom code for that other 20%. By the end of this presentation, you'll be able to take any manual cleanup you do today and turn it into a repeatable process with M.
Event Date: 14-12-2019 - Session time: 11:10:00 - Track: Application Database Development
This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging.
At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.
Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.
Event Date: 14-12-2019 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-12-2019 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 14-12-2019 - Session time: 13:40:00 - Track: Professional Development
Event Date: 14-12-2019 - Session time: 13:40:00 - Track: Cloud Application Development Deployment
In this session, we will look at using an Azure On-Premises Data Gateway to integrate local (on-prem) data sources with Azure-based applications.
Event Date: 14-12-2019 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 14-12-2019 - Session time: 13:40:00 - Track: Strategy and Architecture
However, it is possible to define a core set of processes that will help to enable your ability to assist your business, or government agency, in meeting these compliance requirements. This session will walk you through the 10 steps you need to implement in order to move your organization towards full compliance with any, or all, of the regulations we all now face. From identifying where your data lives to monitoring for compliance and all the steps in between, you can meet this challenge.
Event Date: 14-12-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Do you have to deal with frequent performance problems like the app throwing timeouts at the users or the daily reports closing in on 24 hours runtime?
Does it seem, constant blocking or frequent deadlocks are now a common part of your daily agenda? So, how do you even know where to start? Do you “add more indexes”, “increase memory”, “buy a new SAN”, “update statistics”, “move to the cloud”, or something else entirely?
The good news: SQL Server provides the tools you need to clear the fog and identify exactly what the problem is.
In this session, we’ll take a look at the query store, wait stats, live execution plans and more. After attending you’ll have the tools you need to be able to quickly identify the exact culprit in any low-performance situation.
And, next time your boss breathes down your neck, you might even be able to point out that SQL Server is not the problem.
Event Date: 14-12-2019 - Session time: 15:05:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-12-2019 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment
Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.
In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.
Event Date: 14-12-2019 - Session time: 15:05:00 - Track: Application Database Development
You know there are different ways to make queries faster, but you’re not sure when to use them.
I’m Erik Darling, and I’ll be your sommelier for the evening.
Over several courses of delicious demos, I’ll show you the types of performance problems different tuning techniques pair well with, and which ones to avoid.
When we’re done, you’ll understand exactly what patterns to look for when you’re troubleshooting slow queries, and how to approach them.
You’ll have the secret recipe for gourmet queries.
Event Date: 14-12-2019 - Session time: 15:05:00 - Track: Analytics and Visualization
In this session, we will discuss how everything from color to chart can be used to change the meaning of visualization. We will cover the things that influence and manipulate. Finally, we will put it all together, creating two opposing stories using the same data-set.
Event Date: 14-12-2019 - Session time: 15:05:00 - Track: Strategy and Architecture
Event Date: 14-12-2019 - Session time: 15:05:00 - Track: BI Information Delivery