| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:15:00 | John Deardurff | Application Database Development | The Vocabulary of Performance Tuning |
| 08:15:00 | Ameena Lalani | Enterprise Database Administration Deployment | Learn History from Temporal Tables |
| 08:15:00 | Andy Mallon | Professional Development | Shortcuts from an Impatient DBA |
| 08:15:00 | Jamey Johnston | BI Platform Architecture, Development Administration | Code Like a Pirate ... Intro to R and Data Science Tools in MS |
| 08:15:00 | Steve Jones | Application Database Development | End to End Encryption and Security in SQL Server 2016 |
| 08:15:00 | Joseph D'Antoni | Cloud Application Development Deployment | Choosing Your Cloud Data Platform--SQL DB, Managed Instance or Something Else? |
| 09:30:00 | Angela Tidwell | Professional Development | Become the Most Valuable Player: Soft Skills for the Hard Market |
| 09:30:00 | Marsha Pierce | Enterprise Database Administration Deployment | How To Talk To Your Storage Admin |
| 09:30:00 | Jeff Renz | Application Database Development | Introduction To Azure Cosmos DB |
| 09:30:00 | Leslie Andrews | BI Platform Architecture, Development Administration | The Power of Data: The Complete Beginners Data Warehouse Kit |
| 09:30:00 | Jason Brimhall | Application Database Development | The Anatomy of Select |
| 09:30:00 | Alex Yates | Strategy and Architecture | How to screw up Database DevOps in 16 simple steps |
| 10:45:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Tips on Managing Lots of SQL Servers |
| 10:45:00 | Drew Furgiuele | Enterprise Database Administration Deployment | SQL Server and PowerShell: Let's Get Serious |
| 10:45:00 | Kevin Feasel | Application Database Development | Using Kafka for Real-Time Data Ingestion with .NET |
| 10:45:00 | Daniel Glenn | BI Platform Architecture, Development Administration | Gaining insights with Power BI |
| 10:45:00 | Jim Donahoe | Strategy and Architecture | Mario..Take My Data To The Cloud! |
| 10:45:00 | Tim Chapman | Other | Choose Your Own Adventure: Performance Tuning |
| 12:00:00 | Jim Miller | BI Platform Architecture, Development Administration | BITRACKS:Populating a Data Warehouse with SSIS and Biml Patterns |
| 12:00:00 | Diane Schuster | BI Platform Architecture, Development Administration | COZYROC: Dynamic Data Flows in SSIS Without Programming |
| 12:00:00 | Justin Randall | Other | SENTRYONE: Break Through Your Data Performance Barriers with SentryOne |
| 12:00:00 | Susan Wong | Strategy and Architecture | QUEST:Optimize transactional operations and reporting from multiple sources |
| 12:00:00 | Bryan Walsh | Other | DELL: #GetModern With Dell EMC |
| 13:15:00 | Sean Werick | Strategy and Architecture | Choosing the Right Microsoft Data Science Platform |
| 13:15:00 | Elizabeth Noble | Professional Development | How to win Dev and influence QA |
| 13:15:00 | Jason Brimhall | Enterprise Database Administration Deployment | Extended Events - Better than Profiler |
| 13:15:00 | Jim Donahoe | Cloud Application Development Deployment | Getting started with Azure SQL Database: What You Need To Know! |
| 13:15:00 | Stan Siranovich | Analytics and Visualization | How to do a Data Analysis |
| 13:15:00 | Steve Jones | Cloud Application Development Deployment | Panel: Is the Cloud Good or Bad for Business? |
| 14:30:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Intro to Query Store |
| 14:30:00 | Andrew Loree | Analytics and Visualization | Getting started with Machine Learning |
| 14:30:00 | Chris Bell | Enterprise Database Administration Deployment | 5 Minute No Sweat SQL Security Audits |
| 14:30:00 | Louis Davidson | Application Database Development | Implementing Row Level Security in SQL Server |
| 14:30:00 | Warren Sifre | BI Platform Architecture, Development Administration | Introduction to BI Architecture |
| 14:30:00 | Justin Randall | Enterprise Database Administration Deployment | TempDB Configuration, Monitoring, and Troubleshooting for Performance |
| 15:45:00 | Leslie Weed | BI Platform Architecture, Development Administration | Source Control and Database Projects - Just Do It |
| 15:45:00 | Matt Gordon | Cloud Application Development Deployment | Where Should My Data Live (and Why)? |
| 15:45:00 | Rob Volk | Enterprise Database Administration Deployment | That's So Metadata: Discover Your Database From the Inside |
| 15:45:00 | Peter Shore | Other | The Data-Professional’s Junk Drawer |
| 15:45:00 | Jonathan Stewart | Application Database Development | Relationship Goals: The SQL Server Graph Database |
| 15:45:00 | Gareth Swanepoel | BI Platform Architecture, Development Administration | SQL Server ColumnStore Indexes |
Event Date: 21-07-2018 - Session time: 08:15:00 - Track: Application Database Development
Event Date: 21-07-2018 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-07-2018 - Session time: 08:15:00 - Track: Professional Development
We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient with how we use our tools. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier.
Even the most seasoned Database Professionals will learn a new trick that makes SSMS even easier to use.
Slides and handouts available on GitHub: http://am2.co/shortcuts-ppt
Event Date: 21-07-2018 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration
Come to this session to get an introduction to the R language including:
We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Event Date: 21-07-2018 - Session time: 08:15:00 - Track: Application Database Development
Event Date: 21-07-2018 - Session time: 08:15:00 - Track: Cloud Application Development Deployment
Event Date: 21-07-2018 - Session time: 09:30:00 - Track: Professional Development
Event Date: 21-07-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-07-2018 - Session time: 09:30:00 - Track: Application Database Development
In this session I will demonstrate how to create a Cosmos DB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript. Finally, I will compare performance and feature difference between SQL Server 2016 and Azure Cosmos DB.
Event Date: 21-07-2018 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 21-07-2018 - Session time: 09:30:00 - Track: Application Database Development
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: 21-07-2018 - Session time: 09:30:00 - Track: Strategy and Architecture
Updates aren’t held up in 6-month release cycles. We’ve automated tests and deployments collaboratively so we know updates work. A virtuous cycle of innovation and testing allows us to build better, more reliable products faster and cheaper.
However, while that’s great in theory, I’ve seen people screw up spectacularly when applying DevOps to relational databases.
In this cheerful session I’ll review the 16 most popular ways to screw up your ability to deliver database updates, resulting in painful, fragile deployments and expensive legacy databases that no-one likes to maintain.
A session for developers and DBAs.
Event Date: 21-07-2018 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.
Event Date: 21-07-2018 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.
Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.
Event Date: 21-07-2018 - Session time: 10:45:00 - Track: Application Database Development
Event Date: 21-07-2018 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration
This session will cover the basics on creating compelling dashboards and guide you through the process of managing your company’s Power BI service, Power BI desktop, and mobile apps.
Event Date: 21-07-2018 - Session time: 10:45:00 - Track: Strategy and Architecture
Event Date: 21-07-2018 - Session time: 10:45:00 - Track: Other
Event Date: 21-07-2018 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration
The components used during this session:
Attend to see how Biml can revolutionize your SSIS development!
Event Date: 21-07-2018 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 21-07-2018 - Session time: 12:00:00 - Track: Other
Event Date: 21-07-2018 - Session time: 12:00:00 - Track: Strategy and Architecture
Event Date: 21-07-2018 - Session time: 12:00:00 - Track: Other
Event Date: 21-07-2018 - Session time: 13:15:00 - Track: Strategy and Architecture
In this session we dive into the available platforms listed below and provide a brief summary, strengths and weaknesses, scale capabilities, and last but not least, pricing/licensing. • Microsoft R Open • Microsoft R Server • R and Python Services for SQL Server 2017 • Azure Machine Learning Workbench • HDInsight (with Spark) • Microsoft Data Science VM
If you're looking to maximize and optimize your data science platform of choice, be sure to attend.
Event Date: 21-07-2018 - Session time: 13:15:00 - Track: Professional Development
In this session, I will go over steps I took to improve relationships with other members of the IT department. I will also discuss how improving my relationships helped me accomplish my long-term goals.
Event Date: 21-07-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-07-2018 - Session time: 13:15:00 - Track: Cloud Application Development Deployment
Event Date: 21-07-2018 - Session time: 13:15:00 - Track: Analytics and Visualization
We'll show you how to do this with real, publically available data from Redfin, using JMP statistical analysis and visualization software. We'll start with concatenation and subsetting, move on to data integrity, then to visualization, exploratory data analysis, and simple linear regression. We'll make plenty of charts and graphs with some summary statistics thrown in for good measure.
Event Date: 21-07-2018 - Session time: 13:15:00 - Track: Cloud Application Development Deployment
Event Date: 21-07-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning 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 and 2017.
Event Date: 21-07-2018 - Session time: 14:30:00 - Track: Analytics and Visualization
In this session, you will be introduced to the fundamentals of ML, to get you started without requiring a mathematics background. We will look at how to “frame” your data questions, as well as understanding the type of outputs ML can provide in responding with predictions. Focus will be placed on the high-level overview of the ML process, and spend time on the simple steps of determining the “right” algorithm to use. Tools used include Weka and Azure ML Studio, but the focus of the session is on fundamentals and the ML process, not specific toolsets.
Event Date: 21-07-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.
Event Date: 21-07-2018 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 21-07-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 21-07-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-07-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 21-07-2018 - Session time: 15:45:00 - Track: Cloud Application Development Deployment
Event Date: 21-07-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
SQL Server has a number of metadata facilities available to help you with these tasks, and more. Functions, dynamic management views, and system stored procedures can illuminate details from the smallest column up through an entire SQL Server instance and everything in-between. We will demonstrate metadata techniques to help you:
We'll also demonstrate the new SQL Data Discovery/Classification and Vulnerability Assessment features in SQL Server Management Studio.
Event Date: 21-07-2018 - Session time: 15:45:00 - Track: Other
Event Date: 21-07-2018 - Session time: 15:45:00 - Track: Application Database Development
One of the best new features of SQL Server 2017 is the Graph Database! It brings us the best of both worlds in one easy platform! Come learn about the history of graph databases, how they work and why you should be using it!
Event Date: 21-07-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
If you are a production DBA who needs to find out more about some of the additional hot features that have been included with CSI's, like batch mode processing and data segments, then this session is for you. If you are a BI DBA or developer who needs to find out how CSI's can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.