Data Driven

New York City

SQL Server builds in more

It’s time to get more from your data platform—more built-in features with SQL Server 2016, more flexibility with SQL Server on Linux, and more special offers.

Videos on demand

AlwaysOn Availability Groups is extremely popular in enterprise deployments where availability is critical to the success of the application. Learn about the advances being made in SQL Server 2016 to unblock even more scenarios and increase performance.
AlwaysOn Availability Groups enhancements in SQL Server 2016

AlwaysOn Availability Groups is extremely popular in enterprise deployments where availability is critical to the success of the application. Learn about the advances being made in SQL Server 2016 to unblock even more scenarios and increase performance.

PRESENTED BY: Kevin Farlee

To satisfy compliance standards, internal regulations, or basic security principles, applications often need to limit a user's access to only certain rows of data in a database. Learn how Row-Level Security in SQL Server 2016 helps you maintain a consistent data access policy and reduce the risk of accidental data leakage.
Row-Level Security (RLS) in SQL Server 2016

To satisfy compliance standards, internal regulations, or basic security principles, applications often need to limit a user's access to only certain rows of data in a database. Learn how Row-Level Security in SQL Server 2016 helps you maintain a consistent data access policy and reduce the risk of accidental data leakage.

PRESENTED BY: Tommy Mullaney

Learn about in-memory analytics using columnstore index. Significantly speed up analytics queries while reducing the storage footprint of your tables with NO changes to your application.
Speeding up analytics with in-memory columnstore index

Learn about in-memory analytics using columnstore index. Significantly speed up analytics queries while reducing the storage footprint of your tables with NO changes to your application.

PRESENTED BY: Sunil Agarwal

SQL Server R Services is a new feature in SQL Server 2016 allowing you to build smart, predictive applications and extract insights from your SQL Server data using the highly popular open source R language. Learn how to execute and deploy advanced analytics at scale while keeping the data in the database.
R Services in SQL Server 2016

SQL Server R Services is a new feature in SQL Server 2016 allowing you to build smart, predictive applications and extract insights from your SQL Server data using the highly popular open source R language. Learn how to execute and deploy advanced analytics at scale while keeping the data in the database.

PRESENTED BY: Umachandar Jayachandran and Dotan Elharrar

In-memory OLTP delivers performance improvements up to 30X for transactional workloads in SQL Server and Azure SQL DB. Learn how enhancements made in SQL Server 2016 make it easier to use and adopt in your applications, and improve performance and increase scalability even further.
In-memory OLTP in SQL Server 2016

In-memory OLTP delivers performance improvements up to 30X for transactional workloads in SQL Server and Azure SQL DB. Learn how enhancements made in SQL Server 2016 make it easier to use and adopt in your applications, and improve performance and increase scalability even further.

PRESENTED BY: Jos de Bruijn

To gain insights from both your Hadoop data and relational data stored in SQL Server, you often need to transform and move data from one environment to the other. Learn how PolyBase lets you query HDFS using T-SQL directly from SQL Server 2016.
PolyBase: Gaining insights from semi-structured data from HDFS and relational data in SQL Server 2016

To gain insights from both your Hadoop data and relational data stored in SQL Server, you often need to transform and move data from one environment to the other. Learn how PolyBase lets you query HDFS using T-SQL directly from SQL Server 2016.

PRESENTED BY: Casey Karst

Database query performance is a mission-critical aspect of any solution. Traditionally, troubleshooting query performance can be quite time consuming. With the Query Store, introduced in SQL Server 2016, database administrators and developers gain a simple tool to help troubleshoot, understand, and rectify poor-performing queries. Not only can you resolve temporary query performance issues, but also analyze query performance and workload patterns across an extended period of time, as well as remove the risk from upgrades.
SQL Server 2016 Query Store: simplifying query performance troubleshooting

Database query performance is a mission-critical aspect of any solution. Traditionally, troubleshooting query performance can be quite time consuming. With the Query Store, introduced in SQL Server 2016, database administrators and developers gain a simple tool to help troubleshoot, understand, and rectify poor-performing queries. Not only can you resolve temporary query performance issues, but also analyze query performance and workload patterns across an extended period of time, as well as remove the risk from upgrades.

PRESENTED BY: Mike Weiner

In this session you'll learn about how Microsoft IT, Microsoft Development, and SAP Development teams collaborate to test new SQL Server releases within the Microsoft SAP landscape. You'll also learn how Microsoft IT uses SAP and SQL Server 2016 features today, and highlight different test results conducted confirming the ability of SQL Server to handle mission-critical workloads.
How Microsoft uses SAP on SQL 2016

In this session you'll learn about how Microsoft IT, Microsoft Development, and SAP Development teams collaborate to test new SQL Server releases within the Microsoft SAP landscape. You'll also learn how Microsoft IT uses SAP and SQL Server 2016 features today, and highlight different test results conducted confirming the ability of SQL Server to handle mission-critical workloads.

PRESENTED BY: Juergen Thomas

Business requirements or industry and legal regulations require you to keep data for extended periods? Is your database growing to unmanageable sizes? Do storage costs dominate your IT budget? Learn how SQL Server Stretch Database allows you to keep as much data as you want while reducing maintenance efforts and overall costs without changing your application.
SQL Server Stretch Database: securely and transparently use infinite storage and compute capacity in Azure

Business requirements or industry and legal regulations require you to keep data for extended periods? Is your database growing to unmanageable sizes? Do storage costs dominate your IT budget? Learn how SQL Server Stretch Database allows you to keep as much data as you want while reducing maintenance efforts and overall costs without changing your application.

PRESENTED BY: Joe Yong

Most data breaches involve the theft of critical data such as credit card numbers or personally identifiable information (PII). In this session, you will learn how Always Encrypted in SQL Server 2016 helps protect such sensitive data inside a database.
Keeping sensitive data secure with Always Encrypted

Most data breaches involve the theft of critical data such as credit card numbers or personally identifiable information (PII). In this session, you will learn how Always Encrypted in SQL Server 2016 helps protect such sensitive data inside a database.

PRESENTED BY: Jakub Szymaszek

Sensitive data or personally identifiable information (PII) stored in a database often needs to be obfuscated, so that it's only available to specific people on a need-to-know basis. Learn how Dynamic Data Masking in SQL Server 2016 helps you limit access to sensitive data fields easily and without requiring any changes to your application code.
Dynamic Data Masking in SQL Server 2016

Sensitive data or personally identifiable information (PII) stored in a database often needs to be obfuscated, so that it's only available to specific people on a need-to-know basis. Learn how Dynamic Data Masking in SQL Server 2016 helps you limit access to sensitive data fields easily and without requiring any changes to your application code.

PRESENTED BY: Tommy Mullaney

Get a brief overview of the new SQL Server 2016 Upgrade Advisor and SQL Server Migration Assistant 7.0. Explore the new assessment and migration features that support SQL Server 2016 upgrades and foreign platform migrations.
Upgrade and migration to SQL Server 2016

Get a brief overview of the new SQL Server 2016 Upgrade Advisor and SQL Server Migration Assistant 7.0. Explore the new assessment and migration features that support SQL Server 2016 upgrades and foreign platform migrations.

PRESENTED BY: Lonny Bastein

Get a brief overview of new investments in SQL Server Management Studio and SQL Server Data Tools coming in SQL Server 2016.  Ken and Kevin will highlight topics such as new monthly updates, query analysis improvements, wizard and dashboard support for Standard Edition Availability Groups, the connection experience in SSDT, and developer productivity improvements.
Tooling improvements in SQL Server 2016

Get a brief overview of new investments in SQL Server Management Studio and SQL Server Data Tools coming in SQL Server 2016. Ken and Kevin will highlight topics such as new monthly updates, query analysis improvements, wizard and dashboard support for Standard Edition Availability Groups, the connection experience in SSDT, and developer productivity improvements.

PRESENTED BY: Ken Van Hyning

Temporal support in SQL Server 2016 lets you easily keep the entire history of changes in your tables, go back to any point in time in history, and run interesting analyses. See how easily you can use temporal tables in SQL Server 2016.
Effortlessly analyze data history using temporal

Temporal support in SQL Server 2016 lets you easily keep the entire history of changes in your tables, go back to any point in time in history, and run interesting analyses. See how easily you can use temporal tables in SQL Server 2016.

PRESENTED BY: Jovan Popovic

In this session, we'll review the new KPI functionality in Reporting Services, which enables rapid publishing of key metrics in a way that guarantees premium native-user experiences on all devices and screen form factors.
Monitor critical business metrics and trends at a glance with KPIs

In this session, we'll review the new KPI functionality in Reporting Services, which enables rapid publishing of key metrics in a way that guarantees premium native-user experiences on all devices and screen form factors.

PRESENTED BY: Christopher Finlan

In this session, we'll look at the updates to the Analysis Services semantic model, which now adds support for many to many patterns, translations, and adds over 50 new DAX functions.
SSAS tabular semantic model updates for SQL Server 2016

In this session, we'll look at the updates to the Analysis Services semantic model, which now adds support for many to many patterns, translations, and adds over 50 new DAX functions.

PRESENTED BY: Kasper de Jonge

Real-time Operational Analytics in SQL Server 2016 combines two industry leading SQL Server technologies: in-memory OLTP and in-memory analytics using columnstore index. By enabling the creation of columnstore indexes directly on transactional tables, it eliminates the need for a separate data warehouse and data movement to considerably reduce the total cost of ownership. Your transactional workload can continue to run with no or minimal performance impact while colunmstore index can speed up your analytics significantly.
Real-time Operational Analytics with SQL Server 2016

Real-time Operational Analytics in SQL Server 2016 combines two industry leading SQL Server technologies: in-memory OLTP and in-memory analytics using columnstore index. By enabling the creation of columnstore indexes directly on transactional tables, it eliminates the need for a separate data warehouse and data movement to considerably reduce the total cost of ownership. Your transactional workload can continue to run with no or minimal performance impact while colunmstore index can speed up your analytics significantly.

PRESENTED BY: Sunil Agarwal

Learn about updates to the SQL Server Analysis Services (SSAS) DirectQuery and build a semantic model over your data for consistency across reporting and analysis without storing any data in Analysis Services itself. The new updates enable direct access to data without storing or caching aggregates in Analysis Services at performance enhancements up to 20 times faster than in previous versions of SSAS.
Analysis Services DirectQuery for tabular models

Learn about updates to the SQL Server Analysis Services (SSAS) DirectQuery and build a semantic model over your data for consistency across reporting and analysis without storing any data in Analysis Services itself. The new updates enable direct access to data without storing or caching aggregates in Analysis Services at performance enhancements up to 20 times faster than in previous versions of SSAS.

PRESENTED BY: Kasper de Jonge

In this session, we'll review how to create Mobile Reports, which are new in SQL Server 2016 Reporting Services. The new Mobile Report Publisher is so simple to use that anyone—even a user with minimal technical skills—can create effective mobile reports that scale perfectly to all screen form factors, including phones, tablets, and modern web browsers.
Design mobile reports in SQL Server Mobile Report Publisher

In this session, we'll review how to create Mobile Reports, which are new in SQL Server 2016 Reporting Services. The new Mobile Report Publisher is so simple to use that anyone—even a user with minimal technical skills—can create effective mobile reports that scale perfectly to all screen form factors, including phones, tablets, and modern web browsers.

PRESENTED BY: Christopher Finlan

See how SQL Server 2016 Reporting Services lets you access both traditional paginated reports and new mobile reports using modern browsers and mobile devices thanks to a brand-new web portal and Power BI mobile apps.
Create shared data sources and datasets for your reports

See how SQL Server 2016 Reporting Services lets you access both traditional paginated reports and new mobile reports using modern browsers and mobile devices thanks to a brand-new web portal and Power BI mobile apps.

PRESENTED BY: Riccardo Muti

New JSON functions in SQL Server 2016 let you easily load JSON text in tables, query both standard tables and JSON data, or export content of tables as JSON. See how easily you can combine relational and NoSQL concepts in SQL Server 2016.
JSON as a bridge between NoSQL and relational worlds

New JSON functions in SQL Server 2016 let you easily load JSON text in tables, query both standard tables and JSON data, or export content of tables as JSON. See how easily you can combine relational and NoSQL concepts in SQL Server 2016.

PRESENTED BY: Jovan Popovic

With SQL Server 2016 Reporting Services, you'll access both traditional paginated reports and new mobile reports using modern browsers and a brand-new web portal built on HTML5 technology. Plus, learn how to access your KPIs and mobile reports on your smartphone or tablet using the Power BI apps available for all major mobile platforms.
Access reports in modern browsers and mobile devices

With SQL Server 2016 Reporting Services, you'll access both traditional paginated reports and new mobile reports using modern browsers and a brand-new web portal built on HTML5 technology. Plus, learn how to access your KPIs and mobile reports on your smartphone or tablet using the Power BI apps available for all major mobile platforms.

PRESENTED BY: Riccardo Muti

Microsoft R Server is an essential component in SQL Server R Services, a new feature in SQL Server 2016 allowing you to build predictive applications at scale using the popular open-source R language. Here we'll learn about R Server in a nutshell—how it scales your advanced analytics, what functions and algorithms come in the box, what's the difference between in-database R Services and a standalone R Server, and more.
Scaling your advanced analytics in SQL Server 2016 with R Server

Microsoft R Server is an essential component in SQL Server R Services, a new feature in SQL Server 2016 allowing you to build predictive applications at scale using the popular open-source R language. Here we'll learn about R Server in a nutshell—how it scales your advanced analytics, what functions and algorithms come in the box, what's the difference between in-database R Services and a standalone R Server, and more.

PRESENTED BY: Richard Kittler and Bill Jacobs

SQL Server R Services is a new feature in SQL Server 2016 allowing you to build predictive applications at scale using the popular open-source R language. Here you'll experience the end-to-end journey starting with exploring the data and ending with deploying the R scripts and models in production. You'll understand the typical personas involved and their roles, and see some code examples.
Building intelligent applications using SQL Server R services—an end-to-end walkthrough

SQL Server R Services is a new feature in SQL Server 2016 allowing you to build predictive applications at scale using the popular open-source R language. Here you'll experience the end-to-end journey starting with exploring the data and ending with deploying the R scripts and models in production. You'll understand the typical personas involved and their roles, and see some code examples.

PRESENTED BY: Gopi Kumar and Hang Zhang

SQL Server R Services is a new feature in SQL Server 2016 allowing you to build predictive applications at scale using the popular open-source R language. Here you'll learn how R Services can be used to predict machine failures, producing a more cost-effective maintenance model. This is just one example for a variety of smart applications that can be built or enhanced using R Services.
Predictive maintenance with R in SQL Server 2016

SQL Server R Services is a new feature in SQL Server 2016 allowing you to build predictive applications at scale using the popular open-source R language. Here you'll learn how R Services can be used to predict machine failures, producing a more cost-effective maintenance model. This is just one example for a variety of smart applications that can be built or enhanced using R Services.

PRESENTED BY: Xinwei Xue

In this session, you'll get a glimpse of new functionalities included within SQL Server 2016 Integration Services (SSIS). You’ll understand how to define custom logging levels for package executions within the SSIS Catalog and learn about the ssis_logreader role to see the SSIS logs without needing to be a database administrator. Plus, we’ll address certain benefits—from how to capture the exact information you need to the flexibility of roles and reporting—to get deeper insights into SSIS package catalogs.
SSIS Catalog custom logging levels for SQL Server 2016

In this session, you'll get a glimpse of new functionalities included within SQL Server 2016 Integration Services (SSIS). You’ll understand how to define custom logging levels for package executions within the SSIS Catalog and learn about the ssis logreader role to see the SSIS logs without needing to be a database administrator. Plus, we’ll address certain benefits—from how to capture the exact information you need to the flexibility of roles and reporting—to get deeper insights into SSIS package catalogs.

PRESENTED BY: Matt Masson

SQL Server R Services is a new feature in SQL Server 2016 allowing you to build predictive applications at scale using the popular open-source R language. Here we'll cover common questions about this new and exciting capability—how does it scale, what's the high level architecture, how is it secured and governed, is it available in all the editions of SQL Server, and more.
R Services for SQL Server 2016 FAQ

SQL Server R Services is a new feature in SQL Server 2016 allowing you to build predictive applications at scale using the popular open-source R language. Here we'll cover common questions about this new and exciting capability—how does it scale, what's the high level architecture, how is it secured and governed, is it available in all the editions of SQL Server, and more.

PRESENTED BY: Vijay Jayaseelan, Jasraj Dange, Umachandar Jayachandran and Dotan Elharrar

Business models are becoming more reactive in order to adapt to changing market conditions and channel opportunities.  But with the increase in breadth comes an increase of potential fraud, making Microsoft data warehousing capabilities critical in managing large volumes of disparate and relational data and combining it for fast, accurate, and validated information beautifully visualized through Microsoft Power BI and SQL Server 2016 Reporting Services, including Mobile BI.  Be connected to your data anywhere in the world, all with the immersive power and experience of touch.
Fraud analysis using a hybrid implementation of Azure SQL Data Warehouse and SQL Server 2016 Reporting Services

Business models are becoming more reactive in order to adapt to changing market conditions and channel opportunities. But with the increase in breadth comes an increase of potential fraud, making Microsoft data warehousing capabilities critical in managing large volumes of disparate and relational data and combining it for fast, accurate, and validated information beautifully visualized through Microsoft Power BI and SQL Server 2016 Reporting Services, including Mobile BI. Be connected to your data anywhere in the world, all with the immersive power and experience of touch.

PRESENTED BY: Matt Goswell and Sanjay Soni

We've overhauled Reporting Services in SQL Server 2016 to provide a modern, on-premises solution for deploying and managing reports within your organization. Continue to create paginated reports—what you traditionally think of as Reporting Services reports—as you now create mobile reports optimized for smartphones and tablets. We’ll focus on how we’ve modernized and enhanced the paginated reports themselves, as well as the tools you use to design and view them.
Design modern paginated reports

We've overhauled Reporting Services in SQL Server 2016 to provide a modern, on-premises solution for deploying and managing reports within your organization. Continue to create paginated reports—what you traditionally think of as Reporting Services reports—as you now create mobile reports optimized for smartphones and tablets. We’ll focus on how we’ve modernized and enhanced the paginated reports themselves, as well as the tools you use to design and view them.

PRESENTED BY: Riccardo Muti

We'll walk through the various ways to keep your reports and dashboards in Power BI current. If you have on-premises data sources such as SQL server that you have been waiting to refresh from Power BI, this is the session for you.
Hybrid BI: accessing on-premises data with Power BI

We'll walk through the various ways to keep your reports and dashboards in Power BI current. If you have on-premises data sources such as SQL server that you have been waiting to refresh from Power BI, this is the session for you.

PRESENTED BY: Dimah Zaidalkilani

This session discusses why Azure Virtual Machines is the best cloud platform to run SQL Server 2016. It provides an overview of the SQL Server deployment, configuration, management, and monitoring.
Azure Virtual Machines is the best platform for SQL Server 2016

This session discusses why Azure Virtual Machines is the best cloud platform to run SQL Server 2016. It provides an overview of the SQL Server deployment, configuration, management, and monitoring.

PRESENTED BY: Luis Carlos Vargas Herring

Master Data Services is a multi-dimensional platform that allows corporations to manage and curate their master data. This session introduces the new capabilities we’ve introduced with the SQL Server 2016 release, giving insights to how our customers’ feedback from previous releases were addressed and implemented.
Master Data Services 2016

Master Data Services is a multi-dimensional platform that allows corporations to manage and curate their master data. This session introduces the new capabilities we’ve introduced with the SQL Server 2016 release, giving insights to how our customers’ feedback from previous releases were addressed and implemented.

PRESENTED BY: Rama Raman

This demo will show how SQL Server 2016 handles payment card transactions in real time, allows real-time analysis of the transactions, secures the sensitive card holder´s data using Always Encrypted, analyses anomalies in the payments using R integration, and stretches transaction history into Azure with Stretch Database.
Full lifecycle of financial data using SQL Server 2016

This demo will show how SQL Server 2016 handles payment card transactions in real time, allows real-time analysis of the transactions, secures the sensitive card holder´s data using Always Encrypted, analyses anomalies in the payments using R integration, and stretches transaction history into Azure with Stretch Database.

PRESENTED BY: Marko Hotti

Watch this video session for a tour of key features in our new integrated development environment (IDE) for R users and data scientists.
R Tools for Visual Studio

Watch this video session for a tour of key features in our new integrated development environment (IDE) for R users and data scientists.

PRESENTED BY: John Lam