| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Melissa Coates | BI Platform Architecture, Development Administration | Architecting a Data Lake (Paid Pre-con) |
| 09:00:00 | Ed Leighton-Dick | Strategy and Architecture | Securing the Data Platform: Crafting a Strategy That Works (Paid Pre-con) |
| 08:20:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Monitoring Availability Groups |
| 08:20:00 | Stephen Muliokela | Enterprise Database Administration Deployment | Database Corruption |
| 08:20:00 | Kevin Feasel | Analytics and Visualization | Data Cleansing With SQL And R |
| 08:20:00 | Rie Irish | Professional Development | Let Her Finish: Supporting Women's Voices in Technology |
| 08:20:00 | Mindy Curnutt | Application Database Development | Reading Between the Lines - Using XEvents to Diagnose Application Issues |
| 08:20:00 | Justin Dearing | Application Database Development | Version control with GIT for the DBA |
| 08:20:00 | Jim Donahoe | Enterprise Database Administration Deployment | Getting started with SQL Azure Database: What you need to know |
| 08:20:00 | Ivan Carter | Professional Development | The 7 Secrets to Creating a Brand that Clients Love |
| 09:45:00 | Chris Hyde | Analytics and Visualization | SQL Server R Services in SQL 2016 |
| 09:45:00 | Greg Moore | Professional Development | Who's flying the plane? What IT can learn from plane crashes |
| 09:45:00 | Brian Carrig | Enterprise Database Administration Deployment | Controlling Competing Workloads with SQL Server Resource Governor |
| 09:45:00 | Azhagappan Arunachalam | Application Database Development | SQL Graph |
| 09:45:00 | Melissa Coates | BI Platform Architecture, Development Administration | Azure Data Lake: What, Why, and How |
| 09:45:00 | Andrew Kelly | Enterprise Database Administration Deployment | Getting the Most Out of Plan Reuse |
| 09:45:00 | Rick Lowe | Application Database Development | Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints. |
| 09:45:00 | Jason Brimhall | Enterprise Database Administration Deployment | A Masters Passport to Extended Events |
| 11:10:00 | Slava Murygin | Enterprise Database Administration Deployment | SQL Server on Linux for SQL DBA. |
| 11:10:00 | Sebastian Meine | Application Database Development | Introduction to Unit-Testing in SQL Server |
| 11:10:00 | Rick Heiges | Enterprise Database Administration Deployment | Winning with Columnstore - A Customer Story |
| 11:10:00 | Amy Herold | Enterprise Database Administration Deployment | Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks |
| 11:10:00 | Wayne Sheffield | Enterprise Database Administration Deployment | SSMS Tips and Tricks |
| 11:10:00 | Ravi Kumar | BI Information Delivery | SSAS Cube Security: who can see what? |
| 11:10:00 | Lisa Margerum | Professional Development | Network your Way to Success! |
| 11:10:00 | Edward Corcoran | Application Database Development | Intro to Service Broker |
| 13:40:00 | Greg Moore | Professional Development | Presently Presenting.... Presenting |
| 13:40:00 | Jamie Wick | Enterprise Database Administration Deployment | Automated SQL Server installation and configuration using PowerShell |
| 13:40:00 | Jonathan Stewart | Analytics and Visualization | From problem to Power BI: A journey in data visualization |
| 13:40:00 | Mindy Curnutt | Enterprise Database Administration Deployment | Help! I Need Somebody. Help!: Resources for the New or Accidental DBA |
| 13:40:00 | Rick Lowe | Application Database Development | Weird Stuff I Saw While ... Working With Heaps |
| 13:40:00 | Jason Brimhall | Enterprise Database Administration Deployment | Extended Events - Better than Profiler |
| 13:40:00 | Mike Walsh | Cloud Application Development Deployment | Azure SQL Databases: A Guided Tour |
| 13:40:00 | John Morehouse | Application Database Development | Database Continuous Delivery Your Salvation! |
| 15:05:00 | Azhagappan Arunachalam | Analytics and Visualization | SQL Server - R Services |
| 15:05:00 | Ed Leighton-Dick | Enterprise Database Administration Deployment | Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace) |
| 15:05:00 | Andy Mallon | Professional Development | Interview with Rie Irish: Inside the Management Studio |
| 15:05:00 | Carlos L Chacon | Enterprise Database Administration Deployment | How can containers for my database help me? |
| 15:05:00 | Jim Donahoe | Enterprise Database Administration Deployment | New Instance, Now what? |
| 15:05:00 | Amy Herold | Enterprise Database Administration Deployment | Beginning Automation with Powershell |
| 15:05:00 | Ravi Kumar | Analytics and Visualization | Power BI Security |
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-12-2017 - Session time: 09:00:00 - Track: Strategy and Architecture
In this full-day course, we will take a tour of security for the Microsoft data platform, particularly SQL Server. The complex security needs of SQL Server itself will be presented as a series of layers to give participants a framework for planning and implementation. By the end of the day, participants will gain familiarity with tools and techniques they can use to protect their systems from common threats.
Event Date: 09-12-2017 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.
Event Date: 09-12-2017 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues. Highlight of topics
Event Date: 09-12-2017 - Session time: 08:20:00 - Track: Analytics and Visualization
Event Date: 09-12-2017 - Session time: 08:20:00 - Track: Professional Development
This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.
Event Date: 09-12-2017 - Session time: 08:20:00 - Track: Application Database Development
We will cover using XEvents to do the following:
Each approach will detail the following:
Creating an Extended Events Session to capture the information you need for each scenario. How to analyze and make sense of the captured data. Lots of demos and take-away scripts!
Event Date: 09-12-2017 - Session time: 08:20:00 - Track: Application Database Development
What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.
In my session. We'll cover:
What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?
We will be covering using git from both the command line and Visual Studio.
Event Date: 09-12-2017 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Event Date: 09-12-2017 - Session time: 08:20:00 - Track: Professional Development
Branding expert Ivan Carter wants to empower you with simple to use concepts that can propel you forward, increase your value and build strong loyalty among the customers you want to reach and work with. By understanding the 7 easy concepts you can create a brand the not only your future clients will love, but will make you feel more confident as well.
Event Date: 09-12-2017 - Session time: 09:45:00 - Track: Analytics and Visualization
Event Date: 09-12-2017 - Session time: 09:45:00 - Track: Professional Development
Every company will eventually have a disaster. It's just a matter of size and scope. This talk is a general overview of how to respond to an incident and talks about the roles of management and IT.
This is not your typical discussion of disasters focusing on how to make a backup plan or enable high availability.
I'll touch upon what we can learn from plane crashes and how those lessons can be applied to the IT environment in general.
Event Date: 09-12-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 09-12-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-12-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 09-12-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.
This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.
You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage
Event Date: 09-12-2017 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it's flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.
Event Date: 09-12-2017 - Session time: 11:10:00 - Track: Application Database Development
In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.
You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Event Date: 09-12-2017 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 11:10:00 - Track: BI Information Delivery
Event Date: 09-12-2017 - Session time: 11:10:00 - Track: Professional Development
Whether or not you’ve been in your role for a few months, years, or even decades – or you’re looking for a new job and new opportunities -- strategic networking is the way to make yourself more relevant, more attractive for projects and promotion – or more hirable by potential customers.
Join us for an interactive session to strategize the best actions to increase your social capital and network your way to success!
Event Date: 09-12-2017 - Session time: 11:10:00 - Track: Application Database Development
Event Date: 09-12-2017 - Session time: 13:40:00 - Track: Professional Development
This talk will guide you through the process of selecting a topic, preparing for it and actually giving it.
We'll talk about what can go wrong and how to handle that. We'll also talk about what can be done to prevent something from going wrong in the first place.
What are some good guidelines to follow and when can, or even should, you break them.
This will be partly interactive so come with questions and be prepared to be asked some.
Event Date: 09-12-2017 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 13:40:00 - Track: Analytics and Visualization
Event Date: 09-12-2017 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 09-12-2017 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 13:40:00 - Track: Cloud Application Development Deployment
The goal is to take the mystery out, to show the capabilities and get you thinking about what going to the cloud could look like and what it can do for you and your company. I believe the future belongs to those who have this knowledge and know where to apply it.
This will be nearly PowerPoint free and we’ll log into my Azure Portal and build out an environment from scratch and learn as we go. We’ll migrate data from an “on-premises” database into our SQL DB and we’ll query it. You’ll leave with an understanding of the capabilities, some resource links outlining what we did and hopefully some curiosity to see what else is up there in the cloud as you start exploring.
Event Date: 09-12-2017 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 09-12-2017 - Session time: 15:05:00 - Track: Analytics and Visualization
Event Date: 09-12-2017 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 15:05:00 - Track: Professional Development
Host Andy Mallon persuades his interviewee (Rie Irish) to discuss personal experiences during his chats while discussing the highlights and lowlights of her career.
We will talk about Rie's childhood, how she got started in the business, her early career, and behind-the-scenes trivia. The interview concludes with the Proust Questionnaire, made famous by Bernard Pivot (Apostrophes) and James Lipton (Inside the Actors Studio). Attendees will also have an opportunity to ask their own questions.
Event Date: 09-12-2017 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment
In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.
By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.
Event Date: 09-12-2017 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment
Event Date: 09-12-2017 - Session time: 15:05:00 - Track: Analytics and Visualization
How secure Power BI really is in the cloud? We will go over what architecture Power BI uses to secure the data.
How does user security work Power BI? We will cover "who can see what" from a user point of view.