| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Paul Turley | BI Information Delivery | Mastering Power BI Solutions - Basics and Beyond |
| 08:30:00 | Ben Miller | Application Database Development | PreCon: PowerShell for SQL Server |
| 08:30:00 | Steve Stedman | Enterprise Database Administration Deployment | When Database Corruption Strikes |
| 08:30:00 | Janis Griffin | Enterprise Database Administration Deployment | Welcome To the 2016 Query Store! |
| 08:30:00 | Arvind Shyamsundar | Application Database Development | Hop, Skip and Jump! Exploring the new Graph capabilities in Azure |
| 08:30:00 | Davide Mauri | BI Platform Architecture, Development Administration | SSIS Monitoring Deep Dive |
| 08:30:00 | Yana Berkovich | Information Delivery | Give more power to the users! - Decision Support Using Power BI SP O365 data for a Small Business |
| 08:30:00 | Kun Cheng | Cloud Application Development Deployment | Azure SQL Database best practices in resiliency design |
| 09:45:00 | David Patrick | Application Database Development | SharePoint and Azure - How to JumpStart SharePoint Development Fast and Easy with Cloud Power! |
| 09:45:00 | Davide Mauri | Application Database Development | JSON SQL Server: using it effectively |
| 09:45:00 | Sunil Agarwal | Enterprise Database Administration Deployment | ColumnStore Index in SQL Server 2016 and Azure SQL Database |
| 09:45:00 | Vern Rabe | Enterprise Database Administration Deployment | Query Optimization Statistics : Driving Force Behind Performance |
| 09:45:00 | Julie Koesmarno | Analytics and Visualization | Intro to Azure Data Lake and U-SQL |
| 09:45:00 | Mike Oberlin | Other | Architecting for Active/Active Operations |
| 09:45:00 | Christian Wade | BI Platform Architecture, Development Administration | What’s New in Analysis Services |
| 11:00:00 | Steve Moss | BI Platform Architecture, Development Administration | Modern Data Warehousing with Azure SQL DW |
| 11:00:00 | Mindy Curnutt | Application Database Development | Fun with SQL Server Spatial Data |
| 11:00:00 | Sean McCown | Enterprise Database Administration Deployment | Monster Text Manipulation: Regular Expressions for the DBA |
| 11:00:00 | Nicholas Cain | Enterprise Database Administration Deployment | Availability Groups: What They’re Not Telling You |
| 11:00:00 | Nicholas Cain | Enterprise Database Administration Deployment | DBATools.io: A Better Way to Manage SQL With PowerShell |
| 11:00:00 | Rock Pereira | Advanced Analysis Techniques | Data Science at Scale with R Services |
| 11:00:00 | Ben Miller | Strategy and Architecture | SQL Server Encryption |
| 13:30:00 | Sanjay Mishra | Enterprise Database Administration Deployment | High Availability and Disaster Recovery for SQL Server on Linux |
| 13:30:00 | Argenis Fernandez | Enterprise Database Administration Deployment | Hacking SQL Server for Fun and Profit |
| 13:30:00 | Paul Turley | BI Information Delivery | Reporting Services 2016: The Force Awakens |
| 13:30:00 | David Brown | Advanced Analysis Techniques | How to Use Analytics (and Data Science) to Get a Promotion |
| 13:30:00 | Jennifer McCown | Application Database Development | Designing Stored Procedure Solutions |
| 13:30:00 | J May | Strategy and Architecture | SQL Server 2016 Always On Availability Groups Perf Internals |
| 14:45:00 | Pedro Lopes | Enterprise Database Administration Deployment | Enhancements that will make your SQL database engine roar! |
| 14:45:00 | Maxwell Myrick | Professional Development | Insider Secrets to Securing the Budget You Need |
| 14:45:00 | Paul Turley | BI Platform Architecture, Development Administration | Power BI for the Enterprise |
| 14:45:00 | Amit Banerjee | Advanced Analysis Techniques | Building 1 million predictions per second using SQL-R |
| 14:45:00 | Simon Cho | Application Database Development | Myths and Truths about SQL Server Transaction |
| 14:45:00 | Scott Stauffer | BI Platform Architecture, Development Administration | Power BI for the Faint of Heart - Understanding On-Prem, Hybrid and Pure Cloud Scenarios |
| 14:45:00 | Sean McCown | Enterprise Database Administration Deployment | Loading SQL Server Data with Powershell |
Event Date: 15-04-2017 - Session time: 08:30:00 - Track: BI Information Delivery
In this Power BI hands-on Workshop, you will learning essentials and some advanced techniques to transform, model and analyze business information with this powerful platform. Techniques and best practices presented are from several prior workshops and years of field experience. Learn to use self-service and enterprise-scale Power BI capabilities; gain valuable skills to integrate, wrangle, shape and visualize data for analysis. Beginning and intermediate level users will learn to address data and reporting challenges with advanced design techniques. At the conclusion of the workshop, you will have a complete solution built from real business data, shaped, cleansed modeled; with a dashboard and interactive report visuals ready for analysis. Topics skills include: Power Query/M, modeling and calculations/DAX, standards custom visuals, R visuals. Data sources: CSV, JSON, SQL Server; query folding, scheduled refresh DirectQuery.
Event Date: 15-04-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 15-04-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
We will walk through three corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you can do to protect yourself when corruption strikes. Learn how to avoid making things worse, and how to protect your data if things do get worse. You will leave with a checklist of steps to use when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.
Event Date: 15-04-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 15-04-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 15-04-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 15-04-2017 - Session time: 08:30:00 - Track: Information Delivery
Event Date: 15-04-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 15-04-2017 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 15-04-2017 - Session time: 09:45:00 - Track: Application Database Development
But how it fits in the relational database space? How the usage of JSON can simplify DBAs and DEVs everyday work? What about performances? And what about flexibility? In this session we'll see how powerful JSON can be, when used correctly and not abused, providing solution to common problems (like in the well known "dynamic schema" case), simplifying development (for example to pass to Stored Procedure complex objects or variable numbers of parameters) with also very good performances, even if they maybe hidden in not-so-obvious places.
Event Date: 15-04-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 15-04-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 15-04-2017 - Session time: 09:45:00 - Track: Analytics and Visualization
Event Date: 15-04-2017 - Session time: 09:45:00 - Track: Other
Get real-world advice on how to support active/active ops. You'll learn:
Attendees attending the session will: • Understand the application impact of building for active/active ops • Learn best practices for scaled out, distributed SQL Server clusters to limit the impact of database downtime on application availability • Get best practices from customers on enabling active/active operations across data centers
Event Date: 15-04-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 15-04-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
But are they still relevant to the world of data lakes and big data? And what is the role of a relational database, even massively parallel databases like Azure SQL DW or AWS Redshift?
This presentation will explore these questions about when the concepts of DW are still relevant, and then cover some implementation details of a Modern DW on Azure SQL DW, including how to maximize performance by minimizing Data Movement (Shuffle Move and PartitionMove operations).
Event Date: 15-04-2017 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 15-04-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
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: 15-04-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 15-04-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
The open source DBATools.io project exists to provide a larger (and ever growing) set of commands for DBAs to use to manage, and gather data, from SQL Server. Download the DBATools.io module and play along as we go through a few of the great commands on offer, and learn how you can contribute to a project working to change the way that you manage your environment.
Event Date: 15-04-2017 - Session time: 11:00:00 - Track: Advanced Analysis Techniques
Event Date: 15-04-2017 - Session time: 11:00:00 - Track: Strategy and Architecture
Event Date: 15-04-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 15-04-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 15-04-2017 - Session time: 13:30:00 - Track: BI Information Delivery
Event Date: 15-04-2017 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Welcome to my world. I've worked for years as a consultant, and I started in this situation, but I began making a living helping folks crawl their way out. Along the way, I got my Microsoft MVP, and I've helped many organizations make millions of more dollars through my consulting efforts. I'd like to help you, too.
Event Date: 15-04-2017 - Session time: 13:30:00 - Track: Application Database Development
Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance
This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.
Event Date: 15-04-2017 - Session time: 13:30:00 - Track: Strategy and Architecture
Our work shows enhancements of 7x – 10x, allowing over 1/2GB/s (4Gb/s) across the wire. These improvements expand solutions options for Tier 1 OLTP and Data Warehouse workloads, Tier 1 and Tier 2 consolidation, and more. This presentation explains the improvements, characterizes the new solutions, and shows commodity servers and modern non-shared in-server flash storage showing the profound contrast between SQL Server 2014 vs. 2016. Doing so moves the performance bottleneck from the SQL Server codebase to the CPU where it belongs.
Event Date: 15-04-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
In the last couple of years, SQL Tiger Team has worked closely with many customers running Tier-1 mission critical workloads to scale their SQL Server with several configuration parameters and application patterns. In this session, you will hear directly from experienced members of the Microsoft SQL Server Tiger Team, about these specific enhancements, configurations, and approaches for scaling SQL Server on the largest hardware systems available in the planet.
Event Date: 15-04-2017 - Session time: 14:45:00 - Track: Professional Development
Event Date: 15-04-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 15-04-2017 - Session time: 14:45:00 - Track: Advanced Analysis Techniques
Event Date: 15-04-2017 - Session time: 14:45:00 - Track: Application Database Development
We demonstrate examples of incorrect development methodologies and analyze internal transaction logs in multi-transaction cases. After identifying the common mistakes, we will cover the best practice to avoid nested transactions in a stored procedure for smart error handling. We will also learn the basics of minimally logged operations.
Event Date: 15-04-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 15-04-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment