| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:30:00 | Ida Bergum | BI Analytics Visualization | Governing Power BI in large organizations, A story from a global classification company |
| 09:30:00 | Sergiy Lunyakin | BI Architecture Development | Azure SQL DWH: Tips and Tricks for developers |
| 09:30:00 | Patrick Flynn | Other | Database Corruption - Advanced Recovery Techniques |
| 09:30:00 | Aaron Bertrand | Database Development | T-SQL : Bad Habits and Best Practices |
| 09:30:00 | Christopher Adkin | Database Administration | The All Flash DBA |
| 10:50:00 | Anders Pedersen | Database Development | I/O Tuning 101 |
| 10:50:00 | Antonio Abalos Castillo | Azure and Cloud Services | IoT 101 with Raspberry Pi and Azure |
| 10:50:00 | Daniel Hutmacher | Database Administration | Understanding SQL Server security |
| 10:50:00 | André Kamman | Database Administration | SQL Server and Docker. What, How and Why |
| 10:50:00 | Ginger Grant | BI Analytics Visualization | Power BI Admin. and Best Practices Implementation Techniques |
| 12:10:00 | John Martin | Other | Always On Multi-Site Patterns |
| 12:10:00 | Jens Vestergaard | BI Architecture Development | BI DevOps |
| 12:10:00 | Kjetil Åmdal-Sævik | Azure and Cloud Services | Deep Learning as a Service with TensorFlow in Azure Machine Learning – an example from Elkjøp Nordic |
| 12:10:00 | Erland Sommarskog | Database Development | Dynamic Search Conditions |
| 12:10:00 | Ben Emmett | Database Administration | Entity Framework for the DBA |
| 13:30:00 | SQLSaturday Oslo Sponsor | Other | SentryOne - tools for productivity and performance (part 1) |
| 13:50:00 | SQLSaturday Oslo Sponsor | Other | SentryOne - tools for productivity and performance (part 2) |
| 13:50:00 | SQLSaturday Oslo Sponsor | Other | Consolidation of SQL Server environments made easy by dbWatch AS |
| 13:50:00 | SQLSaturday Oslo Sponsor | Other | Why do Webstep believe Software is crucial to the success of IoT by Webstep IoT |
| 13:50:00 | SQLSaturday Oslo Sponsor | Other | Capgemini |
| 13:50:00 | SQLSaturday Oslo Sponsor | Azure and Cloud Services | GDPR and Master Data Management by Profisee |
| 14:30:00 | Martin Keseler Barland | BI Analytics Visualization | Data Visualisation - More Than a Hygiene Factor |
| 14:30:00 | Jason Hall | Database Administration | Introduction to SQL Server on Linux |
| 14:30:00 | Aaron Bertrand | Database Development | New T-SQL Features : SQL Server 2016, 2017, and Azure SQL DB |
| 14:30:00 | André Kamman | Azure and Cloud Services | Best practises when migrating to the cloud |
| 14:30:00 | Bjoern H Rapp | Azure and Cloud Services | Introduction to Cosmos DB |
| 14:30:00 | Erik Flateby | BI Architecture Development | Best friends: SQL Server 2017, Python and Bitcoin! |
| 15:50:00 | André Melancia | Database Administration | Hacking SQL Server |
| 15:50:00 | David Postlethwaite | Database Administration | An introduction to Query Store |
| 15:50:00 | Alexander Klein | BI Architecture Development | Build your next BI landscape in the cloud with SaaS components |
| 15:50:00 | Helge Rege Gårdsvoll | Azure and Cloud Services | Making your Data Lake smarter with Cognitive Services |
| 15:50:00 | Alex Yates | Database Development | Getting CI right for SQL Server |
Event Date: 02-09-2017 - Session time: 09:30:00 - Track: BI Analytics Visualization
Event Date: 02-09-2017 - Session time: 09:30:00 - Track: BI Architecture Development
Event Date: 02-09-2017 - Session time: 09:30:00 - Track: Other
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!
Event Date: 02-09-2017 - Session time: 09:30:00 - Track: Database Development
In this session, you will learn about several bad habits, how they develop, and how you can avoid them. While we will briefly discuss advice you’ve probably heard before, like avoid SELECT * and be careful with NOLOCK, you will also learn some subtleties in SQL Server that might surprise you, how some shorthand can bite you in the long run, and a very easy way to improve cursor performance.
By changing your techniques and ditching some of these bad habits for best practices, you will take new techniques back to your environment that will lead to more efficient code, a more productive workflow, or both.
Event Date: 02-09-2017 - Session time: 09:30:00 - Track: Database Administration
Event Date: 02-09-2017 - Session time: 10:50:00 - Track: Database Development
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.
Event Date: 02-09-2017 - Session time: 10:50:00 - Track: Azure and Cloud Services
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.
Event Date: 02-09-2017 - Session time: 10:50:00 - Track: Database Administration
Event Date: 02-09-2017 - Session time: 10:50:00 - Track: Database Administration
Event Date: 02-09-2017 - Session time: 10:50:00 - Track: BI Analytics Visualization
are a number of decisions and practices, which if made early in the process can prevent problems.
Attendees to this session will learn the best practice methods for administering Power BI from
visualization creation to deployment. These concepts will assist to provide a successful implementation
which will scale to be able to support large deployments. Learn how to balance the needs of creating an
environment for analyst to create visualizations while balancing the desires of the data team to provide
consistent single sources of the data for reporting.
Wondering what would be gained by adding Power BI Premier edition or whether or not you can
decrease the reporting cost footprint by using Power BI Report Server? Find out what criteria can be
used to provide a good fit.
This session will also cover an in-depth dive to the administration and security feature
Event Date: 02-09-2017 - Session time: 12:10:00 - Track: Other
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.
Event Date: 02-09-2017 - Session time: 12:10:00 - Track: BI Architecture Development
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)
Event Date: 02-09-2017 - Session time: 12:10:00 - Track: Azure and Cloud Services
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.
Event Date: 02-09-2017 - Session time: 12:10:00 - Track: Database Development
Event Date: 02-09-2017 - Session time: 12:10:00 - Track: Database Administration
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.
Event Date: 02-09-2017 - Session time: 13:30:00 - Track: Other
Event Date: 02-09-2017 - Session time: 13:50:00 - Track: Other
Event Date: 02-09-2017 - Session time: 13:50:00 - Track: Other
Speaker: Per Christopher Undheim Senior DBA dbWatch AS
Event Date: 02-09-2017 - Session time: 13:50:00 - Track: Other
Event Date: 02-09-2017 - Session time: 13:50:00 - Track: Other
Event Date: 02-09-2017 - Session time: 13:50:00 - Track: Azure and Cloud Services
Event Date: 02-09-2017 - Session time: 14:30:00 - Track: BI Analytics Visualization
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.
Event Date: 02-09-2017 - Session time: 14:30:00 - Track: Database Administration
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
Event Date: 02-09-2017 - Session time: 14:30:00 - Track: Database Development
Event Date: 02-09-2017 - Session time: 14:30:00 - Track: Azure and Cloud Services
Event Date: 02-09-2017 - Session time: 14:30:00 - Track: Azure and Cloud Services
Event Date: 02-09-2017 - Session time: 14:30:00 - Track: BI Architecture Development
Event Date: 02-09-2017 - Session time: 15:50:00 - Track: Database Administration
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.
Event Date: 02-09-2017 - Session time: 15:50:00 - Track: Database Administration
In this session we will examine Query Store, it's architecture, configuration and how it can be used to solve performance problems.
Event Date: 02-09-2017 - Session time: 15:50:00 - Track: BI Architecture Development
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.
Event Date: 02-09-2017 - Session time: 15:50:00 - Track: Azure and Cloud Services
Event Date: 02-09-2017 - Session time: 15:50:00 - Track: Database Development
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.