Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 29
Building robust and resilient Data Platform solutions can be complex and costly, building out for both High Availability and Disaster Recovery. The Always On technologies incorporated in the Microsoft SQL Server stack help Data Platform Engineers to do just this. Creating solutions that span multiple locations, in an effort to protect the data that we are tasked to manage on a daily basis.

Together we will walk through the architecture patterns, technology requirements, and configuration options that you need to know in order to build a solid Data Platform. Understanding the implementation differences between on-premises and cloud based deployments is important. Especially as there are specific requirements that need to be met for up-time SLAs to be applicable, as well as mitigating for region failures.

All of these elements mean that it is more than just simple wizards to follow in order to have a solid, reliable, and robust SQL Server Data Platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Advanced

Session Code:

Date: September 02

Time: 12:10 PM - 1:10 PM

Room: Trollfeltet

Query Store is an exciting new feature in SQL Server 2016. It can automatically capture and store a history of queries, query execution plans and execution statistics that makes troubleshooting performance problems caused by query plan changes much easier.
In this session we will examine Query Store, it's architecture, configuration and how it can be used to solve performance problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: September 02

Time: 9:30 AM - 10:30 AM

Room: Trolltunga

Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can't use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching  and so on. In this session, I'm going to cover several tips and tricks how we can handle with this limitations using available possibilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Development

Level: Intermedia

Session Code:

Date: September 02

Time: 9:30 AM - 10:30 AM

Room: Trollveggen

SQL Server 2017 adds support for running in-database Python code. This is of course mainly meant for data science tasks, but in this session we'll concentrate on something far more interesting interesting and nerdy, that is Bitcoin! Join along for exploring the Python support through different Bitcoin-libraries. In the end we'll be able to manage our Bitcoin wallet and explore the Blockchain with T-SQL and Stored Procedures!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Development

Level: Advanced

Session Code:

Date: September 02

Time: 2:30 PM - 3:30 PM

Room: Trollveggen

If you are releasing new reports, cubes and/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:

SSIS/SSAS/SSRS
	Exceptions to the rule
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:
Regular Session (60 minutes)

Track:
BI Architecture & Development

Level: Beginner

Session Code:

Date: September 02

Time: 12:10 PM - 1:10 PM

Room: Trollstigen

In Azure, many BI components are available as SAAS, how can you combine them to build the next generation bi landscape?
What are the possibilities of current azure to create a modern BI? The components currently being offered range from Azure SQL DB and SQL DWH to Data Factory, Stream Analytics, Logic App, to Analysis Services and Power BI to name just a few. This is a very good toolbox, with which you get the first successes very quickly.
Step by step is explained here how to create the classic ETL in the cloud and analyze the results in Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Development

Level: Beginner

Session Code:

Date: September 02

Time: 3:50 PM - 4:50 PM

Room: Trollstigen

"For many companies data visualization is still a hygiene factor; necessary but not crucial"

In a world where everyone wants to use data to drive their business forward it is important to be able to communicate and speak the language of data even though data itself can be complex. One way of doing this is by making good data visualisations. Good data visualisations are engaging, they are informative and they let your data tell you its story. Too often data visualisation gets a low priority making the final result feeling lacklustered and making the users uninspired. 

In this session we look at some data visualisation principles and best practices, in order to deliever your message with a clear point of view and minimize confusion. Lastly we will look at how you can use these practices with Power BI in order to improve how data can be communicated to your end users in the best possible way making them come back over and over.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics & Visualization

Level: Beginner

Session Code:

Date: September 02

Time: 2:30 PM - 3:30 PM

Room: Trolltunga

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Advanced

Session Code:

Date: September 02

Time: 9:30 AM - 10:30 AM

Room: Trollstigen

TBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: September 02

Time: 1:50 PM - 2:50 PM

Room: Trollfeltet

Azure Machine Learning is Microsoft's go-to service for operationalizing machine learning models in the cloud. But can it do deep learning? The answer is yes! 

At Elkjøp Nordic, we use a neural network trained in TensorFlow and operationalized in Azure ML to sift through and categorize thousands of sentiment-classified customer feedback texts from our websites, allowing us to quickly measure how we are doing on major things like UX, checkout and payment, pinpoint areas where we need to improve, and more easily zero in on the important qualitative demands and wishes of our customers.

Deploying deep learning models into production is generally not trivial, and it's very common for machine learning projects with otherwise excellent results to be shelved before being put to practical business use. It doesn't have to be this way; I will show you how to jump this hurdle using the Data Science VM for model training, Blob Storage for... well, storage, and Azure ML for operationalization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure and Cloud Services

Level: Intermedia

Session Code:

Date: September 02

Time: 12:10 PM - 1:10 PM

Room: Trollheimen

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 is both 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:
Database Development

Level: Intermedia

Session Code:

Date: September 02

Time: 12:10 PM - 1:10 PM

Room: Trollveggen

Entity Framework doesn't have the best reputation amongst DBAs, but the good news is it isn't inherently terrible; it's just very easy to get wrong.

In this session, we'll explore the mistakes which make Entity Framework stress SQL Server, and show how you can resolve them. We'll talk about how you can spot issues, either in production environments or during development. Finally we'll discuss ways of working with your development team to prevent these problems occurring in the first place.

You might not leave convinced that Entity Framework is a good idea, but you should go home with the understanding needed to get it running well on your systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: September 02

Time: 12:10 PM - 1:10 PM

Room: Trolltunga

This isn't the dark ages any more. You've learned that you need to put your database in source control and you're competent with source control systems like TFS or Git. You've also learned how to express your database in script form using a tool like SSDT, Flyway or Redgate.
 
However, you still haven't written as many automated tests as you know you should and you aren't convinced you're going about it the right way. You haven't really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins, and even if you have you aren't sure how the process should work for SQL Server builds and tests.
 
In this session I'll talk through various ways to automate your database builds as well as how to use tSQLt to create a suite of automated tests, enabling you to spot problems early and giving you confidence in the quality of your code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Advanced

Session Code:

Date: September 02

Time: 9:30 AM - 10:30 AM

Room: Trollfeltet

Self-Service BI is a transition for most organizations. Moving from the traditional IT corporate reporting to enabling employees to serve themselves across an organization, requires a governance process and managing tools and frameworks. This session will cover the most ciritcal governance aspects a large organization needs to consider when implementing Power BI as a corporate and self-service BI tool- mostly focusing on the self-service part. I will bring in real world examples from a global classification company (+10 000 employees) which is using Power BI company wide and where Power BI adoption is increasing rapidly.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics & Visualization

Level: Intermedia

Session Code:

Date: September 02

Time: 9:30 AM - 10:30 AM

Room: Trollheimen

This session is for DBAs specifically, but will be relevant to any technicians who use checklists

I was required to prove that I had successfully installed and configured a backup solution across a large estate. I had a number of success criteria that had to be met. Checking all of these by hand (eye) would have been error prone, so I wrote a test to do this for me and an easy for management to read HTML report using PowerShell and Pester.

The session has come from that situation and is about enabling you to provide an easy to read output to quickly and repeatedly show that infrastructure is as expected for a set of checks, also known as  Operational Validation using Pester. There are many use cases for this type of solution; DR testing, installation, first line checks, presentation setups

After this session you will have a basic understanding of how Pester works and the capability to examine your checklists and create your own validation tests and provide some reporting for manager
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: September 02

Time: 3:50 PM - 4:50 PM

Room: Trollfeltet

How easy is it to hack a SQL Server? 
In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace.
We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more. 
Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016.
This is a demo-driven session, suited for DBAs, developers and security consultants.
Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: September 02

Time: 3:50 PM - 4:50 PM

Room: Trollveggen

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query.  Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.  

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: September 02

Time: 10:50 AM - 11:50 AM

Room: Trollstigen

Azure Cosmos DB the next-generation DocumentDB database service and is a write optimized, schema-agnostic and globally distributed database engine that natively supports multiple data models like key-value, documents, graphs, and columnar. It also supports many APIs for accessing data including MongoDB, DocumentDB SQL, Gremlin , and Azure Tables. In this session we will be describing possible use cases for CosmosDB and look at how to get started . Topics will focus on creating, importing and distributing databases plus demos on using emulators for local development and testing Cosmos DB databases
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure and Cloud Services

Level: Beginner

Session Code:

Date: September 02

Time: 2:30 PM - 3:30 PM

Room: Trollstigen

SQL Server is coming to Linux. This session is a primer for DBAs who know SQL Server, but do not know much about the Linux operating system.

Learn why this is an important move for Microsoft, and how it affects the data professional.
Learn installation and management of SQL Server on Linux
Learn about cross platform options for connecting and running code in SQL Server on Linux
Learn basic options for monitoring SQL Server performance on Linux
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: September 02

Time: 2:30 PM - 3:30 PM

Room: Trollfeltet

Don't know where to start with IoT? Here is your chance to view a live demo on how to do it, the available tools, and the immediate results we get in Azure with Power BI.

I will use a Raspberry Pi to demonstrate the case. Code and examples will be shared after the session.

Note this is a beginners session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure and Cloud Services

Level: Beginner

Session Code:

Date: September 02

Time: 10:50 AM - 11:50 AM

Room: Trolltunga

Sessions Found: 29
Back to Top