Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type



Sessions Found: 34
Do you find query optimization a mystery? This session will straighten out your question marks.
You will se how queries are run, how indexes are used and get an insight into what query plans tell you.
Further on you'll be introduced to In-Memory and Column Store indexing to get a fair chance of 
selecting appropriate indexing for your query load.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Lambert

This session aims to give attendees an introduction into containers running SQL Server on Windows Server 2016.
Attendees will be taken through the following: -

Defining what containers are (benefits and limitations)
Configuring Windows Server 2016 to run containers
Installing the docker engine
Pulling SQL images from the docker respository
Running SQL Server containers
Committing new SQL Server images
Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)

This sessions assumes that attendees have a good background in SQL Server administration and a basic knowledge of
Windows Server administration
Speaker:

Session Type:
Saturday Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: September 09

Time: 1:45 PM - 2:45 PM

Room: Fairfax

Have you ever wondered if there are more goals scored on a rainy day? This session shows how you can use open data sources and web pages to gather data. How you can then manipulate and extend it and finally report on it. We will look into how you can use data from open sources and combine it with data from web pages to create the dataset you need.  
When we have our dataset we will manipulate and extend it using M and DAX so that we can get meaningful insights from it. We will then dive into the data to see if there is anything to report.  

In this end to end Power BI Desktop demo we will use fun data that many can relate to as the English Premier League is one of the most popular football leagues in the world. The audience will take away many nuggets of information as they see how a real world example could look like. I will share all the obstacles and learning I got when creating this report reveiling both the limitation of Power BI Desktop and open data as well as its strength.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: September 09

Time: 1:45 PM - 2:45 PM

Room: Cromwell

This 2 hour charity minicon requires a separate registration and a small donation to charity. Registration and more details can be found through https://spssqladf.eventbrite.co.uk

Azure Data Factory. This is not SSIS in Azure. But it’s a start for our control flows. Let’s update our terminology and understand how to invoke our Azure data services with this new controller/conductor who wants to understand our structured datasets. Learn to create the perfect dependency driven pipeline with Azure Data Factory and allow your data to flow. What’s an activity and how do we work with time slices? Is a pipeline a pipeline? Who is this JSon person? All the answers to these questions and more in this introduction to working with Azure Data Factory. Plus, insights from a real-world case study where ADF has been used in production for a big data business intelligence solution handling log files for 1.5 billion users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Gell

This 2 hour charity minicon requires a separate registration and a small donation to charity. Registration and more details can be found through https://spssqladf.eventbrite.co.uk

Having covered the basics in part 1 we’ll now go beyond the Azure Data Factory basic activity types and Azure Portal wizard. Extract and load are never the hard parts of the pipeline. It is the ability to transform, manipulate and clean our data that normally requires more effort. Sadly, this task doesn’t come so naturally to Azure Data Factory, as an orchestration tool so we need to rely on its custom activities to break out the C# to perform such tasks. Using Visual Studio, we’ll look at how to do exactly that and see what’s involved in Azure to utilise this pipeline extensibility feature. What handles the compute for the compiled .Net code and how can does this get deployed by ADF? Let’s learn how to fight back against those poorly formed CSV files and what we can do if Excel files are our only data sou
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: September 09

Time: 11:15 AM - 12:15 PM

Room: Gell

Microsoft's Platform as a Service solution,  SQL Azure is a compelling solution for many who don't want to manage their own highly available SQL implementation. SQL Azure however does not replicate all of the services of on-premesis SQL, and one of these missing is the SQL Agent. This session looks at what alternatives exist for running and managing SQL jobs in Azure without SQL agent. In particular we will focus on Azure Automation and Azure Functions. The presentation will include a brief overview of the two services and how they are applicable to SQL workloads, followed by a demo of creating and running a SQL job.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: September 09

Time: 1:45 PM - 2:45 PM

Room: Horton

Since the launch of Azure Machine Learning, there have been lots published on how to get started with AML. They look at basic regression, while regression is great, it only skims the surface of what machine learning is good at. In this session we go beyond the basics of regression and look at how we can clean and tune our model to boost its predictive performance. We will look at what you model is actually telling you and investigate how we can improve your accuracy. We will look at what algorithm works for what type of scenario, whether you're looking to predict, classify, recommend, cluster or segment. We will also look at why they work and what they are doing and how we can tweak their parameters to boost performance of our model. This is not Machine learning out of the box, this is applied machine learning. Is this session for you? Terms like supervised, unsupervised learning, confusion matrix, area under the curve should be familiar to you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
Cloud

Level: Advanced

Session Code:

Date: September 09

Time: 1:45 PM - 2:45 PM

Room: Devereux

In the times of data explosion, a dazzling array of information streams and unbelievable possibilities of different techniques to manage data via the Microsoft Data Platform, this session asks the question: what about data curation? 
We dive into the requirements of modern data governance and curation and show in examples, what the Microsoft Data Platform has to offer: Can SQL Server Master Data Service (MDS), Data Quality Services (DQS) and Integration Service (SSIS) help? Which options offers the Azure Data Catalog and how does the Microsoft Common Data Service come into play? We also look at the potential of the new integrated languages in the Data Platform like R or U-SQL. At the end of this session you will have an overview and understanding of the possibilities, that Microsoft Data Platform offers you to address your data curation requirements.
Speaker:

Accompanying Materials:

Session Type:
Saturday Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Devereux

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:
Saturday Regular Session (60 minutes)

Track:
DEV

Level: Beginner

Session Code:

Date: September 09

Time: 8:30 AM - 9:30 AM

Room: Cromwell

With increasing speed in relational query execution classical analytical solutions get challenged more and more.
Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?

We are analyzing typical scenarios from classical multi-dimensional analysis like YTD calculation, DistinctCount and others in regards to their efficiency with different solution approaches: Classical multi-dimensional databases in ROLAP mode, DirectQuery, T-SQL… And we are going to show how Columnstore indexes are influencing those solutions.

Find out about advantages and disadvantages of the different solutions in regards to the problem. And maybe you will discover new approaches for your own challenges.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: September 09

Time: 3:00 PM - 4:00 PM

Room: Fairfax

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:

Session Type:
Saturday Regular Session (60 minutes)

Track:
BA

Level: Intermedia

Session Code:

Date: September 09

Time: 11:15 AM - 12:15 PM

Room: Cromwell

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:

Session Type:
Saturday Regular Session (60 minutes)

Track:
BA

Level: Beginner

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Fairfax

Being able to monitor, diagnose and recover from Database Corruption is  a critical skill for any SQL Server DBA. 
In this session we will walk through the techniques required to detect and repair various forms of Corruption 
Using a number of example corrupted database we will explore how to determine and fix corruption while avoiding some of the common mistakes.
Warning: Hex Editors and DBCC Page dumps will be involved!
Speaker:

Session Type:
Saturday Regular Session (60 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: September 09

Time: 8:30 AM - 9:30 AM

Room: Fairfax

This 2 hour charity minicon requires a separate registration and a small donation to charity. Registration and more details can be found through https://spssqldevops.eventbrite.co.uk

If you are releasing database changes, new reports, cubes or SSIS packages on a regular basis, you've probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition.
DevOps is a way to bridge the gap between developers and IT professionals and for that we need to address the toolchain to support the practices. Microsoft offers a set of tools that'll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.

We will in detail be looking at:

Agile Development Frame of Mind
	Visual Studio Online (tool)
	Feature/PBI/WI (concept)
Team Foundation Server
	Code Branching (concept)
	Build Agents (tool)
PowerShell
	Microsoft's "Glue" (tool)
Speaker:

Session Type:
Saturday Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: September 09

Time: 1:45 PM - 2:45 PM

Room: Gell

This 2 hour charity minicon requires a separate registration and a small donation to charity. Registration and more details can be found through https://spssqldevops.eventbrite.co.uk

If you are releasing database changes, new reports, cubes or SSIS packages on a regular basis, you've probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition.
DevOps is a way to bridge the gap between developers and IT professionals and for that we need to address the toolchain to support the practices. Microsoft offers a set of tools that'll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.

We will in detail be looking at:

Agile Development Frame of Mind
	Visual Studio Online (tool)
	Feature/PBI/WI (concept)
Team Foundation Server
	Code Branching (concept)
	Build Agents (tool)
PowerShell
	Microsoft's "Glue" (tool)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: September 09

Time: 3:00 PM - 4:00 PM

Room: Gell

There are tools available from Microsoft, as well as from a number of third party vendors, to ease the process of integrating database unit testing into your development environments and your continuous delivery pipeline.

This session isn't about any of those tools, but is an attempt to get back to basics - with the open source tSQLt framework - and address questions such as 

 Why is database unit testing difficult?
 What do I need to test?
 What do I not need to test?
What does a "good" unit test look like?
What tests should I be writing anwyay?

This session will incorporate real-life experiences with tSQLt, as well as lessons that can be learned from other testing framworks and other programming languages.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: September 09

Time: 4:10 PM - 5:10 PM

Room: Horton

With the addition of R into SQL Server 2016, Microsoft have provided a few extra degrees of freedom for the standard SQL developer. You can now use the R language to wrangle, clean and collect external data, using libraries and functionality that simply wasn’t available to you before with regular T-SQL. Performing data enrichment at scale with SQL Server or even Microsoft R Server can provide extremely valuable new insights for your clients and start reaping the benefits of big data.

In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016. 

This session is for anyone who is new to R and is interested in expanding their skill set beyond their comfort zone in SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Saturday Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: September 09

Time: 3:00 PM - 4:00 PM

Room: Devereux

Security is unquestionably a major priority for Microsoft. Join me in this session and see what security features Microsoft has  released in 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:

Session Type:
Saturday Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: September 09

Time: 10:00 AM - 11:00 AM

Room: Horton

So you have a few hundred million rows of customer data... 
Governance require you to anonymise the PPI data but how do you retain it safely and how do you unlock its value?

We dig into the magical land of "Snakes" and "Ladders" commonly used by fraud prevention agencies to unlock trend and profile analytics.
Speaker:

Session Type:
Saturday Regular Session (60 minutes)

Track:
BI

Level: Advanced

Session Code:

Date: September 09

Time: 3:00 PM - 4:00 PM

Room: Horton

Configuring Kerberos can be easy. Indeed, with favourable conditions and some preparation, the whole thing can be over in minutes. However, if hours later it still does not work, troubleshooting can take many days even with help of experts. 

What most resources usually cover is, at best, some step by step configuration instructions for a particular architecture. Such instructions often lack explanation of why it has to be done that way in terms of the role of every step in the authentication process.

I would like to present easy to follow principles of Kerberos constrained delegation and protocol transition with handy tips and templates to get this right the first time for your particular environment. The goal is to explain the meaning of the settings in terms of the role in the Kerberos constrained delegation authentication.

This presentation covers some very useful resources to help you tame your three-headed monster. I will also do a demo of configuration and troubleshooting
Speaker:

Session Type:
Saturday Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: September 09

Time: 11:15 AM - 12:15 PM

Room: Devereux

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