| 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 |
Event Date: 12-05-2018 - Session time: 09:00:00 - Track: Application Database Development
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…
Event Date: 12-05-2018 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
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).
Event Date: 12-05-2018 - Session time: 09:00:00 - Track: Enterprise Database Architecture, Administration Deployment
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.
Event Date: 12-05-2018 - Session time: 09:00:00 - Track: Enterprise Database Architecture, Administration Deployment
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.
Event Date: 12-05-2018 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
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?
Event Date: 12-05-2018 - Session time: 10:15:00 - Track: Enterprise Database Architecture, Administration Deployment
The session covers primarily SQL Server 2012 to 2016, with SQL Server 2017 thrown in for good measure.
Event Date: 12-05-2018 - Session time: 10:15:00 - Track: Advanced Analysis Techniques Machine Learning
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: 12-05-2018 - Session time: 10:15:00 - Track: Other
Event Date: 12-05-2018 - Session time: 12:15:00 - Track: Enterprise Database Architecture, Administration Deployment
Event Date: 12-05-2018 - Session time: 12:15: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: 12-05-2018 - Session time: 12:15:00 - Track: Analytics and Visualization
Event Date: 12-05-2018 - Session time: 12:15:00 - Track: Other
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.
Event Date: 12-05-2018 - Session time: 12:45:00 - Track: Other
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
Event Date: 12-05-2018 - Session time: 13:30:00 - Track: Enterprise Database Architecture, Administration Deployment
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
Event Date: 12-05-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
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.
Event Date: 12-05-2018 - Session time: 13:30:00 - Track: Application 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: 12-05-2018 - Session time: 14:00:00 - Track: Other
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.
Event Date: 12-05-2018 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
Event Date: 12-05-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 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!
Event Date: 12-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Architecture, Administration Deployment
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.
Event Date: 12-05-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
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!
Event Date: 12-05-2018 - Session time: 15:45:00 - Track: Analytics and Visualization
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!
Event Date: 12-05-2018 - Session time: 15:45:00 - Track: Enterprise Database Architecture, Administration Deployment
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.
Event Date: 12-05-2018 - Session time: 15:45:00 - Track: Application Database Development
Event Date: 12-05-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration