| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Slava Murygin | Enterprise Database Administration Deployment | New SQL Server 2016 Feature: "Query Store" |
| 08:30:00 | Andy Yun | Application Database Development | Performance Pitfalls from Code Reuse |
| 08:30:00 | Peter Myers | Advanced Analysis Techniques | Azure Machine Learning: From Design to Integration |
| 08:30:00 | Mike Lawell | Enterprise Database Administration Deployment | Execution Plans for Mere Mortals |
| 08:30:00 | Aaron Cutshall | Application Database Development | The Lost Science of Set Theory |
| 08:30:00 | Ed Watson | BI Platform Architecture, Development Administration | Introduction to SQL Server Integration Services |
| 08:30:00 | Michael Wells | Enterprise Database Administration Deployment | PowerShell for Absolute Beginnners |
| 08:30:00 | Reza Rad | BI Information Delivery | 10 Amazing Things About Power BI You Don't Know |
| 10:15:00 | John Cook | Cloud Application Development Deployment | Role Based Security in Azure SQL Database |
| 10:15:00 | David Dye | BI Platform Architecture, Development Administration | SSIS Deployment Methods and Dynamic Execution |
| 10:15:00 | Amy Herold | Enterprise Database Administration Deployment | Hi, my name is Powershell, let's be friends! An Intro to PoSH |
| 10:15:00 | Pat Phelan | Application Database Development | Data Architecture 101 |
| 10:15:00 | Asgeir Gunnarsson | BI Information Delivery | Analysing your online presence using Power BI |
| 10:15:00 | Wylie Blanchard | Application Database Development | SQL Server 2014/2016 Technology Enhancements for Developers |
| 10:15:00 | Dan de Sousa | Enterprise Database Administration Deployment | Temporal Tables in SQL 2016 |
| 10:15:00 | Tony Davis | Application Database Development | Diagnosing Common Query Performance Problems with Execution Plans |
| 12:00:00 | Charles Sterling | Cloud Application Development Deployment | Power BI developer features easy as 1-2-3: live tiles, REST APIs, |
| 12:00:00 | Ron Ellis Gaut | Analytics and Visualization | Power BI - Dashboard in an Hour |
| 12:00:00 | Douglas Barrett | BI Platform Architecture, Development Administration | WhereScape RED - an agile IDE for Data Warehouses |
| 12:00:00 | Mickey Stuewe | Enterprise Database Administration Deployment | Keeping your SQL Objects Safe In Development |
| 12:00:00 | Jason Picker | BI Platform Architecture, Development Administration | Learn about Pyramid Analytics BI Office Platform |
| 12:00:00 | OJ Ngo | Enterprise Database Administration Deployment | Cluster Standalone SQL Server Instances at “Ludicrous” Speed |
| 12:00:00 | Kevin Vliet | Enterprise Database Administration Deployment | Remove Repetitive SQL Agent Jobs from Your Plate, from Your Plate |
| 12:00:00 | Craig Allen | Enterprise Database Administration Deployment | Server Storage Performance Best Practices |
| 13:30:00 | Steve Wake | BI Information Delivery | Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting |
| 13:30:00 | Russ Thomas | Enterprise Database Administration Deployment | Real World In-Memory OLTP 2016 |
| 13:30:00 | John Martin | Application Database Development | Making Row Level Security and Dynamic Data Masking work for you! |
| 13:30:00 | Wendy Pastrick | Application Database Development | Why NULL is not a value (and other SQL gotchas) |
| 13:30:00 | Cathrine Wilhelmsen | BI Platform Architecture, Development Administration | Biml for Beginners: Speed Up Your SSIS Development |
| 13:30:00 | Amit Banerjee | Enterprise Database Administration Deployment | SQL Server Debugging Made Easy using Extended Events |
| 13:30:00 | Ben Miller | Enterprise Database Administration Deployment | Inside the SQLPS PowerShell Module |
| 13:30:00 | Leila Etaati | Analytics and Visualization | Cortana Analytics : Transform Data into Intelligence |
| 13:30:00 | Misc Speakers | Advanced Analysis Techniques | Lightening Talks |
| 15:15:00 | Jared Karney | Application Database Development | Introduction to Indexes and SARGability |
| 15:15:00 | Adam Saxton | BI Platform Architecture, Development Administration | Using a gateway to leverage on-premises data in Power BI |
| 15:15:00 | Frank Gill | Enterprise Database Administration Deployment | Using Powershell to Automate Your Restore Strategy |
| 15:15:00 | Rick Lowe | Enterprise Database Administration Deployment | Why Should I Care About ... Partitioned Views? |
| 15:15:00 | Ted Stathakis | BI Platform Architecture, Development Administration | Reporting Services 2016: New Features Smart Migration Strategy |
| 15:15:00 | Matthew Roche | Information Delivery | Getting More from your Data with Azure Data Catalog |
| 15:15:00 | Martin Catherall | Application Database Development | In memory OLTP - what can it do for me? |
| 16:45:00 | Chris Hyde | Analytics and Visualization | SQL Server R Services in SQL 2016 |
| 16:45:00 | Rie Irish | Professional Development | Women in Technology: Identifying and Understanding Gender Bias Inequality |
| 16:45:00 | Martin Cairney | Enterprise Database Administration Deployment | Split, Merge and Eliminate - An Introduction to Partitioning |
| 16:45:00 | Steve Moss | BI Platform Architecture, Development Administration | What You're Missing If You Aren't Using SQL Windowing Functions |
| 16:45:00 | Thomas Grohser | Application Database Development | Security 101 |
| 16:45:00 | Prakash Heda | Enterprise Database Administration Deployment | Consolidated Essential Performance Health Check using PowerShell |
| 16:45:00 | Ben Thul | Application Database Development | Hierarchical Queries |
| 16:45:00 | Jason Horner | BI Information Delivery | Advanced Spatial Analysis Beyond Bubble Charts |
Event Date: 22-10-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
If so, what would you do when you find a trouble-making query? Do you write a request to software developers to tune it?
In SQL Server 2016 you have an option not only monitor worst performing queries, but also decide how they have to be executed in your system. You can look at different query plans and force SQL Server to use the quickest one or one which uses less memory or IO.
During that session we will go through major new features of SQL Server 2016 and nail down the "Query Store".
You will learn about that new SQL Server feature and maybe you find how it would help you in your current production environment.
Event Date: 22-10-2016 - Session time: 08:30:00 - Track: Application Database Development
Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL's performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.
Event Date: 22-10-2016 - Session time: 08:30:00 - Track: Advanced Analysis Techniques
In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.
This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.
Event Date: 22-10-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
Event Date: 22-10-2016 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 22-10-2016 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-10-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-10-2016 - Session time: 08:30:00 - Track: BI Information Delivery
In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and high performance.
Event Date: 22-10-2016 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
Event Date: 22-10-2016 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-10-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-10-2016 - Session time: 10:15: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: 22-10-2016 - Session time: 10:15:00 - Track: BI Information Delivery
We will look at how you can source data from Google Analytics, Facebook, Twitter, LinkedIn and finally from web pages. We will then show how you can work with the data to get some meaningful analysis from it and ask the question: Can you get a holistic view of your online presence?
This is a demo rich session where we will go through getting the data in and looking through how we can extend the model using DAX to get more insight before visualizing the results.
The participants will leave the session with ideas on how they can use Power BI (or indeed some other BI tool) to start analyzing their company#39;s online presence plus the pbix file used in the session with all the code.
Event Date: 22-10-2016 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 22-10-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Temporal tables in SQL Server is a new feature of SQL Server 2016 that will allow you to keep track of previous versions of records. It allows you to go back to specific point in time and display what the data was at that time. it's also known as "Time Travel".
This presentation will go through the requirements, some use cases, technicalities. There will be some demos which will help understanding how the feature works and how to use it.
Event Date: 22-10-2016 - Session time: 10:15:00 - Track: Application Database Development
If your query logic confused the optimizer, or if it had inaccurate statistical knowledge of the data, then prepare for some nasty surprises in the plan, such as expensive scans, sort and join operations that spill to disk, and more. We'll examine common causes of these problems, such as use of 'generic' SQL, parameter sniffing, stale statistics, and misuse of functions. We'll cover techniques that will allow you to locate quickly the execution plans for high-cost queries in the workload, and we'll use some of the new execution plan features in SQL Server 2016 to detect and diagnose more easily the underlying query performance issues.
Event Date: 22-10-2016 - Session time: 12:00:00 - Track: Cloud Application Development Deployment
Event Date: 22-10-2016 - Session time: 12:00:00 - Track: Analytics and Visualization
This is intended as a Bring Your Own Device (BYOD) session, however feel free to attend as an observer if you don’t have your laptop with you.
What is Power BI? Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.
Event Date: 22-10-2016 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration
There is a proliferation of beautiful tools for providing data visualizations and self-service data delivery to business users - but these tools rely on having data available, often in a data warehouse. And building / maintaining the data warehouse is often the lengthy, fraught part of BI projects.
WhereScape RED is an IDE for building and managing data warehouses, marts, stores and vaults. RED supports all common modeling approaches and architectures in an open, flexible and scalable environment. Developers use RED to massively accelerate delivery and documentation of rapid / agile projects without sacrificing control.
Join us for a discussion and demonstration on how you can deliver projects with the business to empower your enterprise with data - leveraging the MS BI Stack!
Event Date: 22-10-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment
So, what about your SQL Objects?
Join me in this demo heavy session where we will explore the benefits of versioning your SQL Objects and learn how it can enable streamlined database development without sacrificing control and visibility. We’ll be using Red Gate’s SQL Source Control tool for demos, and we’ll see how it integrates with your existing version control software to manage your SQL Objects just like application code.
Event Date: 22-10-2016 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-10-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment
With speed like that, there will still be plenty of time to show you: • QoS controls at the instance level • SQL and OS updates as fast as an application stop/start • How this solution can save you 30-60% on licensing costs
Stop slaving over your traditional WSFC environments and learn why Global 500 customers have adopted this profoundly simple, Microsoft certified solution.
Event Date: 22-10-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment
Plus, we’ll explore some of the ways JAMS can integrate SQL processes into cross-platform workflows that extend across numerous business applications and scripts outside the SQL environment.
Event Date: 22-10-2016 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: BI Information Delivery
We will also look at the new SSRS Web Portal (replacement for Report Manager) and how the development environment will change as well. Sometime will also be spent on how to support all of these report types and the impact it will have on IT. If you have been curious about what has changed with SSRS in SQL Server 2016 and you want to be ahead of the curve, this is the session for you!
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
An impressive list of improvements to In-Memory OLTP have changed the original release from a somewhat edge case solution to a practical consideration for an increasingly larger number of scenarios.
In this demo heavy session, we will implement and benchmark three real world use cases for memory optimized objects while showcasing In-Memory OLTP features new to SQL Server 2016.
Many presentations, books, and deep dives describe the internals of In-Memory OLTP objects. The focus of this course is real world implementation and best practice.
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: Application Database Development
Here we will explore these two new tools that have been added to our toolbox of SQL Server security. Looking to understand what the features are, and how they work. More importantly, we will look at the use cases for these features. When they are, and are not appropriate. Finally looking at how we can incorporate them into the systems that we are building, and whether we can design them into our existing systems.
Understanding the capabilities that we have available is important, as the threats change so must the technology and our approach. By the end of this session, you will be in a position to decide if these capabilities will help you secure the data you manage.
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.
In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.
Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: Analytics and Visualization
Event Date: 22-10-2016 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Event Date: 22-10-2016 - Session time: 15:15:00 - Track: Application Database Development
Event Date: 22-10-2016 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-10-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-10-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 22-10-2016 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
We will then dive into how to use a custom report, based on the ReportServer database transaction log table, to see which reports are actually being used and use that report to determine a smart strategy for which reports to migrate to a new 2016 installation. You will see how to combine this understanding of active reports with the power of linked reports to simplify your Reporting Services implementation as you convert to SQL Server 2016. The session will conclude with a look at my “Ultimate Footer”, which you can use on any version of Reporting Services, that shows report utilization, performance details, stored procedures and data sets used and discover any inline TSQL being abused.
Event Date: 22-10-2016 - Session time: 15:15:00 - Track: Information Delivery
If you want the data you produce to have more impact, or you want to spend less time looking for the right data to use, please join us for this interactive session. We will cover the capabilities of the Azure Data Catalog, common scenarios for its use, and information about how to get started putting Data Catalog to work for you.
Event Date: 22-10-2016 - Session time: 15:15:00 - Track: Application Database Development
It was still really useful – as long as your use case suited the limitations. SQL Server 2016 removes several of these limitations and widens the use cases of in-memory OLTP. For example, even if you are not taking advantage of in-memory tables, you can probably leverage performance improvements by replacing traditional table variables and both local and global temporary tables with in memory implementations. Now you’ll be able to say that table variable is truly in memory! Come along to this session and learn about some of features of in memory OLTP - or Hekaton as a lot of people refer to this - and how you may be able to leverage these high performance features in both new and existing applications.
Event Date: 22-10-2016 - Session time: 16:45:00 - Track: Analytics and Visualization
Event Date: 22-10-2016 - Session time: 16:45:00 - Track: Professional Development
Event Date: 22-10-2016 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment
In this session we'll cover the basics of partitioning - from getting started with partition switching to partition elimination to make your queries go faster - with plenty of demos for you to take away.
Event Date: 22-10-2016 - Session time: 16:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 22-10-2016 - Session time: 16:45:00 - Track: Application Database Development
Event Date: 22-10-2016 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment
First part of the email shares some key observations about SQL Server performance which can be the key to quick resolution of the issue. Rest of the email shows different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance which could lead to the slowness observed in the application. This consolidated email can be shared with technical stakeholders to give a snaps
Event Date: 22-10-2016 - Session time: 16:45:00 - Track: Application Database Development
Event Date: 22-10-2016 - Session time: 16:45:00 - Track: BI Information Delivery