Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type




Sessions Found: 41
If you have been working with SQL Server for a while now, you probably already know the basics of reading execution plans.  You know what most of the common operators do, at least in outline, and you know some of the things to look out for and correct. Even so, you still encounter plans from time to time that contain mysterious elements, or which just do not make complete sense to you.

There is always more to know about query plans and the execution engine, but this session will help take your query analysis skills on to the next level. We will look at some of the less well-known operators and plan properties, then explore advanced plan sub-tree shapes and the T-SQL constructions they are most often associated with. Becoming familiar with these details will enable you to write T-SQL that targets a more optimal execution plan.
Speaker:

Session Type:
Regular Session

Track:
F1 - The Performance

Level: Advanced

Session Code:

Date: May 16

Time: 10:15 AM - 11:15 AM

Room: F1 - The Performance

Agile methodologies are widely used in the dev world and are becoming increasingly adopted in the database world. But what about BI? 
Covering the technology and process sides of enabling agile BI, this session is designed to give you practical tips to get things moving more quickly for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Agile & Cloud

Level: Beginner

Session Code:

Date: May 16

Time: 9:00 AM - 10:00 AM

Room: Agile & Cloud

The main goal of this session is to talk about some of architectures that I've been working on and how complex they could be, based on the different requirements that each solution needs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: May 16

Time: 2:00 PM - 3:00 PM

Room: DBA

Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. Free statistical package / language R is also useful for the text mining tasks. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with the tools mentioned.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: May 16

Time: 3:45 PM - 4:45 PM

Room: Business Intelligence

Since SQL Server 2012, Analysis Services has two different modeling approaches for data analysis: Multidimensional and Tabular. Despite having the same purpose and very similar features between them, you can actually get a lot of benefits by choosing the model that best fits your project requirements. To help you on this big decision, we will compare their features, modeling experience, server requirements, processing and querying performance, and so on, by using a real scenario.
Speaker:

Session Type:
Regular Session

Track:
Analytics & NonRelational

Level: Intermedia

Session Code:

Date: May 16

Time: 9:00 AM - 10:00 AM

Room: Analytics & NonRelational

By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask.
Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts
 This session will show you how :
• Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account.
• Create a storage account and container for the HDInsight Cluster.
• Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly.
• The HDInsight cluster is provisioned and configured for access to the sample data.
• A partitioned Hive table is created over top of the sample data 
• Exploration of the result
• And how to automate these task either in Powershell or SSIS.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Hands-On Labs

Level: Intermedia

Session Code:

Date: May 16

Time: 10:15 AM - 11:15 AM

Room: Hands-On Lab

For a long time people have been asking where is SSIS for the cloud.  Truth is it was never going to happen.  Azure Data Factory has been designed from the ground up.  It is designed for moving data at scale and with agility.  Come to this session to learn about this new service and how it come provide value to your business processes
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Agile & Cloud

Level: Beginner

Session Code:

Date: May 16

Time: 10:15 AM - 11:15 AM

Room: Agile & Cloud

Operational Analytics & In-Memory Analytics are the 2 new amazing options that Microsoft is offering in the upcoming SQL Server 2016. 
Build up Columnstore Analytics over your existing OLTP Clustered Table with a new updatable Nonclustered Columnstore Index, or use the In-Memory Updatable Nonclustered Columnstore Index over the InMemory OLTP Tables.
Discover what features of manageability and monitoring are being added to the SQL Server 2016.
This session will be delivering an overview of what is new and how it is going to change the landscape of OLTP & OLAP.
Speaker:

Session Type:
Regular Session

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: May 16

Time: 9:00 AM - 10:00 AM

Room: SQL Server 2016

The era of Data Intelligence: from Amazon famous basket analysis to Netflix "House of Cards" series, advanced healthcare analytics or even the quantified self, this session will focus on stories of useful data. All around the world, companies and individuals are using data to drive business decisions and operations, improve customer satisfaction, boost innovation, maximize learning or even predict the future. We will look into these "data stories" and explore common patterns for useful data, including big data, data visualization, data mining and...yes... statistics. :)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Agile & Cloud

Level: Beginner

Session Code:

Date: May 16

Time: 2:00 PM - 3:00 PM

Room: Agile & Cloud

Deep dive into the DMG and the hybrid architecture involved by Power BI.
How does it work ? Security, Firewall, Certificates,  Multiple gateways, Admin delegation, Scale out, Disaster Recovery.... All that topics will be covered during that technical session.
Speaker:

Session Type:
Regular Session

Track:
Agile & Cloud

Level: Advanced

Session Code:

Date: May 16

Time: 12:15 PM - 1:15 PM

Room: Agile & Cloud

DAX is  a powerful tool to get insights form data real quickly. This session describes the scope of Data Analysis Expressions and how to get real value from BI with simple and corporate tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: May 16

Time: 2:00 PM - 3:00 PM

Room: Business Intelligence

Extended Events is the profiler tool replacement, it is the premium tool for capturing diagnostic information for SQL Server, with advanced capabilities unlike we've had available before, using new features can take time to learn

This session is focused to make you Effective with Extended Events, find out how to be up and running with using EE in just minutes not hours or days, join us to take a look what EE can do and discover what's happening inside your SQL Servers in ways no possible before
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Hands-On Labs

Level: Intermedia

Session Code:

Date: May 16

Time: 12:15 PM - 1:15 PM

Room: Hands-On Lab

Deriving value from your data can be hard even when the data is stood still.  Trying to get insight from your data when it is constantly changing and moving is even more challenging.  Being able to derive business value from your data as soon as the data is produced can offer real actionable insight.  Imagine being able to action telemetry data coming from machines in your factory or being able to post trades by looking at real time market positions.
 
This session is going to look at a couple of ways to do real time analysis on your streaming data.  We will capture the data, perform analysis on the data and also look at visualizing the data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Agile & Cloud

Level: Intermedia

Session Code:

Date: May 16

Time: 3:45 PM - 4:45 PM

Room: Agile & Cloud

SQL Server is (sadly) not an open source product, so we cannot simply download the source code from microsoft.com to see exactly how it works internally. However, Microsoft do helpfully provide public debugging symbols for every released version (including service packs and cumulative updates).

The public symbols only list module and method names, not every line of code, but the exposed names are sufficiently descriptive that the patient symbols-equipped explorer can gain some useful insights to the way SQL Server works at a very low level of detail.

This demo-heavy session will use the WinDbg debugger from the Debugging Tools for Windows to explore how the SQL Server Query Processor interacts with the Storage Engine to run execution plans. You will see how execution plans run left to right, row-by-row, and see a number of interesting internal details of the complex implementation that lies behind the apparent simplicity of graphical execution plans.
Speaker:

Session Type:
Regular Session

Track:
F1 - The Performance

Level: Advanced

Session Code:

Date: May 16

Time: 3:45 PM - 4:45 PM

Room: F1 - The Performance

One of the most popular uses of Data Mining is fraud detection. Card issuers, banks, insurances and other financial institutes are always interested to detect frauds in advance, before customers do. In this session, we are going to discuss how to implement a fraud detection solution. You will learn how to prepare data, which algorithms to use, and how to measure results. The session is based on real-life successful projects.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: May 16

Time: 10:15 AM - 11:15 AM

Room: Business Intelligence

Do you understand your database's secret sauce?
Does your database deployment favor complexity over simplicity?
Which strategy is best?

In this session we will discuss how to take a poorly performing database and substantially improve it's transactional throughput using lessons learnt from real-world customer deployments and common mistakes found in the field.
This session will delve into Indexing does and don't, transactional consistency and concurrency problems (with resolutions) and SQL Server and database configuration best practices.

Should you prefer Francesinha to Bacalhau? Let's find out...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
F1 - The Performance

Level: Intermedia

Session Code:

Date: May 16

Time: 12:15 PM - 1:15 PM

Room: F1 - The Performance

MDS makes the administration and maintenance of your master data quite easy and comfortable. But how is the effect on your business interfaces? This session will present demos of how the changes to your master data will effect your cube and reports - and how quick they can be available to your business users.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: May 16

Time: 9:00 AM - 10:00 AM

Room: Business Intelligence

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; Always Encrypted.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Server 2016

Level: Beginner

Session Code:

Date: May 16

Time: 12:15 PM - 1:15 PM

Room: SQL Server 2016

Join me on this session to listen about the improvements in SQL Server 2014 on operations that have become possible to be made online, such as "rebuild" a single partition on partitioned objects and priority management on "locks" in DDL operations, for example on "switch partition" operations, reducing the operating time of such maintenance and causing the least possible impact on the normal functioning of our database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: May 16

Time: 9:00 AM - 10:00 AM

Room: DBA

After its debut, in SQL Server 2014, the in-memory OLTP technology, also known as Hekaton, brought a new option to improve that very critical database, something that we were always waiting for. However, some limitations were disencouraging its implementation. Your problems are over! Join this session and discover what SQL Server 2016 is bringing to us, in order to make "The Faster" more "Simpler".
Speaker:

Session Type:
75 2 (75 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 16

Time: 2:00 PM - 3:15 PM

Room: SQL Server 2016

Sessions Found: 41
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids