| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:15:00 | David Maxwell | Enterprise Database Administration Deployment | Turbo-Charged Transaction Logs |
| 08:15:00 | Keith Tate | Enterprise Database Administration Deployment | Profiler is Dead! Long Live Extended Events! |
| 08:15:00 | Ross LoForte | Enterprise Database Administration Deployment | What's New in SQL Server 2016 |
| 08:15:00 | Jim Dorame | Enterprise Database Administration Deployment | How to collect a baseline on all your servers and still get a good night's sleep. |
| 08:15:00 | Thomas Norman | Application Database Development | Encrypting Data within Sql Server |
| 08:15:00 | Peter Shore | Enterprise Database Administration Deployment | Infrastructure for the DBA: An Introduction |
| 08:15:00 | Dave Bland | BI Platform Architecture, Development Administration | SSAS: What is it and How do I get started using it |
| 08:15:00 | Eddie Wuerch | Enterprise Database Administration Deployment | What is a Latch, and Why Do I Care? |
| 09:30:00 | Brent Ozar | Strategy and Architecture | Licensing Simplified: AlwaysOn, Virtualization, and More |
| 09:30:00 | Kathi Kellenberger | Application Database Development | Introduction to Window Functions |
| 09:30:00 | Christopher Wolff | Application Database Development | Continuous Deployments using SSDT |
| 09:30:00 | George Walkey | Enterprise Database Administration Deployment | Scripting out SQL Server for Documentation and Disaster Recovery |
| 09:30:00 | Drew Furgiuele | Enterprise Database Administration Deployment | SQL Server and PowerShell: Let's Get Serious |
| 09:30:00 | Cathrine Wilhelmsen | BI Platform Architecture, Development Administration | Biml for Beginners: Speed up your SSIS development |
| 09:30:00 | Sean McCown | Enterprise Database Administration Deployment | Monster Text Manipulation: Regular Expressions for the DBA |
| 09:30:00 | Luke Jian | Enterprise Database Administration Deployment | Anatomy of an Optimizer |
| 10:45:00 | David Giard | BI Information Delivery | Effective Data Visualization: The Ideas of Edward Tufte |
| 10:45:00 | Brandon Leach | Enterprise Database Administration Deployment | Data Pages, Allocation Units, IAM chains... Oh My! |
| 10:45:00 | Austin Senseman | Advanced Analysis Techniques | Context Calculation, Back to the Basics with DAX |
| 10:45:00 | Mark Broadbent | Application Database Development | Lock, Block and Two Smoking Barrels |
| 10:45:00 | Allan Hirt | Enterprise Database Administration Deployment | Top 10 Clustering Dos and Don'ts |
| 10:45:00 | Daniel Janik | Advanced Analysis Techniques | Analyze your query plan like a Microsoft Engineer! |
| 10:45:00 | Pat Phelan | Application Database Development | Data Architecture 101 |
| 10:45:00 | Ed Leighton-Dick | Enterprise Database Administration Deployment | Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace) |
| 12:10:00 | Fred Bliss | BI Platform Architecture, Development Administration | Big Data in the Modern Data Warehouse |
| 12:10:00 | Jennifer McCown | Enterprise Database Administration Deployment | Effortless Backups with Minion Backup |
| 12:10:00 | Mickey Stuewe | Professional Development | Be a Role Model for Women in Tech through Blogging |
| 12:10:00 | Kalen Delaney | Enterprise Database Administration Deployment | Are You Optimistic About Concurrency? |
| 12:10:00 | Christopher Slater | Enterprise Database Administration Deployment | IO Whack-a-Mole |
| 12:10:00 | Wendy Pastrick | Strategy and Architecture | Transform Database Agility with XtremIO -- EMC Sponsored Session |
| 12:10:00 | Wendy Pastrick | Other | DELL Sponsored Session - David Swanson |
| 12:10:00 | John Sterrett | Enterprise Database Administration Deployment | Workload Replay: Synthetic vs Real-World Benchmarking |
| 13:15:00 | John Deardurff | Application Database Development | What is your Character Data Type? |
| 13:15:00 | Juan Soto | Other | Wish you could live the glamorous consulting life? |
| 13:15:00 | Hope Foley | Analytics and Visualization | Spatial Data - Looking Outside the Map |
| 13:15:00 | Grant Fritchey | Cloud Application Development Deployment | Azure SQL Database for the Earthed DBA |
| 13:15:00 | Kevin Boles | Application Database Development | Common TSQL Mistakes |
| 13:15:00 | Anthony Nocentino | Enterprise Database Administration Deployment | Performance Monitoring AlwaysOn Availability Groups |
| 13:15:00 | Amy Herold | Professional Development | Making the Leap from Developer to DBA |
| 13:15:00 | Paul Turley | BI Information Delivery | Reporting Services 2016 Solutions: The New Awesome |
| 14:30:00 | Josh Fennessy | Cloud Application Development Deployment | Big Data in the Cloud - An Intro to HDInsight and Microsoft Azure |
| 14:30:00 | Thomas Grohser | Enterprise Database Administration Deployment | Designing SQL Server HA/DR Infrastructure to meet the SLA |
| 14:30:00 | David Klee | Enterprise Database Administration Deployment | Virtual SQL Servers, Actual Performance |
| 14:30:00 | Jason Horner | BI Platform Architecture, Development Administration | Dimensional Modeling Design Patterns: Beyond Basics |
| 14:30:00 | Andy Mallon | Professional Development | Shortcuts from an Impatient DBA |
| 14:30:00 | Rob Volk | Application Database Development | Tame Your Unruly Data...With Constraints! |
| 14:30:00 | John Pertell | Analytics and Visualization | "R" You Ready For SQL 2016? |
| 14:30:00 | J May | Enterprise Database Administration Deployment | Intro to Monitoring I/O: The Counters That Count |
| 15:45:00 | Paul Popovich Jr | Enterprise Database Administration Deployment | Clusters! From the ground up, let's build one together |
| 15:45:00 | John Martin | Professional Development | Becoming the Data Platform Engineer of Tomorrow |
| 15:45:00 | Kevin Feasel | Strategy and Architecture | Much Ado About Hadoop |
| 15:45:00 | Adam Belebczuk | Application Database Development | XML Without Xanax: How to Handle XML in SQL Server |
| 15:45:00 | Jared Karney | Application Database Development | Introduction to Indexes and SARGability |
| 15:45:00 | Mike Hillwig | Enterprise Database Administration Deployment | Teaching Your Servers to Call For Help |
| 15:45:00 | Warner Chaves | Enterprise Database Administration Deployment | Time to Stretch: Scaling out with Azure DB Elastic Scale |
| 15:45:00 | Seth Bauer | BI Information Delivery | Power BI - Explore SQL Server Database and Performance Metrics |
Event Date: 05-03-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool!
In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!
Event Date: 05-03-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology help protect your data at rest and in motion, and a world-class high availability and disaster recovery solution adds new enhancements. Organizations will gain deeper insights into all of their data with new capabilities that go beyond business intelligence to perform advanced analytics directly within their database. Additionally to the ability to dynamically stretch warm and cold transactional data to Microsoft Azure in a secured way.
Event Date: 05-03-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 08:15:00 - Track: Application Database Development
Event Date: 05-03-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-03-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 09:30:00 - Track: Strategy and Architecture
Event Date: 05-03-2016 - Session time: 09:30:00 - Track: Application Database Development
This session will teach you how to avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Event Date: 05-03-2016 - Session time: 09:30:00 - Track: Application Database Development
Event Date: 05-03-2016 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. By Learning a little Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers
Event Date: 05-03-2016 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
It is time to bring the Don't Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml and BimlScript to generate SSIS packages from database metadata and implement changes in all packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code.
Speed up your SSIS development by using Biml and BimlScript, and see how you can complete in a day what once took more than a week!
Event Date: 05-03-2016 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
• 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: 05-03-2016 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
We will also explore the differences between In-Memory OLTP tables vs Disk based tables, and have a look at some considerations when you use the new cardinality estimator We explain why query optimization complexity increases exponentially with the number of tables included in the plan, and how to diagnose and remedy issues that relate to bad query plans
Event Date: 05-03-2016 - Session time: 10:45:00 - Track: BI Information Delivery
Yale professor Edward Tufte presented many ideas on how to effectively present data to an audience or end user. In this session, I will explain some of Tufte's most important guidelines about data visualization and how you can apply those guidelines to your own data. You will learn what to include, what to remove, and what to avoid in your charts, graphs, maps and other images that represent data.
Event Date: 05-03-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.
Event Date: 05-03-2016 - Session time: 10:45:00 - Track: Advanced Analysis Techniques
This session is for the intermediate DAX user who has produced some quality data models and DAX calculations but who is still having difficulties with functions around filtering, time intelligence, and complex calculations. We'll go through a number of practical examples that show that DAX at a fundamental level is a combination of creating filter and row CONTEXTS and then using those contexts to produce CALCULATIONS. Understanding this concept is a must to produce more complex code in DAX and it's also a very useful framework for someone just getting started.
Event Date: 05-03-2016 - Session time: 10:45:00 - Track: Application Database Development
In SQL Server 2005, two optimistic concurrency mechanisms were introduced and touted as the solution to all our problems. Now in SQL Server 2012, 2014 and 2016 even more have followed, but many challenges and problems still remain. Let’s take a long look into the world of SQL Server concurrency and investigate Pessimistic and Optimistic isolation understanding how they work, when you should use them, and more importantly when they can go very wrong. Don't be staring down the wrong end of SQL Server's two Smoking Barrels and join me for this revealing and thought provoking presentation.
Event Date: 05-03-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 10:45:00 - Track: Advanced Analysis Techniques
Event Date: 05-03-2016 - Session time: 10:45:00 - Track: Application Database Development
You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
Event Date: 05-03-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 12:10:00 - Track: BI Platform Architecture, Development Administration
This session aims to define big data from the perspective of the enterprise data warehouse, while also arguing that both big data and data warehouses compliment one another perfectly. By using Google's big data analytics platform (BigQuery), SSIS, and a data warehouse built in SQL Server, we will illustrate how big data can best serve your organization, while also combining cloud and on-premise solutions across competing technology platforms.
Event Date: 05-03-2016 - Session time: 12:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 12:10:00 - Track: Professional Development
Event Date: 05-03-2016 - Session time: 12:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 12:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 12:10:00 - Track: Strategy and Architecture
Event Date: 05-03-2016 - Session time: 12:10:00 - Track: Other
Event Date: 05-03-2016 - Session time: 12:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 13:15:00 - Track: Application Database Development
Event Date: 05-03-2016 - Session time: 13:15:00 - Track: Other
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way. In this session you will learn sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out. Y
Event Date: 05-03-2016 - Session time: 13:15:00 - Track: Analytics and Visualization
Event Date: 05-03-2016 - Session time: 13:15:00 - Track: Cloud Application Development Deployment
Event Date: 05-03-2016 - Session time: 13:15:00 - Track: Application Database Development
Event Date: 05-03-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 13:15:00 - Track: Professional Development
Event Date: 05-03-2016 - Session time: 13:15:00 - Track: BI Information Delivery
Event Date: 05-03-2016 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
This session will help to dispel some of the Big Data confusion. This session will focus on HD Insight, Microsoft's Hadoop based cloud implementation. Loading data and querying a database is one thing and that will certainly be covered. Exploring how we can integrate data from HD Insight into our existing analytic solutions is one of the real world implementations this session will be focused on. This is one of the keys to successfully selling management on the needs for a Big Data solution. It's not just another database, it's a tool to enhance existing analytic structures.
During this session, we'll start with a brief overview of Hadoop and HDFS. Next we'll take a look at HDInsight, and explore some of the features therein.
Event Date: 05-03-2016 - Session time: 14:30: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: 05-03-2016 - Session time: 14:30: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: 05-03-2016 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular. Correctly modeling your organization's data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.
This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Event Date: 05-03-2016 - Session time: 14:30: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 at writing code. 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.
Event Date: 05-03-2016 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 05-03-2016 - Session time: 14:30:00 - Track: Analytics and Visualization
In this beginner session we will look at how to set up R on your SQL instance. We'll work with some sample data to show how R works with SQL inside and outside the database with some basic R commands. And we'll create some graphs and charts for use in some SSRS reports.
Event Date: 05-03-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 15:45:00 - Track: Professional Development
Will the traditional developer, BI and DBA roles that we know so well today be the same, or will we need to diversify and look at expanding into other areas to stay ahead of the curve?
Event Date: 05-03-2016 - Session time: 15:45:00 - Track: Strategy and Architecture
Event Date: 05-03-2016 - Session time: 15:45: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: 05-03-2016 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 05-03-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-03-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
In particular, dynamically scaling the database tier can be difficult due to having to deal with distribution schemes, data movement, application routing and the actual increase or decrease of the database resources. Azure SQL Database and the Elastic Scale .NET API combine to provide a solution to these challenges in an easy to use but powerful set of capabilities.
In this session we will demo the elastic scale API, elastic db pools, elastic query and elastic database jobs and how they combine to bring database elasticity in your own application and take advantage of true cloud optimized infrastructure!
Event Date: 05-03-2016 - Session time: 15:45:00 - Track: BI Information Delivery