Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 19
In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then (if needed) evolve it into a fully scalable Azure BI solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Analytics

Level: Intermedia

Session Code:

Date: October 28

Time: 1:45 PM - 2:45 PM

Room: Auditorium 2

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 28

Time: 3:50 PM - 4:50 PM

Room: Auditorium 3

A look at the state of the art in database continuous delivery using SQL Server Data Tools (SSDT), Visual Studio Team Services(VSTS), and VSTS Release Management.

The features provided by platforms such as TFS and VSTS have been widely adopted by application developers in support of modern software development practices such as continuous delivery.

In the world of database development, adoption has been much slower, due to a number of organisational and technical considerations.

This session will discuss some of the challenges associated with database continuous delivery, and the ways in which Visual Studio, SQL Server Data Tools and Visual Studio Team Services can help to improve delivery of SQL Server databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 28

Time: 1:45 PM - 2:45 PM

Room: Auditorium 3

Query Store is a new feature that got released on SQL Server 2016 version and is being improved over the last cumulative updates and on SQL Server 2017 vNext CTP's versions. It's a very useful and interesting feature that allow DBA's ( and non-DBA's :) ) to easily identify performance issues on queries and also allow us to fix it in a fast and simple way. Just the ability to compare a previous execution plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. I want with this session to give you the insight and knowledge to get started using this new and wonderful feature that will change the way how you do performance tuning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 28

Time: 10:30 AM - 11:30 AM

Room: Auditorium 1

BI teams usually not only deliver features , but also do the ad hoc reports, users support etc
This way BI is not a canonical development team and no pure development methodology works "out of the box" . 
In my talk I would like to share my experience choosing and adjusting one.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Analytics

Level: Beginner

Session Code:

Date: October 28

Time: 11:40 AM - 12:40 PM

Room: Auditorium 2

In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 28

Time: 5:00 PM - 6:00 PM

Room: Auditorium 1

Security is unquestionably a major priority for Microsoft. Join me in this session and see what security features Microsoft has  released since SQL Server 2016. In this session you will see how Dynamic Data Masking and Row-Level Security works in on-perm and Azure environments and how to use 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 28

Time: 3:50 PM - 4:50 PM

Room: Auditorium 1

The right tabular modeling is the cornerstone that allow us to build the best dashboards, control panels and analytical models. In this session we will analyze some scenarios of data modeling by using DAX and Power BI. These scenarios, which come from real projects, can also be adapted to tabular models with SQL Server Analysis Services in SQL Server Data Tools and Power Pivot in Excel.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Analytics

Level: Intermedia

Session Code:

Date: October 28

Time: 10:30 AM - 11:30 AM

Room: Auditorium 2

Natixis Sponsor Session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: October 28

Time: 2:45 PM - 3:00 PM

Room: Auditorium 1

We have an enormous set of tools for analysis and pattern matching in the data ecosystem. Among the most used, we can find solutions that come from the academic world such as R, others integrated as part of productivity solutions such as SQL Server Analysis Services or Excel, as well as cloud based hosted solutions such as Azure Machine Learning and Power BI.
In this session, we will use the mentioned tools to analyze a common data set, discovering the compositions, segmentation and patterns present in the data sample.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Analytics

Level: Beginner

Session Code:

Date: October 28

Time: 5:00 PM - 6:00 PM

Room: Auditorium 2

SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds. 

For example, by taking advantage of services like Azure Blob Storage or Azure VMs we can increase the availability of our services or distribute data in smart ways that benefit our performance and decrease cost. In this demo-heavy session, you will learn the strongest use cases for hybrid scenarios between on-premises and the cloud, and open a new horizon of what you can do with your SQL Server infrastructure. SQL Server and Azure are built for each other. 

New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 28

Time: 9:00 AM - 10:00 AM

Room: Auditorium 1

The publication of R Server by Microsoft aims to improve the weaknesses of the R language and its processes of performance, development and operationalization. When we need to analyze very diverse or really large amounts of data, traditional servers may fall short, and this is where R Server over Spark comes to the rescue. How is it implemented in the Microsoft ecosystem? In what scenarios does it help us? How do we configure it? In this session we will answer all these questions and more, with our eyes always on the clouds and thinking big.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Analytics

Level: Intermedia

Session Code:

Date: October 28

Time: 3:50 PM - 4:50 PM

Room: Auditorium 2

This session is about how to set up a WordPress website hosted in Azure using Azure Web Apps and Azure Database for MySQL.
As a plus, during the session I will share some tricks about how to build a process/pipeline to deploy changes in the website.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 28

Time: 11:40 AM - 12:40 PM

Room: Auditorium 3

It's understandable that developers love to work in separate code branches, but this can create painful complications if not managed.

Do you dread large merge conflicts when integrating code?
Continuous Integration is method of working where we merge and fully test our code multiple times a day. This is only possible with a high level of automation. 

I'll be discussing the tools I use to achieve this automation when developing SQL Server databases.

Finding automating the deployment of database changes hard?
ReadyRoll is a tool that allows you to test deployments during development.

How do you know your database change won’t affect something you haven’t thought of?
tSQLt and Pester unit tests can put your mind at rest.

Having trouble keeping your test environments in sync with production?
Docker enables us to fix this with infrastructure as code

You will see how a CI approach to database development can increase team efficiency and reduce the time to go from an ide
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 28

Time: 10:30 AM - 11:30 AM

Room: Auditorium 3

Open source is part of the Microsoft strategy. Indeed, you may run SQL Server either on a physical or a virtual machine, and recently on the top of Windows or Linux operation system as well.

At the same time, maintaining business continuity service remains a major challenge for customers because it is synonymous with economic competitivity.
Fortunately, high availability features for Linux will also be shipped with SQL Server 2017 to address this daily concern. 

This session will be delivering an overview of what is new and how it is going to change the landscape of your mission-critical scenarios.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 28

Time: 1:45 PM - 2:45 PM

Room: Auditorium 1

Ever ended up with a source system where an old datatype was replaced with a new one so you had to rebuild all your SSIS packages? 
Entered a project with SSIS packages which needed a complete rebuild to perform but you didn’t have the time for a rebuild of your whole project?
Client specifications changed (again) and you had to start all over again building all your packages?

We did it all and rebuild 100+ SSIS packages within a day using biml for generating SSIS packages. 
And with a generator at hand, we were able to absorb a new version of a source system including analysis of the changes made in the source in only two days. And the best of all, BIML is part of BIDSHelper and free to use!
Don' t just believe what I say, In my session I will demonstrate where to start. 
I will show you around in BIML. After the quick basics of BIML I will show you how you can parameterize the BIML script in order to multiply the template to multiple packages over and over again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Analytics

Level: Intermedia

Session Code:

Date: October 28

Time: 9:00 AM - 10:00 AM

Room: Auditorium 2

Your company implements data access rules and policies to meet compliance with established security standards... How can you ensure and prove at any time that they're being properly followed, without killing your database servers performance while capturing evidence?

In this Session I'll talk about SQL Server Audit and demonstrate how easy it is to implement in such a way that suits most companies needs, whithout afecting Server performance. 
Also some news in SQL Server 2017 regarding this subject!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 28

Time: 11:40 AM - 12:40 PM

Room: Auditorium 1

In this session we will learn:
What is "Azure Database for MySQL" and "Azure Database for PostgreSQL", how can we configure them, what to take attention to and what to expect from these new services.
What is the difference from these new services and the MySQL and PostgreSQL that we use on our computers or servers.
How to take the best advantage of using this databases as PaaS
And much more...
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 28

Time: 5:00 PM - 6:00 PM

Room: Auditorium 3

Following the trends of hot-topic Docker and Containers. We will talk about the newest developments in Docker World and Microsoft's container adoption.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 28

Time: 9:00 AM - 10:00 AM

Room: Auditorium 3

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