Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 24
One of the most complex areas of SQL Server is the Query Optimizer.
It is the component responsible for turning the logical actions (that are derived from your SQL statements) into physical actions that fetch and process the required data to form your results. Not only does it have to guarantee the correct results (no mean feat when you start to think about it) but it has to do this in a performant way and the route it takes to do this (the output of the optimization process ) is described within the execution plan.

This session will be an introduction to the Optimizer and Execution Plans and take you on a journey to a wider view of the Query Engine.
Once you understand what physical actions are being taken on your logical requests (i.e. your TSQL Statements) then you will be better placed make changes to influence those actions with an end result of a better performing database system.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 01

Time: 5:10 PM - 6:10 PM

Room: Auditorium-1

As organizations see the benefits of the cloud, you may find yourself involved in migration projects which target the move from on-premises SQL Server to the cloud. Are you ready for this?  

In this session, we will compare and contrast different migration strategies. We will cover different ways to migrate your SQL Server database from on-premises to Azure, and how to detect and solve potential migration blockers and issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 01

Time: 10:30 AM - 11:30 AM

Room: Auditorium-3

In this session, I'll show you how to get the most interesting features and tips from the main Microsoft data visualization tools like SSRS, Excel and Power BI. I'll show you what you cannot see in the books and help you create Help full reports with real works examples.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: October 01

Time: 2:00 PM - 3:00 PM

Room: Auditorium-2

OnPrem or on Azure: how can Docker Containers and SQL Server coexist in developing Enterprise grade solutions. Building some sample scenarios using the power of the new Windows 2016 containers and Azure Container Services.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 4:00 PM - 5:00 PM

Room: Auditorium-3

Do you know you can now use R powerful language & thousands of advanced analytics & machine learning packages right in SQL Server 2016? Power BI? or  in AzureML? AzureML Jupyter notebooks?  or even Visual Studio?

Are you a BI Developer? DBA? BI Analyst or a data/analytics lover? Come along, join us in this session as we explore this powerful, sometimes even strange!... language , showing main differences from the typical SQL/BI development. This is a beginner level session to help you with R first steps & challenges.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 01

Time: 5:10 PM - 6:10 PM

Room: Auditorium-2

Your cold data growth is getting out of control, storage consumption is increasing faster than your budget, your end-users won't (or can't) tell you what can delete or truncate, but they demand their cold or archived data always be online and available. Now you have tables so big that you dread re-indexing, and you have to look for ever more creative solutions to manage this data, while still remaining compliant. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. Come find out how you can move your data securely and transparently, free up disc space and reduce your enterprise storage consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Server Stretch database will simplify your journey to the Cloud!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 01

Time: 11:45 AM - 12:45 PM

Room: Auditorium-Magno

Hadoop is the most widely talked data platform in the recent years. Hiding under the term "Big Data", one of the most disruptive data technology has arrived to the mass market in the recent years, allowing everyone to setup a data solution for everyone.
The initial releases of Hadoop  have had huge deficiencies in the terms of work, performance and organisation, but the Hadoop 2.0 has brought the needed changes in the underlying architecture and its steadily becoming more and more interesting as a multi-purpose data platform.

Let us review what Hadoop, Spark, Hive, Pig, Tez, Ambari and others are and how can we get started with this data platform. Let us connect each of the pieces with the corresponding element in the current Microsoft Data Platform offerings to understand how can we be more effective in learning and understanding Hadoop.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 01

Time: 2:00 PM - 3:00 PM

Room: Auditorium-3

Lately Microsoft has been announcing a series of new features in this huge product that is SQL Server, in this session I will talk about the new developments that were made for security purposes, such as Dynamic Data Masking; Row-level security and Always Encrypted.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 2:00 PM - 3:00 PM

Room: Auditorium-1

Do you plan to start monitoring your SQL Server instances soon and asking yourself what should you measure? Are you questioning if your existing monitoring data can detect and alert if a performance problem occurs? Is the data you collected from monitoring enough to pinpoint the cause of your next performance problem?

I have worked with SQL Server as a developer in the Redmond team for more than 12 years and during this time I've investigated countless performance problems. In time I developed a strategy on how to use the performance monitoring data to analyze problems and identify the root cause. This session is going to to show you how I monitor SQL Server, what data do I look for, and how I interpret the collected data to analyze performance issues. Going beside the obvious CPU, Memory and IO counters, I will show you how to identify typical performance issues from monitoring data, all without overwhelming the captured data volume.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 01

Time: 11:45 AM - 12:45 PM

Room: Auditorium-Magno

Sim existem imensos frameworks SSIS, mas no mundo real temos todos tendência a consolidar o conjunto de boas práticas que vamos usando nos projectos, que obtivemos via a experiência acumulada e o que foi partilhado pela comunidade ... por isso nada como pensarmos um pouco sobre o que um framework de integração moderno deverá ter certo ?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 01

Time: 9:00 AM - 10:00 AM

Room: Auditorium-2

Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare?

In this session we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 2:00 PM - 3:00 PM

Room: Auditorium-Magno

The Cloud has earned its place in many companies topology. 
This session focusses on performing SQL Server backups directly pushing that backup files to  Azure Blob storage and highlights considerations with regards to security and testing these backup files for recoverability, and cloud costs involved.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 10:30 AM - 11:30 AM

Room: Auditorium-Magno

The hype is over and scalable systems like Hadoop and Spark are a reality for an ever growing number of companies. Now's the time to use its capabilities for empowering your Data Science & Analytics teams, delivering data products and interactive visualizations. In this session we will talk about a data-driven vision supported by Azure's cloud features, with emphasis on Jupyter Notebooks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 01

Time: 10:30 AM - 11:30 AM

Room: Auditorium-2

Polybase is one of the new features that got released on the new SQL Server 2016 version. It's a pretty useful technology if you want to access and join both relational and non-relational data,  all from within SQL Server. We can run this queries against external data like Hadoop or Azure blob storage with the advantage of the query computation be optimized and managed on our Hadoop cluster.
Attend my session if you want to learn how to take advantage of this technology and where we can use it in real life scenarios. I will also cover installation, configuration and troubleshooting. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 01

Time: 11:45 AM - 12:45 PM

Room: Auditorium-3

Troubleshooting performance issues is one of the most formidable tasks for a DBA to perform, as well as one of the most defying...
The new Query Store feature in SQL Server 2016 is a major enhancement, simplifying both the identification of performance issues and it's resolution.
Throughout a set of 13 demonstrations I'll explain what Query Store is, how you can take advantage of it and also some alerts you should be aware of.
If you're a performance troubleshooter I'm sure you'll like this session!

Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 9:00 AM - 10:30 AM

Room: Auditorium-Magno

In this session we will talk about the Real-Time analytics possibilities with SQL Server 2016. This will be a deep-dive on how this works, and will give you an explanation on the new Columnstore features. We will also talk about the difference between hot & warm data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 01

Time: 11:45 AM - 12:45 PM

Room: Auditorium-1

Road to database automation addresses the challenges of database inclusion in the Application Lifecycle Management (ALM). The set of processes that enables this inclusion is designated as Database Lifecycle Management. DLM is composed by 3 main parts: data management and migration, data monitoring and data recovery. 
In this presentation I will discuss the DLM general concepts, with special emphasis on data management and migration, and present some strategies and tools (source control tools as Mercurial and Git and database migrations management tools as Flyway) that can be used to overcome the database source control phase.
Using automation as key factor to achieve database source control, database continuous integration and database continuous delivery. This session will not only unlock continuous integration and delivery phases but also enable agile practices that allows to mitigate/manage the gap between application and database development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 01

Time: 9:00 AM - 10:00 AM

Room: Auditorium-1

SSMS is one of the main tools that help every person, DBA and/or developers, doing their work everyday.
I will show to you features that you do not even knew that exist and how they can improve your productivity.
Come take a look to SSMS 2016 and understand how it will help you even if you don't have SQL Server 2016 instances.
After this session I hope you have learnt at least one or two features of SSMS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 01

Time: 4:00 PM - 5:00 PM

Room: Auditorium-1

This session will cover how implement a high performance queue via the LMax queuing pattern with both the legacy row store engine and the in-memory OLTP engine. With the aim of squeezing every last ounce of performance out of the database engine, this session will cover database engine internals at a deep level and make use of stack traces and windows performance tool kit. The session will also cover spin locking and principles which will before other types of exacting OLTP workloads. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 01

Time: 4:00 PM - 5:00 PM

Room: Auditorium-Magno

If you are considering to implement an SQL Server AlwaysOn availability group and want to anticipate either some configuration or future operational traps, this session is for you!

We will talk about a range of common and uncommon issues you may face concerning your availability group infrastructures. Then we will explain how to resolve them on the basis of real customer cases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 5:10 PM - 6:10 PM

Room: Auditorium-Magno

Sessions Found: 24
Back to Top