sqlsathistory

Nr: 735

Back to Main list

SQLSaturday #735 - Finland 2018

Start Time (24h) Speaker Track Title
09:00:00 André Melancia Application Database Development Hacking? Mission Possible!
09:00:00 Jose Mendes Cloud Application Development Deployment Chatbots for Dummies
09:00:00 Maria Zakourdaev Enterprise Database Architecture, Administration Deployment Python revolution in SQL Server world
09:00:00 Olli Lindroos Enterprise Database Architecture, Administration Deployment Case Transparent Supply Chain using Azure Data Services
10:15:00 Jose Manuel Jurado Diaz Cloud Application Development Deployment Back to the future - Migrating our SQL Server OnPremise Database to Azure
10:15:00 Alexander Arvidsson Enterprise Database Architecture, Administration Deployment Boring is stable, stable is good - best practices in practice
10:15:00 Jan Mulkens Advanced Analysis Techniques Machine Learning Enabling Citizen Data Science with Microsoft
10:15:00 Arun Justus Other Introducing Azure SQL DW – Architecture Best Practices
12:15:00 Matt Gordon Enterprise Database Architecture, Administration Deployment New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups
12:15:00 John Martin Cloud Application Development Deployment What are Azure SQL Database Managed Instances?
12:15:00 Heidi Enho Analytics and Visualization New Data Visualization Features in Power BI
12:15:00 SQLSaturday Finland Other Automate DWH BI development using TimeXtender Discovery Hub®
12:45:00 SQLSaturday Finland Other Lifting the lid on SQL Server on Linux
13:30:00 Rob Sewell Enterprise Database Architecture, Administration Deployment Administrating SQL Server with PowerShell dbatools
13:30:00 Johan Ludvig Brattås BI Platform Architecture, Development Administration Implementing a hybrid data warehouse
13:30:00 Anders Pedersen Application Database Development I/O Tuning 101
14:00:00 SQLSaturday Finland Other Experts should work with facts, not guesstimates
14:30:00 Marcos Freccia Cloud Application Development Deployment Working smarter, not harder with Azure SQL Database
14:30:00 Cathrine Wilhelmsen BI Platform Architecture, Development Administration Biml for Beginners: Script and Automate SSIS Development
14:30:00 Christophe Laporte Enterprise Database Architecture, Administration Deployment SQL Server inside a Docker container
14:30:00 Vesa Tikkanen BI Platform Architecture, Development Administration I know Microsoft Data Platform R but where is the intersection?
15:45:00 Andrea Martorana Tusa Analytics and Visualization Custom maps in Power BI
15:45:00 Gianluca Sartori Enterprise Database Architecture, Administration Deployment Responding to Extended Events in near real-time
15:45:00 Erland Sommarskog Application Database Development Dynamic Search Conditions
15:45:00 Oskari Heikkinen BI Platform Architecture, Development Administration New capabilities of Azure Data Factory v2

SessionID: 71630

Hacking? Mission Possible!

Back to calendar

Event Date: 12-05-2018 - Session time: 09:00:00 - Track: Application Database Development

Speaker: André Melancia

Title: Hacking? Mission Possible!

Abstract:

Everthing is connected. Everything is accessible. Everything is hackable.

This is a security "worst" practices session for developers (yes, yes, the boring "best" practices are also included). As always, should you or any of your colleagues be hacked or exploited, the Demo Gods will disavow any knowledge of the speakers' actions. This session will self-destruct in 60 minutes. Luck has nothing to do with it, Jim…

SessionID: 72715

Chatbots for Dummies

Back to calendar

Event Date: 12-05-2018 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Jose Mendes

Title: Chatbots for Dummies

Abstract:

The software development landscape is changing. More and more, there is an increased demand for AI and cloud solutions. As a user buying cinema tickets online, I would like to simply ask "I want to buy two cinema tickets for the movie Dunkirk, tomorrow's viewing at 1pm" instead of manually following a pre-defined process.

In this session, we will learn how to build, debug and deploy a chatbot using the Azure Bot Service. We will enrich it using the Microsoft Cognitive suite to achieve human like interactions.

Will it pass the Turing test, no, but we can extend the bot service using Machine Learning (LUIS), APIs (Web Apps) and Worflows (Logic Apps).

SessionID: 72929

Python revolution in SQL Server world

Back to calendar

Event Date: 12-05-2018 - Session time: 09:00:00 - Track: Enterprise Database Architecture, Administration Deployment

Speaker: Maria Zakourdaev

Title: Python revolution in SQL Server world

Abstract:

Machine learning is not the only usecase for this wonderful feature, it can solve many challenges when dealing with text files, bulk loads and even simplify ETL flows when you need to move data from databases other than SQL Server. Moreover, you can offload the big data querying to nosql database and use Python to get the results into SQL server.

Target Audience: Application and Infrastructure DBAs that want to see various usages for Python language from inside SQL Server stored procedures.

SessionID: 80588

Case Transparent Supply Chain using Azure Data Services

Back to calendar

Event Date: 12-05-2018 - Session time: 09:00:00 - Track: Enterprise Database Architecture, Administration Deployment

Speaker: Olli Lindroos

Title: Case Transparent Supply Chain using Azure Data Services

Abstract:

Welcome to join this session to hear more about data platform that integrates umbarella organization's all different data touch points to new single source of truth.

In this webinar Olli Lindroos from Solita will go through how they have developed multiple organisation wide data platforms. See how for example Azure Data Lake and Power BI were leveraged in this solution and hear best practices from the project.

SessionID: 71686

Back to the future - Migrating our SQL Server OnPremise Database to Azure

Back to calendar

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

Speaker: Jose Manuel Jurado Diaz

Title: Back to the future - Migrating our SQL Server OnPremise Database to Azure

Abstract:

We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise.

This session consists of: -> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse. -> Best Practices and best tools for our migration process depending on the platform chosen. -> After the migration, we have several outstanding questions: Can I keep both environments synchronized? How is the performance of my database?

SessionID: 72593

Boring is stable, stable is good - best practices in practice

Back to calendar

Event Date: 12-05-2018 - Session time: 10:15:00 - Track: Enterprise Database Architecture, Administration Deployment

Speaker: Alexander Arvidsson

Title: Boring is stable, stable is good - best practices in practice

Abstract:

Everybody is talking about best practices, and like standards, most everybody has them. But why do they look like they do, and why would you use a specific set of "best practices" that someone has put together? This session goes through my set of best practices that I've accumulated over 20 years of DBA work, disassembles each and every one of them to see how they came about and discusses why I still use them - or don't. There is no such thing as the ultimate best practices, but I aim to provide the attendee with as much food for thought as possible in order to let each and everyone decide on their own path forward for their own set of best practices.

The session covers primarily SQL Server 2012 to 2016, with SQL Server 2017 thrown in for good measure.

SessionID: 73985

Enabling Citizen Data Science with Microsoft

Back to calendar

Event Date: 12-05-2018 - Session time: 10:15:00 - Track: Advanced Analysis Techniques Machine Learning

Speaker: Jan Mulkens

Title: Enabling Citizen Data Science with Microsoft

Abstract:

In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics.

Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure. These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about creating fools-with-tools or should we embrace the democratization of data science as the golden age of data? In this demo heavy session we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.

SessionID: 78948

Introducing Azure SQL DW – Architecture Best Practices

Back to calendar

Event Date: 12-05-2018 - Session time: 10:15:00 - Track: Other

Speaker: Arun Justus

Title: Introducing Azure SQL DW – Architecture Best Practices

Abstract:

Azure SQL Datawarehouse is a petabyte range Massively Parallel Processing Datawarehouse provided as a managed service in Azure. This session will delve into the architecture, new optimized for compute instances, common workload and implementation patterns, performance considerations, loading patterns and strategies and some real-life customer deployment examples.

SessionID: 72720

New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups

Back to calendar

Event Date: 12-05-2018 - Session time: 12:15:00 - Track: Enterprise Database Architecture, Administration Deployment

Speaker: Matt Gordon

Title: New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups

Abstract:

Microsoft has added new performance improvements and new features to SQL Server 2016 and 2017’s implementation of Always On Availability Groups. This session will cover improvements that range from Standard Edition support for AGs to load balanced replicas to new ways to create those replicas. We’ll kick the tires on the improved Azure support and discuss the massive performance improvements in Always On as well.

SessionID: 73345

What are Azure SQL Database Managed Instances?

Back to calendar

Event Date: 12-05-2018 - Session time: 12:15:00 - Track: Cloud Application Development Deployment

Speaker: John Martin

Title: What are Azure SQL Database Managed Instances?

Abstract:

The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are and how you might start using them.

Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server. Including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges to using Azure SQL Databases.

But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology.

SessionID: 80781

New Data Visualization Features in Power BI

Back to calendar

Event Date: 12-05-2018 - Session time: 12:15:00 - Track: Analytics and Visualization

Speaker: Heidi Enho

Title: New Data Visualization Features in Power BI

Abstract:

Join this session by Heidi Enho, Power BI consultant, Microsoft Certified Trainer, Data Platform and Excel MVP. Learn how to use Power BI bookmarks, buttons, drill-through filters and for example brand new report tooltips to communicate insights in your data. Heidi will show in this highly demo based session many examples and tips how to use new navigation and storytelling capabilities.

SessionID: 80783

Automate DWH BI development using TimeXtender Discovery Hub®

Back to calendar

Event Date: 12-05-2018 - Session time: 12:15:00 - Track: Other

Speaker: SQLSaturday Finland

Title: Automate DWH BI development using TimeXtender Discovery Hub®

Abstract:

Speaker: Mahmoud Ismail Mahmoud is a Solution Architect in TimeXtenders Customer Service Success team and has significant experience in implementing and utilizing the Discovery Hub in a number of industries and sectors. He also has excellent knowledge in regards to data modelling for both Qlik applications, OLAP Cubes and Tabular models. He takes part in a lot of projects ranging, from presales, training consulting and hands-on DWA developing.

SessionID: 80782

Lifting the lid on SQL Server on Linux

Back to calendar

Event Date: 12-05-2018 - Session time: 12:45:00 - Track: Other

Speaker: SQLSaturday Finland

Title: Lifting the lid on SQL Server on Linux

Abstract:

In this session, database expert Martin Wild of Quest Software will lift the lid on SQL Server on Linux. He’ll explore the mechanics of deploying SQL Server on Linux, what is and is not in the current Linux build and discuss quirks, insights and observations on setup and configuration. Once the stage is set, Martin will cover tuning and performance on Linux and bring you through some new DMVs for Linux monitoring. He’ll then compare the plans produced on Linux vs. Windows for consistency… or not!

Speaker: Martin Wild Martin Wild is a principal systems consultant at Quest. He frequently presents at SQL Server events such as SQL Bits and SQL Saturdays, and Oracle user groups. Martin has expertise with Oracle, SQL Server, Sybase, DB2, Windows, UNIX, Linux, VMware and Hyper-V. He has worked in IT for more than 30 years, initially in manufacturing and retail organizations. For the last 17 years he has held various database pre-sales roles and is a member of the British Computer Society

SessionID: 71660

Administrating SQL Server with PowerShell dbatools

Back to calendar

Event Date: 12-05-2018 - Session time: 13:30:00 - Track: Enterprise Database Architecture, Administration Deployment

Speaker: Rob Sewell

Title: Administrating SQL Server with PowerShell dbatools

Abstract:

Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.

Afraid of PowerShell? Worried its too complicated? Don't want to go through the learning curve?

Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday

Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session

SessionID: 72439

Implementing a hybrid data warehouse

Back to calendar

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

Speaker: Johan Ludvig Brattås

Title: Implementing a hybrid data warehouse

Abstract:

The last couple of years have seen the emergency of "Big Data", "Cloud" and "Internet of Things". Subsequently, Gartner at the 2016 Gartner Summit in Barcelona declared the Enterprise data warehouse (EDW) as dead.

Which of course is silly. Sensible companies don't just throw money out of the window. But they need to adapt and change when new opportunities arrive. Enter the hybrid data warehouse. Combining the power of big data and cloud with your trusty EDW.

This session will take a look at a few different approaches to a hybrid data warehouse, with components such as SQLServer 2016, Azure Data Lake, HDInsight, Azure Analysis Services, Azure SQL Data warehouse and Polybase, with some scenarios where the approaches might become relevant. And some pitfalls you need to know about along the way.

SessionID: 72983

I/O Tuning 101

Back to calendar

Event Date: 12-05-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Anders Pedersen

Title: I/O Tuning 101

Abstract:

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.

SessionID: 81945

Experts should work with facts, not guesstimates

Back to calendar

Event Date: 12-05-2018 - Session time: 14:00:00 - Track: Other

Speaker: SQLSaturday Finland

Title: Experts should work with facts, not guesstimates

Abstract:

Experts should work with facts, not guesstimates – how you learn to love large scale SQL Server consolidation projects

Have you ever been struggling with the consolidation or migration planning of a sizable SQL Server platform? Traditional data platform capacity planning contains a lot of time consuming manual work and is often based on rough estimates. It is seen more as a task for the data platform architect than a mathematical challenge. The truth is: It is both. Find out how to achieve highly automatized, perfectly optimized plan, based on facts rather than guesswork!

Speaker: Jani K. Savolainen. Founder CTO @ DB Pro.

SessionID: 71743

Working smarter, not harder with Azure SQL Database

Back to calendar

Event Date: 12-05-2018 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Marcos Freccia

Title: Working smarter, not harder with Azure SQL Database

Abstract:

Azure SQL DB brings a lot of benefits for new and existing workloads. In this session we are going to explore the various aspects of an Azure SQL DB. How we can have a self managed, high available and high performing Database. Properly monitoring is also an important part of the job and we will cover several aspects of monitoring an Azure SQL DB. After this session you will feel comfortable in moving your workload to the cloud.

SessionID: 71880

Biml for Beginners: Script and Automate SSIS Development

Back to calendar

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

Speaker: Cathrine Wilhelmsen

Title: Biml for Beginners: Script and Automate SSIS Development

Abstract:

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

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

In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.

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!

SessionID: 71893

SQL Server inside a Docker container

Back to calendar

Event Date: 12-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Architecture, Administration Deployment

Speaker: Christophe Laporte

Title: SQL Server inside a Docker container

Abstract:

Still unthinkable a few years ago, Microsoft’s strategy toward the Open Source world is shaking the computer sphere.

Bare metal or virtual machine, SQL Server can now be installed on a Windows OS or… on Linux. In parallel, DevOps culture and micro services seem to be the architecture model for the decade. Docker containers offers IT Pros or Developers interesting scenarios. During this discovery session let’s install Docker, create a first container, install SQL Server and then commit the image for future use. We will also pull an official SQL Server image and walk through some use cases.

SessionID: 80655

I know Microsoft Data Platform R but where is the intersection?

Back to calendar

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

Speaker: Vesa Tikkanen

Title: I know Microsoft Data Platform R but where is the intersection?

Abstract:

Ok, I know Microsoft Data Platform and I know R but where is the intersection?? What can I use and where?

In-Database R, Power BI with R, ML Server… there are a lot of tools where we have R included but what can you do with them? In this session we will go through the offering with simple examples and talk openly about what is good and what needs improvements. If you’re data platform specialist that needs to talk with data scientists about possibilities this session is for you! If you’re data scientist and want to know the contact points in Microsoft Data Plat this is very well also for you!

SessionID: 71642

Custom maps in Power BI

Back to calendar

Event Date: 12-05-2018 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Andrea Martorana Tusa

Title: Custom maps in Power BI

Abstract:

Let’s go beyond the standard visuals available in Power BI for making maps. In this session we won’t talk about Bing or ArcGIS services. We want to explore all the available features for creating custom maps without having to rely on existing ones.

Do you know what is a shapefile? Do you know how to create your own choropleth and import it into Power BI? What else? R support into Power BI opened the doors to the huge number of packages for spatial data analysis and statistical calculations included in the environment. Do you want to draw multi-layered interactive maps? Want to geocode your data with direct calls? With R in Power BI, now you can. Last but least, we will able to discover Synoptic Panel, an awesome component that connects areas in a custom image with attributes in the data model and draws the data on a map. There are endless possibilities; the only limit is your imagination!

SessionID: 72390

Responding to Extended Events in near real-time

Back to calendar

Event Date: 12-05-2018 - Session time: 15:45:00 - Track: Enterprise Database Architecture, Administration Deployment

Speaker: Gianluca Sartori

Title: Responding to Extended Events in near real-time

Abstract:

Extended Events provide deep insight into SQL Server's behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, Extended Events don't seem to provide a way to react to the events as soon as they happen.

In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems, such as capturing and notifying deadlocks or blocking sessions. We will also offer a different approach to analyzing captured events, without shredding XML files.

SessionID: 73048

Dynamic Search Conditions

Back to calendar

Event Date: 12-05-2018 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Erland Sommarskog

Title: Dynamic Search Conditions

Abstract:

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 isboth 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.

SessionID: 78932

New capabilities of Azure Data Factory v2

Back to calendar

Event Date: 12-05-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Oskari Heikkinen

Title: New capabilities of Azure Data Factory v2

Abstract:

Azure Data Factory v1 has not been considered a full blown ETL solution on the market. Data Factory v2 is now introduced to fill in the gaps. We will deliver the understanding of the different features functionalities of both versions as well as a summary comparison between the two. We will also demonstrate the latest and greatest capabilities by orchestrating an end-to-end pipeline with Data Factory v2 including machine learning workloads with Azure DataBricks.