Build Schedule

Advanced Filters:
  • Track

    clear all
















  • Speaker


  • Level


  • Session Type



Sessions Found: 27
2,4,8 & 16 - these aren't just numbers to count or calculate. These are years that how SQL Server evolved as number of years!

Why Upgrade? 
Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe & India) and SQLbits since 2008. 

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading  SQL Server (2000 to  2012),  SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources. 

What to-do and what not-to-do?

A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday & SQLbits UK.
We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why & how such a solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: September 17

Time: 2:45 PM - 3:45 PM

Room: Room4

Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Calendar and Time
Even when there is a big need from a business perspective, the solutions in relational databases are still sort of awkward. Since Version 2008, SQL Server makes life a bit easier with the data type hierarchyid. If you want to successfully query self-referenced hierarchies, you will need recursive common table expressions. To make use of aggregations, you have to master GROUP BY clauses, as well as GROUPING SETS, CUBE, ROLLUP, WITH CUBE, and WITH ROLLUP.
If these terms caught your attention, then join this session for a journey through best practices to model your hierarchies and handy scripts to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous "Game of Thrones".
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: September 17

Time: 1:30 PM - 2:30 PM

Room: Room3

In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like "What are the typical waiting times in our order process?" are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems. 

In this talk I will show you different techniques and models related to time: process mining, lean, six sigma, process datawarehousing, relational temporal theory and SQL 2016 temporal
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Advanced

Session Code:

Date: September 17

Time: 10:00 AM - 11:00 AM

Room: Room3

In this session we take a look and a deep dive into Aure Data Lake, a new feature on Azure that will enable amost anyone to work with BIG DATA. It combines C# and SQL to a language that is way more intuitive than what we are used to.

Azure Data Lake Store, our new repository for data of various origins – we can collect, store and share data from this lake as we see fit. Azure Data Lake Analytics, a new way to scale and use your analytics on AZURE and BIG Data, it introduces U-SQL a new language combined of C# and T-SQL to make the task of analyzing BIG Data easier and more comprehendible. Azure Data Lake Tools for Visual Studio, provide an integrated development environment that spans the Azure Data Lake, dramatically simplifying authoring, debugging and optimization for processing and analytics at any scale. After this session, you will have an understanding of the new feature, and will hopefully be inspired to use it either in a Proof Of Concept or in a Production scenario. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
IoT/AA/Cloud

Level: Intermedia

Session Code:

Date: September 17

Time: 8:30 AM - 9:30 AM

Room: Room3

In this session I will demonstrate how to use M (Power Query) to Extract, Transform and Load data into your data model.

The M language is not yet available in SSIS, but there are already power shell scripts that can perform the load to your database. I will walk through the steps in a simple ETL process and explain some of the quick wins when using the transformations, lookup, variable and parameter functions that M provides compared to standard SSIS and how to create your own functions. We will finish the session with a demo on how to load data from your tables to your SQL database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: September 17

Time: 11:15 AM - 12:15 PM

Room: Room1

Azure Stream Analytics targets complex event streams (CEP’s) to deduce meaningful patterns. Most of the typical use cases for this product is when various devices and sensors are sending data for further processing.

This technology uses a T-SQL like syntax to express its intents. A language that most data-power users will be familiar with.

The biggest advantage of Stream Analytics is when events are being published to the Stream Analytics, the only thing that event publishers needs to know is which Event Bus or Blob storage to place the data. Stream Analytics will then fetch the data.

This talk is about the main concepts and solution architecture when using Azure Stream Analytics, and also how to use this technology together with MS SQL Server, Azure SQL Database and Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
IoT/AA/Cloud

Level: Intermedia

Session Code:

Date: September 17

Time: 11:15 AM - 12:15 PM

Room: Room2

SQL Server Data Tools (SSDT) is Microsoft developer tools for working with SQL Server databases on premises and in the cloud. It supersedes Management Studio in development functionality. Team Foundation Server (TFS) is the collaboration platform at the core of Microsoft’s application lifecycle management (ALM) solution. TFS gives you the tools you need to effectively manage software development projects throughout the IT lifecycle. In this session, we are going to focus on the interaction between SSDT and TFS. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will look at how we can do continuous integration between development and other environments pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solution. Furthermore we'll look at how to lift the integration to an even greater level by using Microsoft Release Management thus automating the deployment and testing of your software.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 17

Time: 10:00 AM - 11:00 AM

Room: Room2

You probably know that with a stored procedure you can permit users to access or update data even if they have no direct permissions on the table. But you may have noticed that this does not work when the SP uses dynamic SQL. 

In this session you will learn why it is so and techniques how you can use to overcome this. You will also learn that the same techniques can be to permit users to perform specific actions they need to do without granting them general high-level permissions on database or server level by packaging these actions into a stored procedure. You will also learn why should should be careful with setting a database TRUSTWORTHY.

The session should be of interest both to DBAs and application developers that need to consider advanced permissions in their stored procedures.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: September 17

Time: 10:00 AM - 11:00 AM

Room: Room4

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:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: September 17

Time: 2:45 PM - 3:45 PM

Room: Room2

The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affects everybody on that instance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: September 17

Time: 8:30 AM - 9:30 AM

Room: Room4

The session begins with „JSON“ and shows with a syntax-comparison the similarities to XML.
Both the different operational scenarios and the technical background
of JSON and XML, however, require a different range of functions and language.
Therefore, initially, as far as practicable the parallels will be demonstrated.
Especially the T-SQL  extensions  „FOR JSON“  and  „OpenJSON“  are very similarly implemented in comparison to „FOR XML“ and „OpenXML“.
Furthermore the new functions  „IsJSON“,  „JSON_VALUE“ and  „JSON_QUERY“  are now contained in T-SQL. Do they also have these as T-SQL functions for XML or can these results be calculated with XML-methods?
Additionally, XML has some more features which concern saving ( and indexing ) and requesting 
(in particular with XQuery) in relational tables. These will also be demonstrated exemplary. 
The goal of the session is to show, when which language is of advantage in which case.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: September 17

Time: 8:30 AM - 9:30 AM

Room: Room1

You know locking and blocking very well in SQL Server? You know how the isolation level influences locking? Perfect! Join me in this session to make a further deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks. We will cover the differences between both, and their use-cases in SQL Server. You will learn about best practices how to analyze and resolve Latch- and Spinlock contentation for your performance critical workload. At the end we will talk about lock free data structures, what they are, and how they are used by the new In-Memory OLTP technology that is part of SQL Server 2014.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: September 17

Time: 1:30 PM - 3:00 PM

Room: Room2

Managing Execution Plans - By Hugo Kornelis
An execution plan is in many ways similar to an organisation. And the operators are like the employees, trying hard (and sometimes even succeeeding) to work together effectively. Managing people, or execution plans, is easier if you know their idiosyncrasies. In this lightning talk, I will highlight a few of my favorite empl... eehrmm, operators; and tell you what you need to know in order to manage them effectively. 

Do you Trust Me? - By John Martin
Let me show you why you really ought not to trust those databases and what you can do if you need to.

BI Bullocks Bingo - By Jens Vestergaard
"This session will be hosted around a Quiz, where everyone attending will be able to participate, learn and most importantly have fun while doing so.

The Categories of the Quiz are:
Analysis Services
Data Warehousing
SQL Server RDBMS
Integration Services 

The session is intended to highlight misconceptions surrounding typical Business In
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Lightning Talk

Level: Beginner

Session Code:

Date: September 17

Time: 1:30 PM - 2:30 PM

Room: Room5

ML service is Microsoft Azure drag and drop tool for building,testing and deploying any kind of predictive model on your data-set. Finalized solution is published and used by daily business in larger stack of your Microsoft Azure services. With easy and interactive creation of models, algorithms and decisions do not tend to be that simple! Especially when one has to make business decision on results.
Focus on this session will be mathematical and graphical explanation of algorithms available for predictive analytics in Azure ML service. Algorithms - grouped by learning type - will be examined and crossed referenced through all available and ready-to-use. Understanding the the basics - data inference, data splitting, data stratification, to sweeping, SMOTH, to logic and theory of algorithms:  regression, decision trees/forest/jungle, Clustering and Naive Bayes.

This session will clarify the confusion over algorithms, which data is suitable for which algorithm and what problem.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
IoT/AA/Cloud

Level: Advanced

Session Code:

Date: September 17

Time: 4:00 PM - 5:00 PM

Room: Room3

An execution plan is in many ways similar to an organisation. And the operators are like the employees, trying hard (and sometimes even succeeeding) to work together effectively. Managing people, or execution plans, is easier if you know their idiosyncrasies. In this lightning talk, I will highlight a few of my favorite empl... eehrmm, operators; and tell you what you need to know in order to manage them effectively. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: September 17

Time: 10:00 AM - 10:15 AM

Room: Room1

In this session we will cover end-to-end the creation of an IoT solution using Azure IoT Hub,
monitoring a (virtual) production line.
We will cover the concept of field gateways and talk about how to build a solution that is both fail-safe and can bring sensor processing close to the actual manufactoring, while still utilizing the massive power that the cloud can offer.
Expect a level 400 session with a lot of demos and code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
IoT/AA/Cloud

Level: Advanced

Session Code:

Date: September 17

Time: 10:00 AM - 11:00 AM

Room: Room5

You created your dashboards in Power BI. Now it's time to share them with your colleagues or to deliver to company's workforce.
How can you achieve your purpose? There are different ways in Power BI to spread your work. 
Are you an invidual wishing to share datasets and report with your coworkers? Then you need a group.
Are you a company aims to broadcast contents to every employee? Then you need an organizational content pack. 
In this session will scroll across all the collaborative and delivering features of Power BI to find the the right solution that match your needs.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: September 17

Time: 11:15 AM - 12:15 PM

Room: Room4

This session will be an introduction on the Query Store feature in SQL Server 2016, the SQL Server DBA's new bacon when it comes to Query Performance Tuning. We will show you how to use Query Store in a demo-filled presentation!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: September 17

Time: 2:45 PM - 3:45 PM

Room: Room5

Availability Group was first introduced in SQL Server 2012 with many feature limitations. In SQL2016, a lot of this feature limitations was removed besides performance improvement. In this session, you will see a lot of demos of SQL Server 2016 Availability Group improvements. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: September 17

Time: 11:15 AM - 12:15 PM

Room: Room5

The transaction log is the most important aspect of a SQL Server database. Separating the data and log files is usually good advice, but there is so much more about the transaction log that is misunderstood. Join Microsoft Premier Field Engineer Tim Chapman as he discusses data modification internals, write-ahead logging and the inner workings of the SQL Server transaction log. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: September 17

Time: 4:00 PM - 5:00 PM

Room: Room2

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