Learning Pathways

Not sure where to start?Explore these planned sessions on the future of SQL Server, Security, and DAX to help get you inspired.

SQL Server - What Does the Future Look Like?

The Roadmap for SQL Server

Amit Banerjee, Asad Khan, Bob Ward
Wednesday, November 7 (10:45 AM - 12:00 PM)
6B
200

SQL Server 2017 has brought to market a new modern data platform including support for Linux, Docker Containers and rich features in intelligent performance, HADR, machine learning, and graph database. Come learn about the roadmap and new functionality planned for SQL Server including intelligent query processing, data virtualization, new features for mission critical security and HADR, and new scenarios for Linux and Docker Containers.

What's New in SQL Server on Linux and Containers

Bob Ward, Vin Yu
Thursday, November 8 (1:30 PM - 2:45 PM)
6B
300

You may have seen SQL Server 2017 now supports Linux and Docker Containers. Come learn in this session new features and plans for SQL Server Futures including replication, Distributed Transactions, Machine Learning Services, Active Directory enhancements, new scenarios for containers and Kubernetes, and performance.

How it Works - Availability Groups with SQL Server on Linux

Sourabh Agarwal
Thursday, November 8 (8:00 AM - 9:15 AM)
612
400

Availability Group deployments with SQL Server on Linux, provide the same experience as SQL Server on Windows, however there are certain aspects of running AG's with Linux Pacemakers, which are different from running AG's on WSFC. In this session we will talk about these subtle differences, in the failover processing, state machines etc., which may/may not have an impact on the overall recovery time objectives. Additionally In this session, we will cover how to troubleshoot AG deployments on Linux and any potential pit-falls once needs to be aware off.

Inside SQL Server with Containers

Bob Ward
Friday, November 9 (2:00 PM - 3:15 PM)
6C
400

Containers are the new virtual machines. Containers present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work and how SQL Server runs in them. Will cover the architecture of containers, how we have built SQL Server to run in containers, and how they work in environments such as Kubernetes. While this is an internal focused session you will walk away with knowledge of practical scenarios where SQL Server in Containers may be the right deployment model for you.

Security

SQL Server Security

Denny Cherry
Monday, November 5 (8:30 AM - 4:30 PM)
6C
200

*Pre-conference Session**

With increased focus on data breaches, security issues and privacy laws, organizations are feeling greater pressure to provide sufficient data protection. GDPR brings substantial fines and potentially criminal prosecution. Are you ready? Are your database systems ready?

SQL DB Security Overview

Jakub Szymaszek, Joachim Hammer, Mirek Sztajno
Wednesday, November 7 (4:45 PM - 6:00 PM)
606
300

In this session we will review frequent questions from customers about how to best secure their data in Azure SQL Database including Azure SQL Managed Instance. We will share learnings and best practices that customers can use to define a security strategy. For example, we will address questions regarding secure client connections, firewall and VNET configurations, use of authentication, encryption and data masking, etc. In the process we will review SQL's latest security features like Advanced Threat Protection, AAD with Multi-factor authentication, Always Encrypted, and Static Data Masking. We will also shed light on how we secure the service internally and what we plan to do in the future to protect our customer data against the evolving threat landscape.

Principle of Least Privilege: The Key to Strong Security

Ed Leighton-Dick
Thursday, November 8 (3:15 PM - 4:30 PM)
6C
300

A truly strong security model starts with no permissions and adds what is necessary to allow the user or application to do their assigned task - no more, no less. This is called the Principle of Least Privilege. It's a simple concept, but it can be quite difficult to implement in practice, especially if the prevailing practice has been much more permissive. In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll discuss ways to implement it for the three primary classes of users - general users, applications, and administrators. Each has their own set of needs that requires a separate approach to allowing the security to meet those needs. You'll leave with actionable ideas on ways that you can improve your company's security while minimizing the impact of the changes.

Prerequisites: Experience configuring SQL Server authentication and authorization

Security Considerations for the Cloud

Eric Peterson
Friday, November 9 (8:00 AM - 9:15 AM)
3AB
300

When deploying your SQL Server environment to the cloud, there is more to worry about than just SQL Server security. Understanding what needs to be implemented outside of SQL Server is just as important as SQL login permissions. When moving to the Cloud, many of the skills that were formerly in the infrastructure group are now a DBA responsibility. Properly setting up access for your cloud infrastructure is now a mandate for your DBA's skill set. Topics like Active Directory, VPN, port restrictions, two-factor authentication, patching policies and encrypting data/backups and much more.

Prerequisites: An understanding of SQL Server login/user/role and credentials. SQL Server installation helpful.

DAX

My Power BI Report is Slow: What Should I Do?

Marco Russo
Wednesday, November 7 (1:30 PM - 2:45 PM)
TCC Tahoma 4
300

You created a wonderful Power BI report, but when you open it you wait too much time. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance? This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response. At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.

Prerequisites: Knowledge of Power BI Desktop

Introduction to DAX

Ike Ellis
Wednesday, November 7 (3:15 PM - 4:30 PM)
6C
100

Many people use Power BI without tapping into the true power of DAX. Some think that DAX is an advanced topic, used only by power users, but anyone can learn DAX. Come to this session to see easy and accessible ways to implement DAX in your work with Power BI. We'll simplify difficult topics like how to use Time Intelligence, CALCULATE, ALL, and FILTER. We'll learn the difference between functions with similar names, so you'll know when and when not to use them.

Understanding Relationships in Power BI

Alberto Ferrari
Thursday, November 8 (10:15 AM - 11:30 AM)
TCC Tahoma 4
300

Relationships are the foundation of any Power BI or Analysis Services Tabular data model with multiple entities. At first sight, this is a trivial concept, especially if one has a knowledge of relational data modeling. However, the ability to create multiple relationships between the same tables and the existence of bidirectional filters increase the complexity of this topic. In this session, we will discover the complexity behind relationships and how they work in complex and potentially ambiguous data models.

Prerequisites: Basic knowledge of DAX and Power BI or AS modeling

Deep Dive in DAX Evaluation Context

Alberto Ferrari
Friday, November 9 (2:00 PM - 3:15 PM)
604
400

Ever struggled with a formula in DAX that does not compute what you want? It's happened to us many times and we know that the problem is always (really: ALWAYS) related to the evaluation context. Filter context, row context, and context transition, are only the starting point of a deep dive in how DAX computes the evaluation context for a formula. During the session, you will see several examples of formulas that lead to unexpected results and learn the unifying theory of evaluation contexts based on expanded tables, filter context operators and blocking semantic. If you are serious about DAX, this session is a real must.

Prerequisites: Basic knowledge of the DAX language is required, since the session goes very deep in explaining all the details of evaluation contexts, very little time is dedicated to the introduction of these concepts, mainly as a reminder

cage-aids
cage-aids
cage-aids
cage-aids