| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Adam Belebczuk | Application Database Development | XML Without Xanax: How to Handle XML in SQL Server |
| 09:00:00 | Thomas Grohser | Enterprise Database Administration Deployment | Designing SQL Server HA/DR Infrastructure to meet the SLA |
| 09:00:00 | David Klee | Enterprise Database Administration Deployment | Virtual SQL Servers, Actual Performance |
| 09:00:00 | Andy Galbraith | Enterprise Database Administration Deployment | Getting Started with Extended Events |
| 09:00:00 | Delora Bradish | BI Platform Architecture, Development Administration | Build Your BI House with a Blueprint: Modeling for MS BI |
| 10:15:00 | Derik Hammer | Enterprise Database Administration Deployment | Architecting Availability Groups |
| 10:15:00 | Steve Simon | BI Information Delivery | DAX and the tabular model |
| 10:15:00 | Andrew Novick | Application Database Development | Entity-Attribute-Value (EAV): The Antipattern too Great to Give Up |
| 10:15:00 | Paresh Motiwala | Enterprise Database Administration Deployment | TempDB- More permanent impact than you think |
| 10:15:00 | Casey Karst | Analytics and Visualization | PolyBase for SQL Server 2016: Connecting Hadoop and SQL Server with ease. |
| 10:15:00 | Tim Mitchell | BI Platform Architecture, Development Administration | Managing Security in SSIS |
| 11:30:00 | Edward Pollack | Application Database Development | Query Optimization Crash Course |
| 11:30:00 | Meagan Longoria | BI Platform Architecture, Development Administration | Building your ETL Framework with BIML |
| 11:30:00 | Reeves Smith | Advanced Analysis Techniques | The New Revolution in Data Science, R Integrated into SQL Server |
| 11:30:00 | Chris Lumnah | Enterprise Database Administration Deployment | Taking the pain out of database migrations |
| 11:30:00 | Aaron Bertrand | Enterprise Database Administration Deployment | SQL Server 2014 2016 Features for non-Enterprise Customers |
| 12:30:00 | Leslie Weed | BI Platform Architecture, Development Administration | Source Control practices for your BI World |
| 12:30:00 | David Benoit | Strategy and Architecture | An Introduction To Big Data For The SQL Server DBA |
| 13:15:00 | Allan Hirt | Enterprise Database Administration Deployment | Deploy Highly Available SQL Server for Virtualization the Cloud |
| 13:15:00 | Bryan Cafferky | Application Database Development | Advanced PowerShell Development |
| 13:15:00 | Thomas LaRock | Enterprise Database Administration Deployment | Monitoring Databases in a Virtual Environment |
| 13:15:00 | Jes Schultz | Enterprise Database Administration Deployment | Minimize Data Loss with Advanced Restore Methods |
| 13:15:00 | Sunil Kadimdiwan | BI Information Delivery | SSRS 2016 - End-to-end Mobile BI on any device |
| 13:15:00 | Andrzej Pilacik | Enterprise Database Administration Deployment | Refresh a 1TB+ database in under 10 seconds |
| 14:30:00 | Denny Cherry | Application Database Development | Table Indexing for the .NET Developer |
| 14:30:00 | George Walters | Enterprise Database Administration Deployment | Organizational Security Compliance with SQL 2012 through 2016 |
| 14:30:00 | Jason Horner | BI Information Delivery | Spatial Analysis Jumpstart: Beyond Bubble charts |
| 14:30:00 | Geoff Hiten | Professional Development | Smart Rats Leave First |
| 14:30:00 | Joseph D'Antoni | Enterprise Database Administration Deployment | Picking the Right Fights with Your Server Team |
| 14:30:00 | Andy Roberts | Cloud Application Development Deployment | Data Movement with Azure Data Factory |
| 15:45:00 | James Serra | Professional Development | Enhancing your career: Building your personal brand |
| 15:45:00 | Taiob Ali | Enterprise Database Administration Deployment | SQL Server Agent : All the Knobs You Need to Know |
| 15:45:00 | Chris Seferlis | BI Platform Architecture, Development Administration | Scratching the Surface: Designing your first Power View Report |
| 15:45:00 | Grant Fritchey | Application Database Development | The Query Store and Query Tuning in SQL Server vNext |
| 15:45:00 | Jack Corbett | Application Database Development | Don't Be Trigger Happy: Safe Use of Triggers |
| 15:45:00 | Mike Walsh | Professional Development | Never Have to Say "Mayday!!!" Again |
Event Date: 19-03-2016 - Session time: 09:00:00 - Track: Application Database Development
We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.
If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.
Event Date: 19-03-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
This session will show how to select from the many HA/DR features you have in SQL Server to pick the ones that will help you meet the SLA and most important will tell you how you must combine them to be successful. For each one of the solutions we discuss we will define a series of failure modes and then check if the solution actually can fulfill the SLA as promised or if it needs more
Event Date: 19-03-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
This session is packed with many tips and tricks for getting the most performance from your virtual SQL Servers. The major roadblocks to performance are discussed, and the knowledge gained can help you work with your infrastructure engineers so that you can optimize the system stack for performance. Tools, techniques, and processes are demonstrated to help you measure and validate the system performance of the key components underneath your data.
Event Date: 19-03-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.
Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
Event Date: 19-03-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-03-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-03-2016 - Session time: 10:15:00 - Track: BI Information Delivery
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
Event Date: 19-03-2016 - Session time: 10:15:00 - Track: Application Database Development
In many applications the advantages outweigh the disadvantages and EAV has been in use for 50 years in a variety of applications such as Medical Research, Financial Services and e-Commerce. This presentation will discuss:
• What is Entity-Attribute-Value and show variations including temporal variations • What are the problems with EAV • How to handle the problems and reduce the chance of introducing bugs • Efficiently storing EAV data through partitioning and compression • ETL on frequently changing EAV data • Pivoting EAV data for efficient queries
Event Date: 19-03-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
What works for you in one situation may not work for you in another situation. What works for a situation today, might not guarantee its success for a similar situation tomorrow.
We will talk about Temporary User Objects, Work Tables, Interim Results Version Store for Data Standards for its configuration Contention Data Files Per CPU - Myth or Reality? Dynamic Growth or Pre Sized? Trace Flags to Manage Tempdb? Should we store the entire Tempdb on SSDs? Should we shrink TempDB or not?
Hopefully at the end of the session your knowledge on Tempdb won't be Temp.
Event Date: 19-03-2016 - Session time: 10:15:00 - Track: Analytics and Visualization
Event Date: 19-03-2016 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
In this presentation, we’ll discuss the security features in SQL Server Integration Services, while reviewing best practices for securing your ETL infrastructure while providing enough (but not too much) access to those ETL assets. Among the topics we’ll cover: Properly securing connection passwords in SSIS Using package protection levels Restricting access to deployed packages Using role-based security for SSIS deployment and execution Using execution proxies
Event Date: 19-03-2016 - Session time: 11:30:00 - Track: Application Database Development
This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We'll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!
Event Date: 19-03-2016 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-03-2016 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
This session will demo the functionality and power of using R within SQL Server.
Event Date: 19-03-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
This session will discuss what you need to take into account to ensure a successful pain free database migration. These steps can be used for a single database, multiple databases, or an entire server. By the end of the session, you will have a checklist of the items you need to consider for a database migration.
Event Date: 19-03-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-03-2016 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-03-2016 - Session time: 12:30:00 - Track: Strategy and Architecture
This presentation will answer all those questions, and will introduce you to the concepts that are the driving force behind a move to utilize "big data" technologies. It will introduce you to some of the key vendors and tools that are the most recognized today, which can help get a SQL Server DBA working on these systems very quickly. During the presentation we will cover those scenarios where big data technologies can be helpful, where they really just don't fit, and why.
Finally, there will be an introduction on how Azure is playing a significant role in this move, and how this could potentially benefit you in your environment.
So, come with an open mind, and be prepared to get excited about what a future with big data might hold for you!
Event Date: 19-03-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-03-2016 - Session time: 13:15:00 - Track: Application Database Development
• Maximize Reuse with Advanced Functions using CmdletBinding
• Increase Extensibility with Script Modules
• Add Support for User Interaction
• Efficiently Access SQL Server
• Add Support for Application Configuration
• Add Support for Pipeline Processing
Learn how to take your PowerShell skills to the next level. For those not familiar with PowerShell, here's your chance to see what the buzz is about.
Event Date: 19-03-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
This presentation describes the metrics DBAs must use in their performance and monitoring practices.
Event Date: 19-03-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-03-2016 - Session time: 13:15:00 - Track: BI Information Delivery
Come to this interactive session and learn how you can do it.
Event Date: 19-03-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Finally, the presentation will focus on an architecture based on SAN technologies with respect to SQL Server. I will demonstrate an architecture put in place resolving many business needs in a financial trading environment, working with large data sets and many different environments. This section will highlight the benefits of using SQL Server together with newer SAN solutions and show the potential for reliability, scalability, and the delivery of a high quality HA/DR solution. That is where things get interesting...
Event Date: 19-03-2016 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 19-03-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-03-2016 - Session time: 14:30:00 - Track: BI Information Delivery
Event Date: 19-03-2016 - Session time: 14:30:00 - Track: Professional Development
Event Date: 19-03-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
In this session you will learn about how to choose battles and win (with data!): • How to configure storage and file systems for SQL Server • Why you should always compress your backups • How your virtual machines should be configured for SQL Server • What rights you and your servers need in Active Directory • Many more and more importantly—which battles NOT to fight After attending this session, you will have a good understanding of how to talk with your peers in the infrastructure teams and make sure the key SQL Servers in your environment have the resources they need to perform great.
Event Date: 19-03-2016 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
Let's set up a couple of data pipelines to see the strengths of Azure Data Factory and when traditional ETL is a better fit.
Event Date: 19-03-2016 - Session time: 15:45:00 - Track: Professional Development
Event Date: 19-03-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 19-03-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-03-2016 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 19-03-2016 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 19-03-2016 - Session time: 15:45:00 - Track: Professional Development
In this session, we'll look at case studies of real-life aviation disasters and production database downtime incidents. We'll see similarities in attitudes that cause disasters. Come learn about the importance of preparation, troubleshooting, and teamwork. This will be an interactive session where we’ll pick apart disasters, engage in discussion around case studies, and leave prepared to change attitudes in ourselves and our colleagues and avoid disasters at work.