| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Hasan Savran | Analytics and Visualization | How to use GeoSpatial Data in SQL Server |
| 08:30:00 | Adam Saxton | BI Information Delivery | Introduction to Power BI Desktop |
| 08:30:00 | John Sterrett | Cloud Application Development Deployment | Successfully Migrating Existing Databases to Azure SQL Database |
| 08:30:00 | Thomas Norman | Application Database Development | Encrypting Data within Sql Server |
| 08:30:00 | Brent Ozar | Application Database Development | Dynamic SQL: When, Why, and How to Use It |
| 08:30:00 | Mohammad Darab | Professional Development | 3 Keys to Successful Consulting |
| 08:30:00 | Jennifer McCown | Enterprise Database Administration Deployment | Beginning Admin: The Care and Feeding of SQL Server |
| 08:30:00 | Thomas LeBlanc | Application Database Development | Execution Plans for Performance Tuning SQL Server 2017 |
| 08:30:00 | Angela Tidwell | Strategy and Architecture | Data Collection and Usage: Illegal or Unethical? |
| 09:45:00 | Anders Pedersen | Application Database Development | I/O Tuning 101 |
| 09:45:00 | Abdullah Mamun | Enterprise Database Administration Deployment | SQL Server on Azure VM (IaaS) |
| 09:45:00 | Bob Ward | Enterprise Database Administration Deployment | Inside SQL Server 2019 |
| 09:45:00 | Ben Miller | Enterprise Database Administration Deployment | Tips and Tricks for the PowerShell DBA |
| 09:45:00 | Taiyebali Zakir | Enterprise Database Administration Deployment | SQL Replication on Linux |
| 09:45:00 | Andy Yun | Application Database Development | Why Your Data Type Choices Matter |
| 09:45:00 | Paul LaGrone | BI Platform Architecture, Development Administration | SSIS 2017 Scale Out for HA/DR ETL |
| 09:45:00 | Leslie Andrews | BI Platform Architecture, Development Administration | A Perfect Ten: The Data Model |
| 09:45:00 | Julie Smith | Advanced Analysis Techniques | Leveraging Python in SQL Server |
| 09:45:00 | Peter Doyle | Analytics and Visualization | Become a T-SQL Pivoting Ninja in 60 Minutes Or Less |
| 11:00:00 | Jay Falck | Enterprise Database Administration Deployment | Introduction to Linux for SQL Server |
| 11:00:00 | Anna Hoffman | Analytics and Visualization | Microsoft SQL Server Machine Learning Services - a Complete Platform for E2E ML |
| 11:00:00 | Eddy Djaja | Enterprise Database Administration Deployment | What Is Clogging Your Database Performance? |
| 11:00:00 | Ryan Adams | Enterprise Database Administration Deployment | TempDB Inside Out |
| 11:00:00 | Alicia Moniz | Analytics and Visualization | AI Cognitive Services: Vision 101 |
| 11:00:00 | Dave Bland | Enterprise Database Administration Deployment | Extended Events: What are they and How do I use them |
| 11:00:00 | Ganesh Lohani | BI Platform Architecture, Development Administration | Implementing ETL solution for incremental data load |
| 11:00:00 | Chris Hyde | BI Platform Architecture, Development Administration | Python in SQL Server 2017 and 2019 |
| 11:00:00 | Allan Hirt | Enterprise Database Administration Deployment | Modern Infrastructure Fundamentals for SQL Server |
| 13:15:00 | Martin Perez | Application Database Development | T-SQL Tools: Simplicity for Synchronizing Changes |
| 13:15:00 | Matt Gordon | Analytics and Visualization | Feelings Quantified: Scoring and Storing Social Media Sentiment |
| 13:15:00 | Kevin Feasel | Application Database Development | A Map To Success: Functional Programming For Database Developers |
| 13:15:00 | Roberto Cavalcanti | Cloud Application Development Deployment | Azure SQL Managed Instance - Lessons learned from the trenches |
| 13:15:00 | Brent Ozar | Enterprise Database Administration Deployment | What's New in SQL Server 2019: 100% Demos |
| 13:15:00 | Trevor Barkhouse | Enterprise Database Administration Deployment | Backing up to Azure BLOB Storage |
| 13:15:00 | Lance Tidwell | Application Database Development | Introduction to Execution Plans |
| 13:15:00 | Melissa Stein | BI Platform Architecture, Development Administration | The True Story of Learning Biml |
| 13:15:00 | William Assaf | Enterprise Database Administration Deployment | SQL Security Principals and Permissions 101 |
| 13:15:00 | Andy Leonard | Cloud Application Development Deployment | Moving Data with Azure Data Factory |
| 14:30:00 | Buck Woody | Advanced Analysis Techniques | Introduction to SQL Server Big Data Clusters |
| 14:30:00 | Eugene Meidinger | BI Information Delivery | An (Advanced) Introduction to DAX |
| 14:30:00 | Kevin Boles | Application Database Development | Query Plan Deep Dive |
| 14:30:00 | Kathi Kellenberger | Application Database Development | T-SQL Window Function Performance in 2019 |
| 14:30:00 | Anthony Nocentino | Cloud Application Development Deployment | Practical Container Scenarios in Azure |
| 14:30:00 | Mike Burek | Application Database Development | Raspberry Pi and SQL Server |
| 14:30:00 | Christine Assaf | Professional Development | Mastering your Resume Interview: Tips to Get Hired |
| 15:45:00 | Reinaldo Kibel | Strategy and Architecture | Hackers move away, we are Always Encrypted |
| 15:45:00 | Kellyn Pot'Vin-Gorman | Cloud Application Development Deployment | Be Part of the Solution with Automation |
| 15:45:00 | Kenneth Fisher | Application Database Development | SQL Server Security from the ground up |
| 15:45:00 | Mark Moore | Enterprise Database Administration Deployment | SQL in Azure 101 |
| 15:45:00 | Mike Byrd | Application Database Development | Indexing Like a Rocket Scientist |
| 15:45:00 | Sean McCown | Enterprise Database Administration Deployment | Beginning Powershell for DBAs 1.0 |
| 15:45:00 | Mike Diehl | BI Platform Architecture, Development Administration | Building measures in Power BI (and SQL Server Analysis Services tabular models) |
| 15:45:00 | Paul Bell | Strategy and Architecture | Where should I store my database? |
| 15:45:00 | Joshua Higginbotham | Application Database Development | Introduction to GitHub |
| 15:45:00 | Kalen Delaney | Enterprise Database Administration Deployment | Are You Optimistic About Concurrency? |
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Analytics and Visualization
I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: BI Information Delivery
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Application Database Development
In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. The session will deep dive into setting up Always Encrypted encryption and share my experiences implementing the encryption. In addition, the session will review auditing of sensitive data usage.
You will leave the session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. In addition, you will gather information on how to fully protect and review your sensitive data usage.
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Application Database Development
So how do we make those go fast? And how can we get 'em to use indexes?
In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You'll learn how to write dynamic SQL that's easy to tune, manage, and troubleshoot.
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Professional Development
The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.
In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.
Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Being a database administrator is a big job, but we can cover the basics in one session!
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Application Database Development
There are many paths to reading these plans that need to be discussed and probably you will hear 'it depends' in this session. Explanations of why it depends will be used with examples.
Event Date: 01-06-2019 - Session time: 08:30:00 - Track: Strategy and Architecture
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Application Database Development
In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.
First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.
The second part will focus on how to reduce I/O requests.
All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Application Database Development
Attend this session to learn how database records are stored within SQL Server and why all data types are not created equal. Armed with that knowledge, we will explore several performance scenarios that may be impacting your systems right now! When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Advanced Analysis Techniques
Event Date: 01-06-2019 - Session time: 09:45:00 - Track: Analytics and Visualization
Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight with ease. In this demo-heavy presentation, you will learn how to build pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.
Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization
Join us for an introduction to the Cognitive Services Computer Vision and Custom Vision APIs on Azure.
In this session, we will look at the basics of Cognitive Services Vision. First learn how to create your Cognitive Services model. Then you can see how to train and improve accuracy. Finally, we will step through python code in Azure Notebooks to call the APIs.
After this session, you will get up and running in Cognitive Services Vision in under an hour!
Prerequisites: Attendees who would like to follow along should have an Azure account, as well as an account on Azure Notebooks. Experience with coding in python is helpful, but not required.
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Event Date: 01-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
This session will update the core infrastructure concepts anyone responsible for SQL Server should know whether you have physical, virtualized, public cloud, and container-based deployments. As a bonus, you will be able to work better with the other administrators back in the office now that you can speak their language.
If you want to ensure that your SQL Server deployments are available, reliable, and perform well, this is the session for you.
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Application Database Development
In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your ETL workflows:
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Analytics and Visualization
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Application Database Development
In this talk, we will focus on one functional programming language, F#. We will look at some of the basics of the language and see how you can translate knowledge of SQL into a pipeline-driven functional programming language. We will also see areas where F# integrates smoothly with SQL, creating a powerful way to extend your SQL skills beyond queries.
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Cloud Application Development Deployment
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
I'm Brent Ozar, and I'll give you the whirlwind tour. I'll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I'll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.
No slides here - not even an about-me slide. Let's dive into some queries!
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Application Database Development
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration
In this session you will learn: Why Biml is worth your time and effort. How to identify ideal SSIS packages for conversion. How to convert those packages into Biml. How to troubleshoot your Biml build errors when Google fails you. How to automate SSIS package creation with BimlScript.
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 13:15:00 - Track: Cloud Application Development Deployment
Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
You’ll also learn common use case scenarios that leverage big data and the SQL server 2019 Big Data Cluster on-premises, in the cloud, and in a hybrid architecture.
Learning Objectives:
Event Date: 01-06-2019 - Session time: 14:30:00 - Track: BI Information Delivery
Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
Key topics introduced Publishing containers to Azure Container Registry Deploying Azure Kubernetes Services Clusters Scaling our container-based applications in Azure Kubernetes Services
Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Application Database Development
Come see some examples of how to connect SQL Server with the Raspberry Pi. We can make a noise when a job is done running. We can show a gauge of the system activity. We can even push a button to start T-SQL code running.
Event Date: 01-06-2019 - Session time: 14:30:00 - Track: Professional Development
Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Strategy and Architecture
Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Cloud Application Development Deployment
Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
This is an introductory session. At the end of this session you will have a good understanding of what SQL options are available in Azure and how to create and manage each one.
Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Application Database Development
performance. As a SQL Developer, do you understand the difference between a clustered and non-clustered index or what a covering index is? What is different between OLTP and data warehouse databases when it comes to indexing? This session is a deep dive into Clustered indexes Non-clustered indexes B-Tree traversal Primary Keys Covering indexes
This session will feature live query demos illustrating index utilization and performance using statistics and query plans. Understand indexing like a rocket scientist by attending this session!
Some knowledge of T-SQL and Management Studio is recommended.
Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 15:45: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: 01-06-2019 - Session time: 15:45:00 - Track: Strategy and Architecture
Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 01-06-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new technology added in SQL Server 2014 that allows the enormous benefits of having totally in-memory storage with no waiting!