| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Anthony Nocentino | Application Database Development | Kubernetes Zero to Hero - Installation, Configuration, and Applic |
| 09:00:00 | Kendra Little | Enterprise Database Administration Deployment | How to Architect Successful Database Changes: Source Control and |
| 09:00:00 | Ginger Grant | Analytics and Visualization | Getting Started with Data Science and Databricks |
| 09:00:00 | Ganesh Lohani | Analytics and Visualization | Data Science 101: An Introduction to Data Science Using Python |
| 09:00:00 | Kellyn Pot'Vin-Gorman | Enterprise Database Administration Deployment | Empowering the SQL Server Professional with Linux Scripting- 60 min. |
| 09:00:00 | Steve Wake | BI Information Delivery | Power BI Premium: Is it for Your Company (and Worth It)? |
| 09:00:00 | Paul Paiva | Professional Development | Consulting/contracting - is it right for me? |
| 09:00:00 | Eric Peterson | Strategy and Architecture | SQL and MongoDB: When Two Worlds Collide |
| 09:00:00 | Gabriel Villa | Analytics and Visualization | Analytics on AWS |
| 09:00:00 | Jason Brimhall | Advanced Analysis Techniques | Anatomy of Select |
| 09:00:00 | Marc Beacom | BI Platform Architecture, Development Administration | ETL Best Practices and Techniques |
| 10:15:00 | Carlos Robles | Cloud Application Development Deployment | Working with SQL Server containers to build database solutions |
| 10:15:00 | Glenn Berry | Enterprise Database Administration Deployment | Dr. DMV's Troubleshooting Toolkit |
| 10:15:00 | Ted Stathakis | BI Platform Architecture, Development Administration | Reporting Services: A Smart Migration Strategy |
| 10:15:00 | Yuliya Quintela | Cloud Application Development Deployment | Building Big Data Analytics solutions with Azure Databricks |
| 10:15:00 | Kendra Little | Enterprise Database Administration Deployment | An Introduction to Versioning and Branching Database Code in Git |
| 10:15:00 | Phillip Labry | Application Database Development | Assimilating Microsoft Access -- Upsizing to SQL Server |
| 10:15:00 | Richard Waymire | Cloud Application Development Deployment | Running SQL Server on AWS |
| 10:15:00 | Ginger Grant | Advanced Analysis Techniques | Revealing the Differences in Azure Machine Learning Products |
| 12:45:00 | Mark Moore | Information Delivery | Demystifying SQL in Azure |
| 12:45:00 | Kara Annanie | Analytics and Visualization | Machine Learning in Azure Databricks |
| 12:45:00 | Steve Jones | Application Database Development | The Future of Database Development with Containers |
| 12:45:00 | Meagan Longoria | BI Platform Architecture, Development Administration | Moving and Transforming Your Data with Azure Data Factory V2 |
| 12:45:00 | Manguirish Sardessai | Cloud Application Development Deployment | SQL Server Migration to the AWS: Approach and Methodology |
| 12:45:00 | Scot Reagin | BI Platform Architecture, Development Administration | Azure Analysis Services – Multidimensional solutions in the cloud |
| 12:45:00 | TJay Belt | Enterprise Database Administration Deployment | Power BI, from a DBA's Perspective |
| 12:45:00 | Todd Kleinhans | Enterprise Database Administration Deployment | Storing Images in a Database - Tips and Techniques |
| 14:00:00 | Aaron Cutshall | Application Database Development | Tally Ho! -- Explore the Varied Uses of Tally Tables |
| 14:00:00 | Steve Wake | BI Information Delivery | Data Modeling and Prototyping in Power BI Desktop |
| 14:00:00 | Glenn Berry | Enterprise Database Administration Deployment | High Availability/Disaster Recovery 101 |
| 14:00:00 | Susantha Bathige | Cloud Application Development Deployment | SQL Server on Kubernetes |
| 14:00:00 | Marc Beacom | Analytics and Visualization | Translating your Excel Skills to Power BI |
| 14:00:00 | Leslie Weed | BI Platform Architecture, Development Administration | Innovative Data Modeling: Make Data Warehousing Cool Again Part 1 |
| 14:00:00 | Carlos Bossy | Information Delivery | Operationalize Data Science for Advanced Decision Support |
| 14:00:00 | Angela Tidwell | Enterprise Database Administration Deployment | Data Collection and Usage: Illegal or Unethical? |
| 14:00:00 | Rick Lowe | Application Database Development | Weird Stuff I Saw While … Supporting a Java Team |
| 15:15:00 | John Byrnes | Analytics and Visualization | Predicting the NFL with SQL Server 2017 ML Services |
| 15:15:00 | Christopher Wolff | Enterprise Database Administration Deployment | SQL Servers on Containers |
| 15:15:00 | Amie Mason | Strategy and Architecture | Preparing your Business for Data Science |
| 15:15:00 | Jeff Renz | BI Platform Architecture, Development Administration | Innovative Data Modeling: Make Data Warehousing Cool Again Part 2 |
| 15:15:00 | Daniel Janik | Enterprise Database Administration Deployment | Migrating your SQL Server to the cloud: Tips and Best Practices |
| 15:15:00 | Anthony Nocentino | Application Database Development | Practical Container Scenarios in Azure |
| 15:15:00 | Jason Horner | Cloud Application Development Deployment | Azure Analytics Platform Quickstart |
| 15:15:00 | Kellyn Pot'Vin-Gorman | Advanced Analysis Techniques | DevOps or Decoys |
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Application Database Development
Session Objectives • Introduce Kubernetes Cluster Components • Introduce Kubernetes API Objects and Controllers • Installing Kubernetes • Interacting with your cluster • Storing persistent data in Kubernetes • Deploying Applications in Kubernetes
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
In this session, you will learn how to choose between state and migrations-based approaches to database code management in source control on a per-project basis, and what this choice means for your release practices. You’ll learn what release automation means for ‘rollbacks’ with database code and get to join the debate on the pros and cons of different approaches to handling post-release disasters in production. We’ll discuss release patterns and how to measure success, including the blue/green deployment model when applied to databases, the expand/contract pattern, feature flags, and special cases for releases including repli
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Analytics and Visualization
Today, more and more development is performed on very large datasets. Attendees will learn how to use Apache Spark, which is part of Databricks, to rapidly analyze lots of data. Learn how to use Databricks to reduces operational complexity to create solutions which can be scaled up or down depending on the amount of data needed to process without having to change the underlying code. Python, Jupyter Notebooks, and Apache Spark are the technologies used to create solutions within this session. No experience is required. Agenda
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Analytics and Visualization
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
This session is the second session in the Linux for SQL Server Professionals Learning Pathway. For more information please visit our Learning Pathways page.
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: BI Information Delivery
In this session, we will go over all of the current features offered with Power BI Premium and the features that we know are coming in the future, so that you can help make that decision for your company. With multiple demos in this session, you can see these features for yourself to help determine the worth. Come to this session if your company has been thinking about Power BI Premium, but you have been unable to determine if it is right for your company. At the end of this session, you will be armed with all of the knowledge you will need to make the right decision.
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Professional Development
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Strategy and Architecture
After a quick overview of the SQL and NoSQL differences, we'll look at some scenarios where it makes sense to set up a hybrid environment to take advantage of the strengths of each database. Then we'll look specifically at accessing MongoDB from SQL Server.
Microsoft offers native integration with MongoDB in SQL 2019. We'll look at the mechanics of how to leverage that integration to archive data, feed a web farm, and provide more data to BI reporting.
We'll dig into querying normalized SQL and denormalized document db data structures simultaneously, and what that means for both data consistency and performance. Of course, this discussion wouldn't be complete without also knowing how to write to the document world from the relational world, so we'll cover that as well.
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Analytics and Visualization
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Advanced Analysis Techniques
When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.
This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.
Event Date: 12-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Gian helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.
Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
Spending long periods of time installing, configuring and preparing databases and SQL Server instances is no longer the case with containers.
In this session you will learn the basic and advanced methods to deploy a SQL Server solution using containers in minutes.
We will explore the options and tools (open source) we have available when working with SQL Server running on Docker containers through real world scenarios, like backing up \ restoring databases, high availability, version upgrades and the most important portability between cross platforms.
Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases in order to avoid performance and scalability issues.
Event Date: 12-10-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
This session will show how to use the data in the ReportServer database to determine a smart migration strategy for upgrading to a new SSRS or Power BI Report Server. Starting with the new features of Report Manager, Mobile Reports, KPIs, and the Mobile Report Publisher app. The session will then focus on how to utilize the report meta data in the ReportServer database, combined with the transaction log table, to show how to determine which reports, data sets, and data sources are being used and determine what objects to migrate.
Learn how to use PowerShell to extract the reports and data sets from the database, instead of downloading them, to facilitate an easy migration to a new implementation. Also, discover a way of determining all TSQL used by the reports. This session is particularly useful for migrating from 2008, but applicable to any migra
Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
Come and learn about Azure Databricks. This service combines power of Apache Spark large scale workloads with fully managed Azure cloud services to build data engineering pipelines, interactively run analytical tasks and implement machine learning algorithms. But what really sets it apart from other cloud analytical services, is that it is a truly collaborative environment that allows you to take advantage of diverse skills in your organization and let everyone work with data. By the end of this session you will know how to easily connect to various data sources in data lake, quickly spin up Spark clusters, use notebooks to share your code and mix languages like SQL, R, Python, and build visualizations to drive business insights.
Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Advanced Analysis Techniques
use to create or deploy a solution and they are all called Azure Machine Learning[ AML]. Understanding the differences between the products provides the information needed to be able to architect the appropriate solution in your environment. The session demos show how to create an end-to-end AML workflow to prepare data, create ML models, deploy models, and use data contained within SQL Server by integrating a number of tools including Databricks, Python and Jupyter notebooks. Learn why you want to use AML Workspace for ML development collaboration, scaling, and management. Understand how to monitor ML models in production with AML Pipeline to organize releases and generate execution metrics. Key Takeaways Understand how to use AML products to work in collaborative environments, use ML created from a number of different tools and languages, implement version controls, and moni
Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Information Delivery
In this session I will cover all of the SQL options you have available, the pros and cons of each and how to create and use each of these options.
Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Analytics and Visualization
Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Application Database Development
Event Date: 12-10-2019 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Cloud Application Development Deployment
Planning plays a critical role in moving to the cloud. Preparing a check-list and asking the right questions to stakeholders lays the groundwork in this planning. There are different methods to migrate databases from on-premises to the AWS cloud. In this presentation, we will discuss various methods and explain the advantages and disadvantages of using each method. We’ll also showcase the surprises and pitfalls to avoid as we venture into the process. Learn more on what trends you can expect to see, what the future holds for public clouds.
Event Date: 12-10-2019 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Azure Analysis Services (AAS) is a good example of this reality – it works very well for many applications but is limited to Tabular Models and cost can explode if those models are not created thoughtfully. And, what is the path to Azure for my multidimensional cubes? Do I care about Azure Analysis Services if I use Power BI? As always the answer to these questions is a clear and absolute ‘it depends’.
In this session we’ll explore Azure Analysis Services functionality, fit in various solutions, and gaps and techniques that are important to consider when implementing AAS.
Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point Power BI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, Power BI, and how to make these work for you.
Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: BI Information Delivery
In this session, we will go through multiple examples showing how Power BI Desktop is the perfect tool to quickly model data from multiple data sources (including web sites, databases, cubes, online services, and even flat files), and perform quick actions to cleanse and connect these various sources to each other using M and DAX functions built-in to Power BI Desktop. Once this model has been built, it can be used to create some quick reports to show how this will be used to help get a project approved/funded. Best of all, using Power BI Desktop to do all of this is completely free, no licensing or Power BI login required!
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Cloud Application Development Deployment
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Analytics and Visualization
Power BI is a business intelligence tool developed by Microsoft designed for business users who are already familiar with Excel. It’s specifically designed to create interactive dashboards and reports using data from a variety of sources to be published and shared across organizations.
Benefits of Power BI over Excel: • Easily share visualizations with your department and/or organization • Mobile friendly visualizations • Improved visualizations • Accelerated development cycle with monthly updates • Combine and work with data in multiple sources or workbooks
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Information Delivery
Using data engineering principles and the latest tools released by Microsoft in Azure Machine Learning service to create a data science framework, you’ll see how to develop predictive models through the entire life cycle and incorporate them into your applications in a way that impacts the decision-making ability of everyone in your organization.
Through a case study, you’ll learn how to choose a meaningful project with a high likelihood for success, including setting a prediction target and how to use data appropriately and adapt it to the model for maximum results. Best practices will be presented for developing, monitoring, and maintaining predictive models. Integrating predictive models into your architecture will allow you to take a step toward making predictive analytics pervasive in your organization.
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Analytics and Visualization
Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Strategy and Architecture
Event Date: 12-10-2019 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Application Database Development
Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Advanced Analysis Techniques