| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Joseph D'Antoni | Enterprise/ Administration | Azure Managed Instances—Your Bridge to the Cloud |
| 08:30:00 | Kevin Feasel | BI/ Analytics/ Data Scientist | Data Cleansing With SQL And R |
| 08:30:00 | Asgeir Gunnarsson | BI/ Analytics/ Data Scientist | Enterprise Power BI – Development Lifecycle |
| 08:30:00 | Mark Pryce-Maher | Enterprise/ Administration | Data Classification in SQL Server and Azure SQL Database |
| 10:10:00 | Jan Mulkens | BI/ Analytics/ Data Scientist | Enabling Citizen Data Science with Microsoft |
| 10:10:00 | Hugo Kornelis | Developer | Deep dive into Adaptive Query Processing |
| 10:10:00 | Christoph Seck | Enterprise/ Administration | Blockchain - The data platform perspective |
| 10:10:00 | Ivan Campos | Developer | Hiding data with SQL Server |
| 10:10:00 | Satya Jayanty | Enterprise/ Administration | Azure Cosmos DB - What you need to know to build globally distrib |
| 11:25:00 | Terry McCann | BI/ Analytics/ Data Scientist | Using AI to write session submission to SQLSaturday |
| 11:25:00 | Eduardo Piairo | Developer | Adding unit tests with tSQLt to the database deployment pipeline |
| 11:25:00 | Ben Weissman | BI/ Analytics/ Data Scientist | Let’s Build SSIS Packages with Biml – Live! |
| 11:25:00 | Niko Neugebauer | Enterprise/ Administration | Graph Databases and Solutions |
| 11:25:00 | Pedro Sousa | Business/ End user | Open Knowledge Platform Use-Cases |
| 13:45:00 | Kathi Kellenberger | BI/ Analytics/ Data Scientist | Azure Machine Learning 101 |
| 13:45:00 | Isabelle Van Campenhoudt | BI/ Analytics/ Data Scientist | Power BI server and Office Online server, modernize your on-premises BI approach. |
| 13:45:00 | Ewald Cress | Developer | A Gentle Intro to Multi-master Replication |
| 13:45:00 | Mike Byrd | Enterprise/ Administration | Climbing the SQL Server Index B-Tree (from a user perspective) |
| 13:45:00 | Jose Manuel Jurado Diaz | Charity Mini-Con | Back to the future - Migrating our SQL Server OnPremise Database Minicon |
| 15:00:00 | Paul Andrew | BI/ Analytics/ Data Scientist | Azure Data Factory v2 – SSIS Data Flows Custom Extensibility |
| 15:00:00 | Shreeya Subramani | BI/ Analytics/ Data Scientist | Data Science for Kids and beyond |
| 15:00:00 | Anthony Nocentino | Enterprise/ Administration | Monitoring Linux Performance for the SQL Server Admin |
| 15:00:00 | Warwick Rudd | Developer | SQLOpsStudio Vs SSMS - There can be only one |
| 16:15:00 | Jean-Pierre Riehl | BI/ Analytics/ Data Scientist | Azure Data : SELECT People FROM DataLake WHERE HappyFace = TRUE |
| 16:15:00 | Simon Whiteley | BI/ Analytics/ Data Scientist | Modern Data Warehousing - The Lambda Approach to Azure BI |
| 16:15:00 | Anthony Nocentino | Enterprise/ Administration | Containers - You Better Get on Board |
| 16:15:00 | Steve Jones | Business/ End user | Branding Yourself for a Dream Job |
Event Date: 08-09-2018 - Session time: 08:30:00 - Track: Enterprise/ Administration
Microsoft recently introduced Managed Instances—a new option that provides a bridge between on-premises or Azure VM implementations of SQL Server and Azure SQL Database. Managed Instances provide full SQL Server surface compatibility and support database sizes up to 35 TB.
In this session, you will learn about migrating your databases to Managed Instances, developing applications for managed instances. You will also learn about the underlying high availability and disaster recovery options for the solution.
Event Date: 08-09-2018 - Session time: 08:30:00 - Track: BI/ Analytics/ Data Scientist
Event Date: 08-09-2018 - Session time: 08:30:00 - Track: BI/ Analytics/ Data Scientist
These include things like source control, multiple environments, deployment processes, and governance. As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are, these things can get tricky. In this session we will look at what Power BI has to offer when it comes to development lifecycle. We will look at the different options available to the developer when it comes to source control, multiple environments, deployment and distribution of Power BI content. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI. For all these topics we will look at the capabilities Power BI offers and how we, in the company where I work, decided to implement it.
Event Date: 08-09-2018 - Session time: 08:30:00 - Track: Enterprise/ Administration
I run through the need for data classification in general and why its important for GDPR. We will run though classifying your data and how to report on it.
Event Date: 08-09-2018 - Session time: 10:10:00 - Track: BI/ Analytics/ Data Scientist
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.
Event Date: 08-09-2018 - Session time: 10:10:00 - Track: Developer
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: 08-09-2018 - Session time: 10:10:00 - Track: Enterprise/ Administration
What is technically behind the ominous blockchain, what does it have to do with databases and data warehousing? Are smart contracts only interesting for the financiers? And why should you program contracts? In the first part of this session, we deliver the background, and not just technically.
In the second part we take a closer look at the bitcoin blockchain as a "database". Starting point here: How anonymous really is the whole thing, when everything must be visible to everyone? After a brief introduction to its structure, we load the blockchain of bitcoin (that is, all the transactions that have been done so far) into Neo4J, a graph database and look what analyzes are possible (and why does a Graph DB work better here? And why aren’t we using the new exciting Graph stuff of SQL Server 2017???) Visualization and further analysis we do with Power BI, directly connected to Neo4j.
Event Date: 08-09-2018 - Session time: 10:10:00 - Track: Developer
Event Date: 08-09-2018 - Session time: 10:10:00 - Track: Enterprise/ Administration
Event Date: 08-09-2018 - Session time: 11:25:00 - Track: BI/ Analytics/ Data Scientist
We will then turn our new skills to the problem most speakers have! Writing session abstracts. Together we will develop a recursive neural net designed to generate new SQLSaturday session abstracts, entirely based on previously submitted sessions to SQLSaturday. Will we be able to produce a session you would have attended? Come along and fine out.
Event Date: 08-09-2018 - Session time: 11:25:00 - Track: Developer
Unit tests at database level can help avoiding breaking the contract with the applications that consume data from the database, and also can help ensuring database correct behavior (for example: a stored procedure do what’s supposed to do, or a specific table indeed exists). In this talk I will address the basic steps to introduce unit tests at databases using tSQLt. tSQLt is a unit testing framework the allow to write, execute and diagnose tests for T-SQL code. After writing the tests, I will explore how can tests execution be include in the deployment pipeline.
Event Date: 08-09-2018 - Session time: 11:25:00 - Track: BI/ Analytics/ Data Scientist
Let’s see, how that goes…
PS: Even if you have not heard about Biml but are still tired of manually building SSIS packages, this is the right session for you!
Event Date: 08-09-2018 - Session time: 11:25:00 - Track: Enterprise/ Administration
Even though one can implement eventually everything with a relational engine, the bigger amount of analysed data is involved, the less probable is that your analysis will be done on time and with acceptable ease for the developers.
Graph databases do exist in the wild since 1960s, but only in the last 2 decades - with the advances of the internet, started to conquer wider recognition and usage.
Let's dive into this diverse world of graph databases and discover the new kid on the block - the GraphDB in SQL Server 2017 Azure SQL Database, which promises to allow you to expand and convert your workloads for solving modern connected world problems.
Event Date: 08-09-2018 - Session time: 11:25:00 - Track: Business/ End user
CKAN is a tool for making open data websites. (Think of a content management system like WordPress – but for data, instead of pages and blog posts.) It helps you manage and publish collections of data. It is used by national and local governments, research institutions, and other organizations who collect a lot of data.
In this talk I'll go over some use-cases of Open Knowledge Platform implementations by the Portuguese Government, the architectural features, the difficulties and different approaches to solve them.
Event Date: 08-09-2018 - Session time: 13:45:00 - Track: BI/ Analytics/ Data Scientist
Event Date: 08-09-2018 - Session time: 13:45:00 - Track: BI/ Analytics/ Data Scientist
How to refresh your BI solution by providing the beauty of Power BI reports on premises and the ability from the same place to consume your legacy reports or to share efficiently your data model through a unique place. Demo based session with a strong architecture introduction and a "from the field" real project feedback.
Event Date: 08-09-2018 - Session time: 13:45:00 - Track: Developer
Conflict-free replicated data types (CRDTs) evolved as a way to accept updates at multiple replicas with automatic conflict resolution, and to remove such concerns from application development. Inevitably though, you have to apply a different mindset to data design.
In this talk, I'll cover the basic premise of what CRDTs are, a few example CRDTs, the kind of programming interface they expose, and a glimpse into their internal workings. While the literature in this area tends to be a bit academic, we'll be taking a commonsense approach, giving you a useful toehold into the subject for further exploration.
Event Date: 08-09-2018 - Session time: 13:45:00 - Track: Enterprise/ Administration
• keep clustered index width small • unique indexes perform better • keep non-clustered index width small • compressed indexes have fewer logical reads This session dives down and looks at important items within index pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command to factually document index WOMs. The effect of row data compression on clustered and non-clustered indexes are also investigated. The demos will ascertain how the SQL Server® optimizer might use them and strive to gain some insight from a performance advantage. The session is 80% demos. This presentation will propel the layman to a new level of index understanding. Performance! That’s what we are all looking for. Blast off with this presentation.
Event Date: 08-09-2018 - Session time: 13:45:00 - Track: Charity Mini-Con
Only 8 slots available for this special intimate charity 2-hour mini-con session on SQL Server migration to Azure by two of Microsoft Espana's top escalation engineers! https://www.eventbrite.co.uk/e/migrating-our-sql-server-onpremise-database-to-azure-tickets-48645214145
This session will cover the main aspects required to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise.
In this workshop we will cover:
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 will address several outstandin
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: BI/ Analytics/ Data Scientist
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: BI/ Analytics/ Data Scientist
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: Enterprise/ Administration
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: Developer
In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.
Event Date: 08-09-2018 - Session time: 16:15:00 - Track: BI/ Analytics/ Data Scientist
From different media files and raw data, we will analyze sentiment of characters and get valuable information in a Power BI dashboard, using Cognitive Services, CNTK, .NET and U-SQL. This session will mainly showcase Azure Data Lake and U-SQL language. But demos will involve different tools like Azure Data Factory for data supply chain and orchestration, Azure SQL Database for corporate data or even Machine Learning technics. Even if this session is demo-driven, concepts and features of Azure Data technologies will be discussed
Event Date: 08-09-2018 - Session time: 16:15:00 - Track: BI/ Analytics/ Data Scientist
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: 08-09-2018 - Session time: 16:15:00 - Track: Enterprise/ Administration
In this session we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes
Event Date: 08-09-2018 - Session time: 16:15:00 - Track: Business/ End user