Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 30
Microsoft VSTS offers cloud based portal and services to fully automate your builds and release processes.

While SSIS is not officially supported we will walk you through the process of setting up VSTS for automated build of your BI projects, leading onto automated release and deployment.

Topics include:
-	VSTS overview
-	Deploying Agents
-	Automating Build
-	Automating Release
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 01

Time: 12:10 PM - 1:10 PM

Room: 4

If your regular SQL Server becomes too slow for running your data warehouse queries, or uploading the new data takes too long, you might benefit from the Azure SQL Data Warehouse. Via its “divide and conquer” approach it provides significant performance improvements, yet most client applications can connect to it as if it is a regular SQL Server.
But to benefit from these performance improvements we need to implement our Azure SQL Data Warehouse in the right way. In this session - through a lot of demos - you will learn how to setup your Azure SQL Data Warehouse, review indexing in the context of the Azure SQL Data Warehouse and see that monitoring is done slightly different from what you’re used to.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 01

Time: 3:50 PM - 4:50 PM

Room: 2

You have probably heard the buzz about Azure Machine Learning, aka Azure ML,  over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 01

Time: 12:10 PM - 1:10 PM

Room: 6

Are you tired of creating and updating the same SSIS packages over and over and over again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and start automating your SSIS development?

Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.

In this session, we will first look at the basics of Biml and how to automatically generate SSIS packages from database metadata. Then we will explore techniques for reusing code and implementing changes across projects with just a few clicks. Finally, we will create an example project that you can download and start with to generate all the SQL scripts and SSIS packages needed to build a staging environment in just a few minutes.

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 01

Time: 2:30 PM - 3:30 PM

Room: 1

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: September 01

Time: 3:50 PM - 4:50 PM

Room: 6

DevOps is a hot topic in today’s software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 01

Time: 12:10 PM - 1:10 PM

Room: 1

May 25 is behind us and you are GDPR compliant. Or where you compliant in May but not sure anymore? Have you created some nice Excel lists with an overview of personal data, and then not kept them up to date? 

This session will show a way to utilize Azure Data Catalog to keep you GDPR compliant. By using the Business Glossary in a smart way and extracting the data with APIs you can create routines to ensure, and document, that you keep your personal data registry complete and updated. You can even combine the processes you have mapped in Visio with the data catalog in Power BI to create reports that show how personal data is used in your business. And in the end, you might find out that the personal data classification and overview gives you some new insights into your data, and new possilbities?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: September 01

Time: 9:30 AM - 10:30 AM

Room: 1

R is the first choice for data scientists for a good reason: besides accessing and transforming data and applying statistical methods and models to it, it has a wide variety of possibilities to visualize data. As visual perception of data is the key to understanding data, this capability is crucial. This session will give you a broad overview over available packages and diagram types you can build with them on the one hand, and a deep dive into common visualizations and their possibilities on the other hand. Impress yourself and your peers with stunning visualizations which will give you insights into data you could not achieve with other tools of Microsoft’s BI stack.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 01

Time: 9:30 AM - 10:30 AM

Room: 3

Ensuring the ongoing protection of personally identifiable information is mandatory in today's business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting.  This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can't go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 01

Time: 10:50 AM - 11:50 AM

Room: 1

Data scientists know the “magic” of making accurate predictions over time.
Magic is just sufficiently advanced technology, and most of a data scientist’s magic is a good process, a robust understanding of data, and the ability to sensibly apply some recipes.
Let’s go behind the curtains and see the process and the fundamentals employed in making any prediction. Learn enough to start adding magic to your own work.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 01

Time: 2:30 PM - 3:30 PM

Room: 3

Understanding and investigating the Internals of an SQL Server database requires use of advanced (often undocumented) DMV's or DBCC commands 

While these provide an insight into the low-level data structures of the database it can be difficult to visualise how these are actually implemented inside the mdf files of the database.

In this session we will see how adding the visualisation options of PowerBI and the Power of R can be used to get a better understanding of how SQL internally manages your data.

Rather than just talking about Fragmentation, Page Splits or Forwarded records, in this session we will show how these physically appear.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: September 01

Time: 10:50 AM - 11:50 AM

Room: 5

Maybe you have heard about Databricks, the new guy in the Analytics neighborhood. Maybe we thought that HDInsight was going to be our friend for a long time, but here it comes a new challenger that offers to be bigger, faster and better. 

In this session we will review the current landscape for big data in Azure and how Databricks fits in this picture, including some demos and scenarios on where and when to use it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 01

Time: 3:50 PM - 4:50 PM

Room: 4

As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up. Now there is a simple method to set this up using PowerShell and you can get the results in PowerBi or a report emailed to you on a schedule. Details such as

How long since your last backup?
How long since your last DBCC Check?
Are your Agent Operators Correct?
Is AutoClose, AutoShrink, Auto Update Stats set up correctly?
Is DAC Allowed?
Are your file growth settings correct, what about the number of VLFs?
Is your latency, TCP Port, PS remoting as you expect?
Is Page Verify, Data Purity, Compression correctly set up?

and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team.

Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 01

Time: 3:50 PM - 4:50 PM

Room: 3

Until SQL Server 2016, the Query Optimizer and the Execution Engine were strictly separated. The Query Optimizer produces an execution plan that, based on statistics and estimates, should be fast. That execution plan is then faithfully executed by the Execution Engine, even if reality turns out to be different from expectations.

SQL Server 2017 changes this! Three new features now allow execution plans to adapt to reality. Memory Grant Feedback increases or decreases assigned memory based on past experience. The Adaptive Join operator allows the optimizer to create two alternative plans, the best of which will be decided at execution time. And with Interleaved Execution, parts of the plan are even completely recompiled mid-execution, with much better cardinality estimates.

If you are more interested in how all this ACTUALLY works than in shiny marketing slides, come to this session. We will spend the full 60 minutes knee-deep in execution plan internals!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: September 01

Time: 2:30 PM - 3:30 PM

Room: 2

Analysing highly connected data using SQL is hard! Relational databases were simply not designed  to handle this,  but graph databases were.  Built from the ground up to understand highly connected data, graph databases enable a flexible performant way to interrogate and traverse highly connected data. 

If you have looked at graph processing in SQL Server then you will know it has limitations. Well Microsoft developer has a few alternatives, one of those being the Gremlin API in CosmosDB. In this session, we seek to explore, what is a graph database, why you should be interested, what query patterns does they solve and how to use Gremiln's fantastic language.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: September 01

Time: 9:30 AM - 10:30 AM

Room: 5

With stricter EU privacy laws like GDPR, the need to encrypt data is greater than ever.
In this session we'll look at what SQL Server offers in this area:
1) symmetric and asymmetric server encryption which lets the server encrypt table data and control the keys, 
2) Always Encrypted (AE) which works similarly to server encryption but the client control the keys meaning server can't decrypt the data
3) Transparent Data Encryption (TDE) which encrypts your data at rest making getting data from stolen drives useless
4) creating secure SSL/TLS communication channels between your apps and the server to prevent clear text network traffic which can be observed
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: September 01

Time: 12:10 PM - 1:10 PM

Room: 3

In the last few years the requirement to understand and use distributed Source control systems has become an increasing part of a Data Professionals life. 
With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!

In this session we will investigate the setup and use of GitHub and Git for source control.
Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!

Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 01

Time: 2:30 PM - 3:30 PM

Room: 6

SSAS Tabular mode is available sind version 2012. And for a lot of people, especially experienced SSAS Multidimensional users, the first versions left a lot to ask for. 
But Tabular experienced a lot of remarkable changes up to now. Let's look at a short summary of this interesting life story. And let's try to identify the most important steps of development. 
Another interesting view point is the comparison to SSAS Multidimensional mode. Which features are provided by both versions, where are the competitive advantages? 
This session will cover a more strategic point of view to both worlds with only short demos. And a common understanding of the important features of analytical solutions will be expected.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 01

Time: 12:10 PM - 1:10 PM

Room: 2

Who does not know the problem, you sit in the bar and just don't know which cocktail to order?
The Cogntive services offer here with face, emotion and recommendation three APIs that can help you. How do you best combine these services to get a suggestion for your cocktail?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 01

Time: 9:30 AM - 10:30 AM

Room: 4

In order to do machine learning you need data and you need algorithms. Instead of having your data and machine learning code in separate environments who not just do everything in SQL Server 2017? In this session we are going to have a look at SQL Server Machine Learning Services and see how we can do machine learning in both R and Python directly in SQL Server. What are the ups and downs of doing everything directly in our favorite environment?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: September 01

Time: 12:10 PM - 1:10 PM

Room: 5

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