| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Adam Maxam | BI Platform Architecture, Development Administration | Introduction to DAX in Power BI |
| 08:30:00 | Slava Murygin | Enterprise Database Administration Deployment | Inside of Indexes |
| 08:30:00 | Matt Cushing | Professional Development | Networking 101: Getting Ready for a SQL Event |
| 08:30:00 | Rick Lowe | Application Database Development | Why should I care about ... the plan cache? |
| 08:30:00 | Jennifer McCown | Application Database Development | Beginning T-SQL |
| 09:50:00 | Paresh Motiwala | Enterprise Database Administration Deployment | How I Cut My Maintenance Window by 80% |
| 09:50:00 | Deborah Melkin | Application Database Development | Beyond the Basic SELECT |
| 09:50:00 | Allen White | Enterprise Database Administration Deployment | Find (So You can Fix) those Troublesome Queries |
| 09:50:00 | Taiob Ali | Enterprise Database Administration Deployment | New features in Management Studio -- Performance Troubleshooting made easier! |
| 09:50:00 | David Benoit | Professional Development | The Future Of The DBA In A Cloud Centric Environment |
| 11:20:00 | Tracey Kroll | Analytics and Visualization | Introduction to Sentiment Analysis with SQL Server |
| 11:20:00 | Rayis Imayev | Application Database Development | Loading your Data Vault with Azure Data Factory Mapping Data Flows |
| 11:20:00 | Tracy Boggiano | Professional Development | More Common Than You Think: Mental Illness in Tech |
| 11:20:00 | Sean McCown | Application Database Development | Monster Text Manipulation: Regular Expressions for the DBA |
| 11:20:00 | Kimberly StJacques | Other | Lightning Talks - AM |
| 13:20:00 | Kris Gruttemeyer | Professional Development | Production down! How to keep calm and query on during an outage. |
| 13:20:00 | Andy Yun | Application Database Development | Let's Dive Into SQL Server I/O To Improve T-SQL Performance |
| 13:20:00 | Eugene Meidinger | BI Platform Architecture, Development Administration | Introduction to M (a.k.a Power Query) |
| 13:20:00 | Elizabeth Noble | Application Database Development | Streamline Database Deployments |
| 14:35:00 | Andy Yun | Application Database Development | How Intelligent Query Processing improves T-SQL performance |
| 14:35:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Intro to Query Store |
| 14:35:00 | Jane Datz | Strategy and Architecture | The Good, the Bad, and the Ugly -- switching from SSIS to Informatica Cloud as an ETL Tool |
| 14:35:00 | Anna Hadnagy | Professional Development | Thanks for the Feedback! |
| 14:35:00 | Deborah Melkin | Other | Lightning Talks - PM |
| 15:50:00 | Ray Kim | Professional Development | Whacha just say? Talking technology to non-technical people |
| 15:50:00 | Allen White | Enterprise Database Administration Deployment | Emergency! Are You Ready for Disaster to Strike? |
| 15:50:00 | Kimberly StJacques | Enterprise Database Administration Deployment | Look Mom… No Hands! Getting Started with Automation |
Event Date: 29-02-2020 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 29-02-2020 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
In that session we will use DBCC IND and DBCC PAGE and dig into pages' binary code to understand how SQL Server uses different kinds of Indexes.
Event Date: 29-02-2020 - Session time: 08:30: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: 29-02-2020 - Session time: 08:30:00 - Track: Application Database Development
Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.
Event Date: 29-02-2020 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 29-02-2020 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment
In addition to Microsoft's own Maintenance Plans and Ola Hallengren's awesome scripts, there are many tweaks available that can be exploited for our success; we will learn about those too. I will share with you my own experiments that I conducted over a period of one month. I will share supporting data, to show how I helped save several hours of downtime for my company. We'll also some of the best practices to help you cut down the maintenance window and give max up-time for your discerning customer.
Event Date: 29-02-2020 - Session time: 09:50:00 - Track: Application Database Development
Event Date: 29-02-2020 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-02-2020 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment
Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?
In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.
Event Date: 29-02-2020 - Session time: 09:50:00 - Track: Professional Development
These questions trouble many, and honestly, they should. If you are passionate about your profession you will want to prepare for change to ensure that your skills grow with the environments and technologies you support.
This presentation will cover the transition that we have made at SP Global and the changes that our team has had to make as we've moved to cloud centric environments and technologies.
This goal of this session is to encourage attendees to become life long learners and to develop a renewed passions to grow with the changes in technology so that they will stay impactful. Attendees will also leave with key areas that they can focus on that will propel them to be cloud ready as quickly as possible.
Event Date: 29-02-2020 - Session time: 11:20:00 - Track: Analytics and Visualization
Sentiment Analysis helps you understand what customers are feeling. Being able to gauge public opinion is the key to understanding how your brand is being perceived in the marketplace. In this talk we will look at how to perform sentiment analysis on some Twitter data using Python in SQL Server and Machine Learning Services. No Data Science or Python experience is necessary to begin leveraging the tools Microsoft has made available to help extract meaning from your data.
Event Date: 29-02-2020 - Session time: 11:20:00 - Track: Application Database Development
There are many different use-case scenarios that can be covered by Data Flows, considering that Data Flows in SQL Integration Service (SSIS) projects are still playing a big role in fulfilling Extracting-Loading-Transforming (ETL) patterns for your data.
In this session, I will share my experience of populating a Data Vault repository with the help of Mapping Data Flows in Azure Data Factory.
Event Date: 29-02-2020 - Session time: 11:20:00 - Track: Professional Development
In this session, we will talk about what mental illness is and what it is not. How my mental illness has affected me. How it effects the tech industry. How mental illness can affect you and how you can tell if you are starting to have issues. What to say and what not to say to people you know that are affected by mental illness. Finally, how to get help and where reach out for help.
Event Date: 29-02-2020 - Session time: 11:20:00 - Track: Application Database Development
Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.
Event Date: 29-02-2020 - Session time: 11:20:00 - Track: Other
Kim StJacques - Introduction to SQL Server 2019 PolyBase Ray Kim - Business cards: the most important networking tool Taiob Ali - Extended Events - How to collect the first 10 or every 4th event
Event Date: 29-02-2020 - Session time: 13:20:00 - Track: Professional Development
It's 3AM, production is down and you're on call. How do you approach an outage?
In this session, we'll cover methodologies for navigating outages, how to stay relaxed and keep a clear head, tips for identifying where things are bottlenecked and best practices for escalation and notification to customers and stakeholders.
This session will arm you with techniques to help you and your team efficiently triage, diagnose and resolve outages with cool and calm confidence.
Event Date: 29-02-2020 - Session time: 13:20:00 - Track: Application Database Development
Join me for a deep dive into the storage engine to understand how SQL Server handles I/O. Concepts will be paired with T-SQL examples to illustrate the practical impacts.
When you leave, you'll be able to optimize your T-SQL reduce I/O and improve performance across the board.
Event Date: 29-02-2020 - Session time: 13:20:00 - Track: BI Platform Architecture, Development Administration
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: 29-02-2020 - Session time: 13:20: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: 29-02-2020 - Session time: 14:35:00 - Track: Application Database Development
Event Date: 29-02-2020 - Session time: 14:35: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 the Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.
Event Date: 29-02-2020 - Session time: 14:35:00 - Track: Strategy and Architecture
The movie “The Good, The Bad, and The Ugly” is used to characterize the successes and failures during conversion of our ETL. The following topics are discussed and awarded either a good, a bad or an ugly grade: User Interface and Off Hour Support Integration with Control-M Upserts, Mappings and Stored Procedure Complications Oracle and SQL Server Back End Data Extracts Change Data Capture Extracts Product360 and onward
Event Date: 29-02-2020 - Session time: 14:35:00 - Track: Professional Development
Feedback is everywhere. Ever heard, "you need to become more well-rounded?" That's feedback. Ever seen your spouse yawn when you tell about your day? Ever been honked at at the green light because you zoned out for a second? You get the idea.
All our lives we want to improve: we actively participate in conferences, we read blogs, we pursue hobbies, we use smart watches to get in shape. We want to be better but we also want to be accepted as who we currently are. And when we receive (often unsolicited) feedback, we feel inadequate. Not good enough. Unlovable. Not worthy. Impostors.
This session won't teach you how to give feedback, because you've already been to several workshops teaching that (as a result of, well, feedback). It'll, instead, help you address your own "not good enough" triggers, initiate difficult conversations, and participate in them with less stress and more success.
Event Date: 29-02-2020 - Session time: 14:35:00 - Track: Other
Deborah Melkin - Inside the UPDATE Matt Cushing - Using PowerBI to keep your sanity Michael Grayson - SQL Server and MongoDB: A side by side “How To"
Event Date: 29-02-2020 - Session time: 15:50:00 - Track: Professional Development
Event Date: 29-02-2020 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
This session will focus on the kinds of situations that can dramatically affect a data center, and how to practice recovery processes to assure business continuity.
Event Date: 29-02-2020 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment