| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:30:00 | Alexander Klein | Cloud Application Development Deployment | Let the Cognitive Services to help you to find your favourite cocktail. |
| 09:30:00 | John Martin | Cloud Application Development Deployment | What are Azure SQL Database Managed Instances? |
| 09:30:00 | Markus Ehrenmueller-Jensen | Analytics and Visualization | Create Stunning Visualizations with The Help of R |
| 09:30:00 | Dagrun Haugland | Application Database Development | T-SQL for dummies |
| 09:30:00 | Terry McCann | Advanced Analysis Techniques | Developing Graph structures with the CosmosDB Gremlin API |
| 09:30:00 | Mladen Prajdić | Enterprise Database Administration Deployment | Getting To Know SQL Server Encryption Capabilities |
| 10:50:00 | Drew Furgiuele | Enterprise Database Administration Deployment | SQL Server and PowerShell: Let's Get Serious |
| 10:50:00 | Grant Fritchey | Application Database Development | Data Protection Privacy in the World of Database DevOps |
| 10:50:00 | Patrick Flynn | Enterprise Database Administration Deployment | Database Internals meets PowerBI |
| 10:50:00 | Bob Pusateri | Cloud Application Development Deployment | Select Stars: A SQL DBA's Introduction to Azure Cosmos DB |
| 10:50:00 | Bartosz Ratajczyk | Application Database Development | Start testing your SSIS packages with ssisUnit |
| 10:50:00 | Ida Bergum | Analytics and Visualization | Storytelling in Power BI with bookmarking, drilltrough, and custom visuals |
| 12:10:00 | Kathi Kellenberger | BI Platform Architecture, Development Administration | Azure Machine Learning 101 |
| 12:10:00 | Grant Fritchey | Cloud Application Development Deployment | Disaster Recovery and High Availability in Azure SQL Database |
| 12:10:00 | Bob Duffy | Cloud Application Development Deployment | Automate your SSIS Deployments with VSTS |
| 12:10:00 | Gabi Münster | BI Platform Architecture, Development Administration | How mature has SSAS Tabular mode become? |
| 12:10:00 | Martin Keseler Barland | Advanced Analysis Techniques | Machine Learning and SQL Server - A match made in heaven? |
| 12:10:00 | Steve Jones | Enterprise Database Administration Deployment | Bringing DevOps to the Database |
| 13:30:00 | SQL Saturday Oslo Sponsor | BI Platform Architecture, Development Administration | Data Warehouse Automation - End-2-End in 20 min by TimeXtender |
| 13:30:00 | John Martin | Other | The Importance of Data Lineage and Assurance Testing |
| 13:30:00 | SQL Saturday Oslo Sponsor | Other | Why Microsoft is building datacenters in Norway by MS Norge |
| 13:50:00 | SQL Saturday Oslo Sponsor | Advanced Analysis Techniques | A focus group: Data Science Readiness by Locke Data |
| 13:50:00 | SQL Saturday Oslo Sponsor | Cloud Application Development Deployment | Azure database perfomance by dbWatch AS |
| 13:50:00 | SQL Saturday Oslo Sponsor | Other | Fast easy deploy of SSAS Tabular with Xpert BI by BI Builders |
| 14:30:00 | Dagrun Haugland | Advanced Analysis Techniques | Python Machine Learning: Would you survive? |
| 14:30:00 | Rob Volk | Enterprise Database Administration Deployment | That's So Metadata: Discover Your Database From the Inside |
| 14:30:00 | Patrick Flynn | Application Database Development | GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects |
| 14:30:00 | Hugo Kornelis | Enterprise Database Administration Deployment | Deep dive into Adaptive Query Processing |
| 14:30:00 | Cathrine Wilhelmsen | BI Platform Architecture, Development Administration | Biml for Beginners: Script and Automate SSIS Development |
| 14:30:00 | Stephanie Locke | Analytics and Visualization | Data Science Fundamentals |
| 15:50:00 | Rob Sewell | Enterprise Database Administration Deployment | dbachecks - The PowerShell Module to validate your SQL Estate |
| 15:50:00 | Simon Whiteley | BI Platform Architecture, Development Administration | Modern Data Warehousing - The Lambda Approach to Azure BI |
| 15:50:00 | Nico Jacobs | Cloud Application Development Deployment | Azure Data Warehouse: Why, What and How |
| 15:50:00 | Antonio Abalos Castillo | Analytics and Visualization | Databricks: the new kid in the block |
| 15:50:00 | Ida Bergum | Analytics and Visualization | Power BI - A look into the future with mixed reality |
| 15:50:00 | Steve Jones | Other | Branding Yourself for a Dream Job |
Event Date: 01-09-2018 - Session time: 09:30:00 - Track: Cloud Application Development Deployment
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?
Event Date: 01-09-2018 - Session time: 09:30:00 - Track: Cloud Application Development Deployment
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.
Event Date: 01-09-2018 - Session time: 09:30:00 - Track: Analytics and Visualization
Event Date: 01-09-2018 - Session time: 09:30:00 - Track: Application Database Development
Event Date: 01-09-2018 - Session time: 09:30:00 - Track: Advanced Analysis Techniques
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.
Event Date: 01-09-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
In this session we'll look at what SQL Server offers in this area:
Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.
Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.
Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Application Database Development
Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
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.
Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Cloud Application Development Deployment
Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Application Database Development
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.
Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Analytics and Visualization
Event Date: 01-09-2018 - Session time: 12:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-09-2018 - Session time: 12:10:00 - Track: Cloud Application Development Deployment
Event Date: 01-09-2018 - Session time: 12:10:00 - Track: Cloud Application Development Deployment
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:
Event Date: 01-09-2018 - Session time: 12:10:00 - Track: BI Platform Architecture, Development Administration
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.
Event Date: 01-09-2018 - Session time: 12:10:00 - Track: Advanced Analysis Techniques
Event Date: 01-09-2018 - Session time: 12:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-09-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
As our platform is Microsoft Azure certified, we effectively support Azure Data Lake, Azure SQL Database and managed instances among others. Additionally, we demonstrate the ease of taking structured data and seamlessly integrating it with data visualization tools such as Power BI, Tableau, Qlik or others.
The session will include steps like:
Event Date: 01-09-2018 - Session time: 13:30:00 - Track: Other
Join John Martin as he explains what these two concepts are, how they work, and why they are important as well as how SentryOne can help solve these problems.
Event Date: 01-09-2018 - Session time: 13:30:00 - Track: Other
Event Date: 01-09-2018 - Session time: 13:50:00 - Track: Advanced Analysis Techniques
Event Date: 01-09-2018 - Session time: 13:50:00 - Track: Cloud Application Development Deployment
To confirm if this is really the case or not, we conducted two tests periods in Azure. One in December 2016 and one in March 2018. Three Service tiers were tested: Basic 5 DTU, Standard S3 100 DTU and Premium P2 250 DTU. The tests have been done at three locations: West Europe, West Japan and West US.
We will present the test methods and harness uses, and the results and findings.
Based on our measurements we have seen:
Event Date: 01-09-2018 - Session time: 13:50:00 - Track: Other
This functionality does not require the rest of the DWH solution to be built with Xpert BI (although recommended).
Event Date: 01-09-2018 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
We will help you get started with machine learning in Python. Python is a powerful open-source programming language that is easy to get started with. It is increasingly incorporated into software, such as Azure Machine Learning.
This session introduces machine learning in Python as well as an overall introduction to the Scikit-learn library. Scikit-learn is a library designed to provide access to well-known machine learning algorithms. The library is open source, developed by hundreds of contributors from around the world and used across industry and academia.
We will show how we use data about the passengers on the Titanic to find out what characterizes the survivors.
Event Date: 01-09-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
SQL Server has a number of metadata facilities available to help you with these tasks, and more. Functions, dynamic management views, and system stored procedures can illuminate details from the smallest column up through an entire SQL Server instance and everything in-between. We will demonstrate metadata techniques to help you:
We'll also demonstrate the new SQL Data Discovery/Classification and Vulnerability Assessment features in SQL Server Management Studio.
Event Date: 01-09-2018 - Session time: 14:30:00 - Track: Application Database Development
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
Event Date: 01-09-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
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!
Event Date: 01-09-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
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!
Event Date: 01-09-2018 - Session time: 14:30:00 - Track: Analytics and Visualization
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.
Event Date: 01-09-2018 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
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
Event Date: 01-09-2018 - Session time: 15:50:00 - Track: BI Platform Architecture, Development Administration
This session will take you through the pattern known as the Lambda architecture, a reference pattern for building data analytics systems that can handle any combination of data velocity, variety and volume. The session will outline the set of tools and integration points that can underpin the approach. Do you design real-time reporting systems? Or crunch petabytes of data? Perhaps you are adopting a cloud architecture and just want to handle anything the future throws at you? This session is for you.
We will follow the movement of data through batch and speed layers via Azure Data Lake Store Analytics and Streaming Analytics before considering the serving layer with Azure SQL DataWarehouse and downstream reporting tools.
Event Date: 01-09-2018 - Session time: 15:50:00 - Track: Cloud Application Development Deployment
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.
Event Date: 01-09-2018 - Session time: 15:50:00 - Track: Analytics and Visualization
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.
Event Date: 01-09-2018 - Session time: 15:50:00 - Track: Analytics and Visualization
Event Date: 01-09-2018 - Session time: 15:50:00 - Track: Other