sqlsathistory

Nr: 765

Back to Main list

SQLSaturday #765 - Denmark 2018

Start Time (24h) Speaker Track Title
08:30:00 Christopher Adkin Application Database Development Problem Solving With The In-Memory Engine
08:30:00 Kevin Chant Enterprise Database Administration Deployment Choose your own Database Adventure
08:30:00 Satya Jayanty Cloud Application Development Deployment Azure Cosmos DB - What you need to know to build globally distributed apps?
08:30:00 Andrew Pruski Cloud Application Development Deployment SQL Server Containers in Azure
08:30:00 Kenneth Nielsen Dynamics 365 Who will be Denmark's next Primeminister?
10:00:00 Satya Jayanty Analytics and Visualization Big Data with Azure: where to begin? Concepts and best practices
10:00:00 Hugo Kornelis Application Database Development Now Where Did THAT Estimate Come From?
10:00:00 Mihail Mateev Cloud Application Development Deployment Dealing with CosmosDB
10:00:00 Daniel Otykier BI Platform Architecture, Development Administration Boosting SSAS productivity with Tabular Editor
10:00:00 Bent Pedersen Analytics and Visualization Dataflows for Power BI
12:30:00 Christopher Adkin Application Database Development Continuous Integration Pipelines With Jenkins, Docker and SQL Server
12:30:00 Andrea Martorana Tusa Application Database Development The language of graph databases and SQL Server
12:30:00 Bartosz Ratajczyk Application Database Development Start testing your SSIS packages with ssisUnit
12:30:00 David Postlethwaite Application Database Development Shard Attack - Horizontal Scaling in Azure SQL Database
12:30:00 Jens Vestergaard BI Platform Architecture, Development Administration Continuous Delivery for BI projects
13:45:00 Mihail Mateev Cloud Application Development Deployment Device provisioning with Azure IoT in a Nutshell
13:45:00 James McGillivray BI Information Delivery Working with complicated data models in DAX
13:45:00 Erland Sommarskog Application Database Development Don't Use Cursors or Why You Maybe Should Use a Cursor After All
13:45:00 Jens Vestergaard Analytics and Visualization Data Ingestion Tricks w/ M
13:45:00 Martin Hansen Application Database Development SQL server window functions
15:15:00 Alexander Klein BI Platform Architecture, Development Administration Build your next BI solution in azure
15:15:00 Nico Jacobs Cloud Application Development Deployment Azure stream analytics
15:15:00 Bob Duffy Cloud Application Development Deployment Automate your SSIS Deployments with VSTS
15:15:00 Tracy Boggiano Enterprise Database Administration Deployment Collecting Performance Metrics
15:15:00 Bent Pedersen BI Platform Architecture, Development Administration Automation and best practices for ADFv2
16:30:00 Alexander Klein Cloud Application Development Deployment Azure Cognitive Services - AI for everyone
16:30:00 Michal Sadowski Enterprise Database Administration Deployment Database corruption
16:30:00 David Postlethwaite Application Database Development Graph Data in SQL 2017
16:30:00 Just Blindbaek BI Platform Architecture, Development Administration End-to-end Business Intelligence solution in Azure
16:30:00 Amit R S Bansal Application Database Development SQL Server Memory Internals Troubleshooting

SessionID: 77200

Problem Solving With The In-Memory Engine

Back to calendar

Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Christopher Adkin

Title: Problem Solving With The In-Memory Engine

Abstract:

There is a vast array of material in the SQL Server community that covers the in-memory engine in great detail, this session will cover some of the internals of the in-memory engine, however what it will also do is fill in the void as to common performance issues and how they can be solved with the in-memory engine, specifically:

SessionID: 77303

Choose your own Database Adventure

Back to calendar

Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Chant

Title: Choose your own Database Adventure

Abstract:

Based on real life scenarios, in this audience interactive session we will go through some scenarios you might encounter whilst dealing with SQL Server databases and you will be provided with some options about what to do. Members of the audience will then select from these options what to do and we will follow that path and see what the outcome is from there.

Each selection will have a different outcome, and along the way you will probably learn some new things.

SessionID: 77349

Azure Cosmos DB - What you need to know to build globally distributed apps?

Back to calendar

Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Satya Jayanty

Title: Azure Cosmos DB - What you need to know to build globally distributed apps?

Abstract:

In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB. There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.

SessionID: 82809

SQL Server Containers in Azure

Back to calendar

Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Andrew Pruski

Title: SQL Server Containers in Azure

Abstract:

Running SQL Server in Docker containers brings benefits that data professionals shouldn't be ignoring. Over the last year the images provided by Microsoft have matured to a point where running SQL Server containers in production is a viable option.

However, running standalone Docker containers presents challenges so other technologies are need to support them. This session will provide an introduction to the various options for running SQL Server containers in Azure.

I'll cover the following different topics:- The Azure Container Registry Azure Container Instances Azure Container Services

This session is aimed at SQL Server DBAs and Developers who have some experience with Docker and want to know the different options that are available in Azure.

Each topic will be backed up with demos which will show how simple it is to get up and running with these technologies

SessionID: 86325

Who will be Denmark's next Primeminister?

Back to calendar

Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Dynamics 365

Speaker: Kenneth Nielsen

Title: Who will be Denmark's next Primeminister?

Abstract:

The Danish parliament just opened for its last session before the next general election. It is election season in Denmark. In this talk I will play around with Danish polling data and show you how to predict who will be Denmark's next Primeminister.

Heavy usage of R in this session

Speaker is NOT Kenneth, but will be MIkkel Freltoft Krogsholm

SessionID: 77350

Big Data with Azure: where to begin? Concepts and best practices

Back to calendar

Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: Satya Jayanty

Title: Big Data with Azure: where to begin? Concepts and best practices

Abstract:

In order to ascertain the abilities of cloud computing platform, let us overview what is available offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.

SessionID: 78865

Now Where Did THAT Estimate Come From?

Back to calendar

Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Hugo Kornelis

Title: Now Where Did THAT Estimate Come From?

Abstract:

The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there?

In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.

Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.

SessionID: 80739

Dealing with CosmosDB

Back to calendar

Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Mihail Mateev

Title: Dealing with CosmosDB

Abstract:

CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema.

In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.

SessionID: 83231

Boosting SSAS productivity with Tabular Editor

Back to calendar

Event Date: 06-10-2018 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Daniel Otykier

Title: Boosting SSAS productivity with Tabular Editor

Abstract:

Authoring SSAS tabular models using the standard tools (SSDT) can be a pain when working with large models. Tabular Editor is an open-source alternative, that relies only on the Model.bim metadata and the Tabular Object Model (TOM). Compared to SSDT, making changes to measures, calculated columns, display folders, etc. is lightning fast, and the UI provides a "what-you-see-is-what-you-get" experience, making it much easier to manage and author large models. In this session, we will briefly go over the basic features, and then dive into the productivity enhancing features of Tabular Editor, such as scripting, custom actions, the Best Practice Analyzer, command-line build and deployment, and much more. You will never want to use Visual Studio for Tabular Modelling ever again! Attendees will also have the opportunity to ask questions or provide feedback about the tool.

SessionID: 85128

Dataflows for Power BI

Back to calendar

Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: Bent Pedersen

Title: Dataflows for Power BI

Abstract:

Get and overview of Dataflows and how it integrates data lake and ETL technology directly into Power BI to enable anyone with Power Query skills.

Before diving into details we will go through the architecture and demonstrate the bigger picture for Dataflows in Power BI.

We will go through how you can create, customize and manage data within the Power BI experience in a simpler way. Part of this will also be to go through Common Data Models which contains the business entities across your organisation.

This will help your organisation simplifying modeling and is intended to prevent multiple definition for the same data.

SessionID: 77199

Continuous Integration Pipelines With Jenkins, Docker and SQL Server

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Application Database Development

Speaker: Christopher Adkin

Title: Continuous Integration Pipelines With Jenkins, Docker and SQL Server

Abstract:

SessionID: 77515

The language of graph databases and SQL Server

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Application Database Development

Speaker: Andrea Martorana Tusa

Title: The language of graph databases and SQL Server

Abstract:

SQL Server 2017 introduced the extension for graph databases. As there are millions of SQL Server users worldwide, this feature broadens enormously the audience of potential users.

But, what to expect exactly from a graph database? How to query it? Is SQL Server fully featured compared to other products? In this session we answer these questions. We start illustrating the concepts behind the model; how relationships are handled and what are the common patterns and issues for a graph. What are the data connections a graph can easily represent. Then we compare the semantic model with SQL Server to discover how to apply it to real world. We analyze some case study: pattern matching, path finding, aggregation, ranking … For each of them we show how to use standard T-SQL and how to rewrite the query using graph objects. What is the benefit of reformulate our queries in terms of clearness and performances, what is already available in order to consider SQL Server a valuable player.

SessionID: 78639

Start testing your SSIS packages with ssisUnit

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Application Database Development

Speaker: Bartosz Ratajczyk

Title: Start testing your SSIS packages with ssisUnit

Abstract:

How do you test your SSIS packages? Do you prepare them, set the parameters and variables, maybe get some sample or production data and run few times by hand in SSDT? It’s not a bad practice when you start your ETL journey, but after some time you probably think about automation. If not – you should. Perhaps you have some SQL scripts that verify data in the tables after package execution, but if you are like me, somewhere inside you feel that it’s not enough. It’s time you start automated SSIS unit and integration testing.

On this session, I will show you why you should and how to start with automated testing of the packages and the whole projects using ssisUnit – the free SSIS testing library. I will start with some basics and move forward to the real-life examples of the unit and integration testing of the SSIS packages/ projects/solutions. You will see the benefits of automated testing and that testing is hard only at the beginning.

SessionID: 84668

Shard Attack - Horizontal Scaling in Azure SQL Database

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Application Database Development

Speaker: David Postlethwaite

Title: Shard Attack - Horizontal Scaling in Azure SQL Database

Abstract:

Traditionally, when a server starts to reach its limit we have simply thrown more resources at it, either more CPU, memory or disk.

However there comes a point, especially in the cloud, where it is no longer possible to add more resources to a single database. Here we need a different solution. Instead of scaling up we must scale out, sometimes called horizontal scaling or sharding.

In this talk we will look at how to scale out in Microsoft Azure SQL database using the Azure Elastic Database tools We will look at the requirements and options for horizontal scaling in Azure and then we will have a go at sharding an Azure SQL database and then querying and updating the different shards We will be using t-sql, PowerShell and c# so come prepared for some serious coding

SessionID: 85102

Continuous Delivery for BI projects

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jens Vestergaard

Title: Continuous Delivery for BI projects

Abstract:

If you are releasing new reports, SSAS 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.

Continuous Delivery is a way to bridge the gap between developers and IT professionals and for that we need to address the both the toolchain to support the practices as well as the mindset on the team. 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 The Path Ahead (direction) Visual Studio Online (tool) Feature/User Story/Work Item (concept) Team Services Code Branching (concept) Build Agents (tool) Releases (tool)

SessionID: 80742

Device provisioning with Azure IoT in a Nutshell

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Mihail Mateev

Title: Device provisioning with Azure IoT in a Nutshell

Abstract:

Scaling from a few connected devices while developing a proof of concept to thousands or millions

of devices deployed in the field is not trivial. In the IoT device life cycle, provisioning is key for scaling securely. This talk is about main concepts and implementation when we need to provision IoT devices for modern Azure IoT Solutions. During this session, you'll get a sneak peek into how Azure IoT enables seamless, zero-touch registration of devices to IoT Hub with security that begins at the device and ends with our cloud.

SessionID: 83431

Working with complicated data models in DAX

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: BI Information Delivery

Speaker: James McGillivray

Title: Working with complicated data models in DAX

Abstract:

Have you ever watched a demo of DAX functionality, and marvelled at how simple the language is, but yet, when you work on your own data model, it just doesn't work as expected?

In this session, we'll look at 4 common problems which occur when you're using more complicated data modelling techniques, and design and implement a simple solution to overcome these complications.

From role-playing dimensions and bi-directional filters to advanced filter context and overriding the default blank behaviour, we'll learn to solve a variety of problems and add value to our data models.

SessionID: 83718

Don't Use Cursors or Why You Maybe Should Use a Cursor After All

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Erland Sommarskog

Title: Don't Use Cursors or Why You Maybe Should Use a Cursor After All

Abstract:

You might have heard "don't use cursors, they are slow!". In this presentation, you will learn what actually means: you should normally write set-based statements instead and I will explain why they generally are faster than writing your own loops. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that you implement it properly. The presenation also gives some tips how you can troubleshoot performance problems with loops.

SessionID: 85101

Data Ingestion Tricks w/ M

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Analytics and Visualization

Speaker: Jens Vestergaard

Title: Data Ingestion Tricks w/ M

Abstract:

In this session I will be demonstrating how easy Power BI lets you ingest almost anything; Like

complex multi-file scenarios and tricks to get your data mashed up. While at entry level we would be spending most time in the GUI we will be spending most of the time in this session in the Advanced Editor. In detail we will be looking at these topics: Variable number of columns in multiple files for same source Multiple File Formats (think historical changes in format) Binding Multiple Imports into a single table Error handling Dynamic File Format Handling General Tips ’n Tricks for M

Attending this session, you'll learn the basics of Power BI Desktop, get to see M code in action, as well as learn some neat tricks to get your daily chores done more efficiently. Additionally, I will demonstrate how to deploy your home-grown model into Azure Analysis Services

SessionID: 85143

SQL server window functions

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Martin Hansen

Title: SQL server window functions

Abstract:

All database users know about regular aggregate functions which operate on an entire table and are used with a GROUP BY clause. But few people use Window functions in SQL. These operate on a set of rows and return a single aggregated value for each row.

The main advantage of using Window functions over regular aggregate functions is: Window functions do not cause rows to become grouped into a single output row, the rows retain their separate identities and an aggregated value will be added to each row.

In this session I will walk through the syntax of window functions as well as demonstrate common use cases for where window functions.

SessionID: 77339

Build your next BI solution in azure

Back to calendar

Event Date: 06-10-2018 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Alexander Klein

Title: Build your next BI solution in azure

Abstract:

Azure offers a variety of services that can be combined to form a BI solution in the cloud. What options does Azure currently offer to create a modern BI architecture? The components currently available range from Azure SQL DB and SQL DWH to Data Factory, Stream Analytics, Logic App, Analysis Services and Power BI to name a few. This is a very good toolbox, with which you can achieve your first successes very quickly. Step by step you will learn how to create the classic ETL in the cloud and analyze the results in Power BI.

SessionID: 77653

Azure stream analytics

Back to calendar

Event Date: 06-10-2018 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Nico Jacobs

Title: Azure stream analytics

Abstract:

In many database applications we first log data and then, a few hours or days later, we start analyzing it. But in a world that's moving faster and faster, we sometimes need to analyze what is happening NOW.

Azure Stream Analytics allows you to analyze streams of data while they arrive. In this session you will see how to get started with Stream Analytics. We build and use a real-time application in this session. First we get started with Azure event hubs to collect data, then dive deeper into the temporal queries for analyzing the data.

SessionID: 78646

Automate your SSIS Deployments with VSTS

Back to calendar

Event Date: 06-10-2018 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Bob Duffy

Title: Automate your SSIS Deployments with VSTS

Abstract:

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:

SessionID: 83012

Collecting Performance Metrics

Back to calendar

Event Date: 06-10-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Collecting Performance Metrics

Abstract:

Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

In this session, we will be combining three open source tools - Telegraf, InfluxDB, and Grafana - into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we'll put it all together in an interactive dashboard for easy visualization.

SessionID: 85133

Automation and best practices for ADFv2

Back to calendar

Event Date: 06-10-2018 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bent Pedersen

Title: Automation and best practices for ADFv2

Abstract:

A lot of new functionality and features have been introduced with Azure Data Factory. Using regular SSIS packages you have great flexibility using BIML.

As part of this session we will be looking into the automation functionality for ADFv2 and how you get started with data extraction and best practices using PowerShell for automation.

SessionID: 77341

Azure Cognitive Services - AI for everyone

Back to calendar

Event Date: 06-10-2018 - Session time: 16:30:00 - Track: Cloud Application Development Deployment

Speaker: Alexander Klein

Title: Azure Cognitive Services - AI for everyone

Abstract:

Microsoft Cognitive Services (formerly Project Oxford) are a set of APIs, SDKs, and services that developers can use to make their applications smarter, more engaging, and more discoverable. Cognitive Services extend Microsoft's KI platform.

This is a large playground for young and old. Here you can try out to your heart's content what will be in use tomorrow. With the various building blocks such as Bot Framework, Emotion, Face, Text Analytics or Recommendations, to name but a few, impressive applications can be assembled in a short time.

SessionID: 80852

Database corruption

Back to calendar

Event Date: 06-10-2018 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michal Sadowski

Title: Database corruption

Abstract:

SessionID: 83749

Graph Data in SQL 2017

Back to calendar

Event Date: 06-10-2018 - Session time: 16:30:00 - Track: Application Database Development

Speaker: David Postlethwaite

Title: Graph Data in SQL 2017

Abstract:

When I read that Microsoft have added graph data to SQL Server 2017 I was intrigued as to what graph data is so I started doing some research.

This presentation is the culmination of my investigations. If you design complex OLTP relational databases or have data that doesn't fit the rigid hierarchy of a relational database then this talk is for you. You may be in for a surprise!

Some of the questions we will look at: What is Graph Data? Who uses it? What is it used for? How does it compare to traditional relational database design? What other companies support graph databases? How does it work in SQL 2017? Is there a new language to learn? What is the so-called Kevin Bacon problem?

And finally. Will it replace traditional relational database design within the next 10 years?

SessionID: 85119

End-to-end Business Intelligence solution in Azure

Back to calendar

Event Date: 06-10-2018 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Just Blindbaek

Title: End-to-end Business Intelligence solution in Azure

Abstract:

How do you setup and build a complete Microsoft BI solution with only Azure Services? Lessons learned from a project with eleven different source systems in the one end and 12.000 users in seven countries in the other end.

Extracting, transforming and loading with the help from Functions, Data Factory, Data Lake Store, Polybase, SQL Data Warehouse, SQL Database, Automation Runbooks, Analysis Services and Power BI Embedded.

A look into the overall architecture and the different components and how they work together.

SessionID: 85887

SQL Server Memory Internals Troubleshooting

Back to calendar

Event Date: 06-10-2018 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Amit R S Bansal

Title: SQL Server Memory Internals Troubleshooting

Abstract:

Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. Join Microsoft Certified Master of SQL Server, Amit Bansal, and find your way out from the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. This session will be an eye-opener for you. Assured.