Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 27
Do you hold data on EU citizens? If so GDPR applies to you.

From the 25th May 2018 organisations who fail to implement appropriate technical and organisational measures that ensure and demonstrate that they are compliant will be liable for a fine of €20M or 4% of annual global turnover – whichever is GREATER. Also, prison.

As a professional who works with data it is wise to ensure that you understand GDPR.

DISCLAIMER: I am not a lawyer.

Let me repeat: I AM NOT A LAWYER.

I am not qualified to give legal advice. However, I do know a thing or two about delivering software. In this talk I will bring your attention to the main aspects of GDPR and discuss some of the consequences this has on the use of production data and database lifecycle management (DLM).

I will focus on technical problems that we need to address. You can (and should) hire your own lawyers to provide legal advice.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Beginner

Session Code:

Date: December 09

Time: 9:00 AM - 10:00 AM

Room: P01: DEV

Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Bill of Material
* Calendar and Time
Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 comes now with a different approach: Graph Database. 
Join this session for a journey through best practices 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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Beginner

Session Code:

Date: December 09

Time: 4:00 PM - 5:00 PM

Room: P22: BI/DEV

How do the wait stats show you that you have a locking issue?
This session will show you how to detect and view blocking and lock waits, and understand the cause of it.
An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks.
And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 11:30 AM - 12:30 PM

Room: P01: DEV

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. 

This session takes you behind the basics of Temporal Tables and answers - after a short introduction - the following questions:
- How to handle the change of NULL constraints?
- Can Temporal Tables be renamed and what happens to the System Versioned table?
- What will happen if you change meta data (data length, data type, ...)?
- What happens if you drop a column or add another column to the Temporal Table?
- what about security for the  system versioned table?
- what about calculated columns in the temporal table?
- ...

You are interested in the answers to all the above questions (and more). This session will answer EVERY question about Temporal Tables.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 10:15 AM - 11:15 AM

Room: P01: DEV

ADF provides a managed way to orchestrate the collection, movement and transformation of structured and semi-structured data together. It works both with on-premises and cloud data and it has - of course - a powershell interface, enabling you to manage it without the bling of the Azure portal. But is it useful, is it fast, is it easy and powerful to use ? And most of all is Azure Data Factory  the new SSIS ?
These are some of the questions that might arise, when reading about this new PaaS and that we will answer together in this demo packed session where will we go through orchestration, consumption and administration of data through the ADF pipeline.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: December 09

Time: 11:30 AM - 12:30 PM

Room: P19: BI

The Internet of Things is the new kid on the block offering a wealth of possibilities for data streaming and rich analytics. Using a Raspberry Pi 3 we will take an end to end look at how to interact with the physical world collecting sensor values and feeding that data in real-time into cloud services for manipulation and consumption. This will be a heavily demonstrated session looking at how such an environment can be setup using the Microsoft offerings including; Windows 10 IoT Core, a C# Universal Windows Platform application, an Azure IoT Event Hub, Azure Stream Analytics, Azure SQL DB and Power BI. This is an overview of what’s possible, but showing exactly how to build such a simplified solution with a session which will be 90% demonstrations. In addition, spare Raspberry Pi devices will be available for the audience to pass around and look at. This will hopefully add that level excitement of what hardware is now available and what it can do when setup with Microsoft software.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 2:45 PM - 3:45 PM

Room: P22: BI/DEV

Data is the most valuable asset to any company right now and you can gain a corporate advantage through the insights your data can provide. However, implementing Advanced Analytics can also lead to very....interesting....results.
Remember that algorithm that named paint colors? That's nothing compared to what you are going to witness in this session. From analyzing demonic possession based on selfies, to analyzing how "metal" a song is. In this session, presented by mad data scientists Tomaž Kaštrun and Enrico van de Laar, we will explore all the crazy things that are possible with data science. And who knows? You might even learn a thing or two!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 11:30 AM - 12:30 PM

Room: P22: BI/DEV

With the availability of new Graph Database features in SQL Server 2017 and the new Cosmos DB, Microsoft’s globally-distributed, multi-model database service for managing data at scale, database architects are expected to create and translate data models to non-relational physical database designs.  For decades, data modeling and database design has been focused on the relational model, yet we have all these new features to model for.

In this session, we’ll look at:
Why these features still need data modelsHow to prepare data models, logical and physical, for these target featuresHow these features change the data model/database design processHow tools support these new features (or don’t)How to approach tuning for these non-relational featuresFinally, we end with 10 tips for working with non-relational features while still maintaining data model-driven database design.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA/DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 9:00 AM - 10:00 AM

Room: P20: DBA/DEV

During this session we will be talking about Columnstore Indexes and how to use them. We will be showing you tips & tricks on how to get the performance you want out of Columnstore.
We will show you the concepts on how to efficiently load data to your Columnstore tables, how to get your Columnstore properly created, and some dangers with performance you might face when working with Columnstore Indexes as seen in the field!
After this session things like segment elimination, auto adjust buffer size, Delta Store,... will no longer be a mysterious concept for you & you will be ready to start implementing the different flavors of Columnstore Indexes in your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 9:00 AM - 10:00 AM

Room: P22: BI/DEV

One of the biggest fears most customers have is upgrading to a new release of Microsoft SQL Server and having performance degrade, because of changes in query execution plans. SQL Server 2016 mitigated this risk by the introduction of the Query Store and the ability to easily force execution plans.

In this session, you will learn about the data that the query store captures to identify queries that have regressed. You will learn about patterns for upgrades that allow you to upgrade with minimal impact to user performance. You will see demos of how to identify when a query has regressed in either plan or performance, and you will get some hints for the future of the Query Store with Adaptive Plans in SQL Server 2017.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA/DEV

Level: Beginner

Session Code:

Date: December 09

Time: 4:00 PM - 5:00 PM

Room: P20: DBA/DEV

A common requirement in database applications is that users need a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that isboth maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 2:45 PM - 3:45 PM

Room: P01: DEV

SQL Server 2016 is full of new features and improvements. Some of them are "Killer" features like Query Store, Temporal Tables, R Integration, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2016 have several fantastic features and improvements, which are more hidden from our sight. 

In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA/DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 10:15 AM - 11:15 AM

Room: P20: DBA/DEV

Join PowerShell MVPs Chrissy LeMaire and Rob Sewell as they discuss the newest release of dbatools in-depth. In this session, you'll learn about key Enterprise features, tips & tricks and how you can integrate dbatools into your daily toolset, no matter if you are Dev or Ops.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA/DEV

Level: Intermedia

Session Code:

Date: December 09

Time: 11:30 AM - 12:30 PM

Room: P20: DBA/DEV

Azure SQL Database is becoming more and more easy to use, but migration is still a pain point when planning it. In this session I am going to show you some ways to migrate your existing database to Azure SQL Database and how to achieve the same performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: December 09

Time: 2:45 PM - 3:45 PM

Room: P21: DBA

Recently Microsoft announced capacity based license system, this offering leverages on-premises report publishing. Using this functionality user can now publish reports to Power BI service (Cloud) or Power BI Report Server ( on-premises).

In this session, Prathy will talk about what options are available for On-Premises report publishing. What is Power BI Report Server how is it different from existing SQL Server Reporting Services(SSRS), how licensing works, what are the benefits of Power BI report server and how quickly we can create and deploy Power BI reports to SQL Server Reporting Services Portal / Power BI Report Server portal
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: December 09

Time: 10:15 AM - 11:15 AM

Room: P19: BI

Excel so far had three "official" revolutions. One being the Pivot Table, second one Tables in Excel and the last one obviously Power Pivot. But Power Query (aka Get & Transform aka Data Explorer) trumps them all. This session will show you why this outrageous claim actually makes sense. This will be a full demo session that will prove the title right case by case and should also give you an understanding that if you do not use Power Query in Excel, you are not using Excel at all!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: December 09

Time: 9:00 AM - 10:00 AM

Room: P19: BI

With a rising number of parallel SQL Server Integration Services (SSIS) package executions the resource requirements on the SSIS server can be a limiting factor. In older SQL Server versions, scale-out architectures needed to be implemented by hand and required a lot of manual implementation effort. Beginning with SQL Server 2017, SSIS provides a built-in scale-out functionality for package executions. 
After the definition of scalability-types, the SSIS scale-out architecture and the involved system-parts are introduced. The attendees will learn the basics, get checklists and best practices when building up their own SSIS scale-out cluster. In addition to the configuration using SSMS other configuration options (command line, T-SQL,..) are presented. Behind the scenes information like logging, the programmability interfaces and configuration options will be shared.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Beginner

Session Code:

Date: December 09

Time: 10:15 AM - 11:15 AM

Room: P22: BI/DEV

Did you ever reach the state in your multidimensional projects when you just didn’t want to implement a new scoped assignment? Will it have any side effects on existing scopes? How about performance?
Sometimes your projects get that complex. You will need to choose between many options and it might get hard to even measure the impact or test out all consequences. This session will not answer all your questions, but you will get some real life experiences on what better not to do…
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: December 09

Time: 2:45 PM - 3:45 PM

Room: P19: BI

In this session will be shown how to obfuscate critical data in real time using Dynamic Data Masking, a new feature in SQL Server 2016, also will be covered two other topics, Always Encrypted, defined as Help to protect data at rest and in motion with the master key residing with the application avoiding application changes, because they are not required, finally Row-Level security that consists in set access control to table rows based on users rights.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: December 09

Time: 11:30 AM - 12:30 PM

Room: P21: DBA

Embedding your R (and soon Python!) models in SQL Server enables you to add predictive capabilities to your applications and your analytics without adding expensive components or going outside your network via expensive API calls.

In this demo-packed talk, you’ll see how you can go from a model built in R to making predictions on the fly in SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: December 09

Time: 4:00 PM - 5:00 PM

Room: P19: BI

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