| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:00:00 | Andrzej Kukula | Enterprise Database Administration Deployment | Introduction to SQL Server v.Next for Linux |
| 10:00:00 | Scott Hudson | BI Platform Architecture, Development Administration | Is Power BI Enterprise ready? |
| 10:00:00 | Anton Boyko | Cloud Application Development Deployment | Creating data-driven serverless apps with Azure Functions |
| 10:00:00 | Gavin Campbell | Application Database Development | Database Continuous Delivery on the Microsoft Platform |
| 10:00:00 | Margarita Naumova | Enterprise Database Administration Deployment | Adaptive Query Processing in SQL Server 2017 |
| 11:15:00 | Sergiy Lunyakin | BI Platform Architecture, Development Administration | Cloud BI with Azure Analysis Services |
| 11:15:00 | Jan Mulkens | Advanced Analysis Techniques | Enabling Citizen Data Science with Microsoft |
| 11:15:00 | Ivan Donev | Application Database Development | Real world DevOps - challenges, tools and solutions |
| 11:15:00 | Sacha Tomey | Analytics and Visualization | In-database Predictive Analytics with SQL Server 2017 |
| 11:15:00 | Callum Green | BI Information Delivery | Power BI: Performance Tips Tricks |
| 13:15:00 | Dejan Sarka | BI Platform Architecture, Development Administration | Anomaly Detection |
| 13:15:00 | Gilberto Zampatti | Professional Development | How Indexes and Statistics can improve performance of our databases |
| 13:15:00 | Andrey Nikolov | Application Database Development | Creating “Always Encrypted” applications |
| 13:15:00 | Catalin Gheorghiu | Application Database Development | SQL database on IoT devices, could you? should you? would you? |
| 13:15:00 | Kamil Nowinski | Enterprise Database Administration Deployment | Data replication - who with whom, for whom, why and for what? |
| 14:30:00 | Miroslav Dimitrov | BI Platform Architecture, Development Administration | PowerBI for Rookies |
| 14:30:00 | Ivelin Andreev | Analytics and Visualization | Machine Learning for IoT - Unpacking the blackbox |
| 14:30:00 | Marcin Szeliga | Advanced Analysis Techniques | State-of-the-Art Machine Learning Algorithms in R from Microsoft |
| 14:30:00 | Tsvetozar Ivanov | Enterprise Database Administration Deployment | How GDPR affect most common DBA maintenance tasks |
| 14:30:00 | Daniel Joskovski | Cloud Application Development Deployment | USE CASE: LOCALDB |
| 15:45:00 | Oliver Frost | BI Information Delivery | Exploring Dark Data with SQL Server 2016 and R [EN] |
| 15:45:00 | André Melancia | Enterprise Database Administration Deployment | Hacking SQL Server |
| 15:45:00 | Matt How | BI Platform Architecture, Development Administration | Master your Data in the Cloud with Power Apps and Logic Apps |
| 15:45:00 | Rozalina Zaharieva | Enterprise Database Administration Deployment | I am a DBA! "What's next"? |
| 15:45:00 | Miroslav Lessev | Advanced Analysis Techniques | GDPR compliant by design |
| 17:00:00 | Markus Ehrenmueller-Jensen | Advanced Analysis Techniques | From SQL to R – Leverage Your T-SQL Knowledge to Learn R |
| 17:00:00 | Erland Sommarskog | Application Database Development | Dynamic Search Conditions |
| 17:00:00 | Rudi Bruchez | Application Database Development | Discover the new graph features of SQL Server 2017 |
| 17:00:00 | Simon Whiteley | BI Platform Architecture, Development Administration | Logic Apps - Data Orchestration in Azure |
| 17:00:00 | Mihail Mateev | Cloud Application Development Deployment | Dealing with CosmosDB |
Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
On my session I'll show details of solution that allowed this idea to come true. We'll see how to install, use and administer Linux version of SQL Server. We'll see it working as a service and in Docker containers. I'll give you details of why the second option is really interesting, or to say it more clearly - groundbreaking. In addition to slides you're going to see lots of terminal windows, tools that are familiar to you and new stuff as well.
Event Date: 14-10-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Application Database Development
The features provided by platforms such as TFS and VSTS have been widely adopted by application developers in support of modern software development practices such as continuous delivery.
In the world of database development, adoption has been much slower, due to a number of organisational and technical considerations.
This session will discuss some of the challenges associated with database continuous delivery, and the ways in which Visual Studio, SQL Server Data Tools and Visual Studio Team Services can help to improve delivery of SQL Server databases.
Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-10-2017 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-10-2017 - Session time: 11:15:00 - Track: Advanced Analysis Techniques
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? Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
Event Date: 14-10-2017 - Session time: 11:15:00 - Track: Application Database Development
Event Date: 14-10-2017 - Session time: 11:15:00 - Track: Analytics and Visualization
The session will initially provide a primer to supervised Machine Learning before applying that to a real world scenario, taking you through each of the steps required to build an in-database predictive analytics model using R and SQL Server 2017.
Event Date: 14-10-2017 - Session time: 11:15:00 - Track: BI Information Delivery
However, as with all reporting tools, if the underlying data model is badly designed or custom measures/calculations are poorly written, performance can really suffer. Whether you are designing the front-end for a carefully crafted warehouse, or performing an ad-hoc analysis exercise, you can follow some best practice advice to ensure you’re getting the best out of your reports.
This 1 hour session will range from quick development wins to more strategic, enterprise considerations. The session also aims to explain ad-hoc transformations within the Query Editor and demonstrates best practices for encouraging Query Folding. Designed for all levels of Power BI expertise.
Event Date: 14-10-2017 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-10-2017 - Session time: 13:15:00 - Track: Professional Development
Event Date: 14-10-2017 - Session time: 13:15:00 - Track: Application Database Development
In this session you will see not only what Always Encrypted is and how it works, but also how it looks like from developer’s perspective. It is a demo-heavy session and we will spend more time in Visual Studio and SSMS than in PowerPoint. I will show how to read encrypted columns in SSMS and how to do this in the application. You will also learn how to manage certificates in Windows Certificate Store and Azure Key Vault and why we need a separate security officer. This session is intended for both developers and database administrators.
Event Date: 14-10-2017 - Session time: 13:15:00 - Track: Application Database Development
It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions
Event Date: 14-10-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-10-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-10-2017 - Session time: 14:30:00 - Track: Analytics and Visualization
This session is about managing and understanding IoT data. Check this out and see how Azure Machine Learning could support real life problems in building IoT solutions.
Event Date: 14-10-2017 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
We will start with linear regression, simple but powerful machine learning algorithm. With it you will learn about correlation coefficient, loss function, optimization algorithms and regularization. At the end of this section we will built a ML model using Fast linear model with Stochastic Dual Coordinate Ascent (SDCA) optimization. Next step is get to know artificial neural networks, their architecture, activation functions and backpropagation algorithm. This allows us to build a (better?) model using rxNeuralNet and N#. Evaluation metrics for regression models will conclude first part of the session. In the second part we will use almost the same ML algorithms for classification — the difference is that Logistic regression will replace Linear regression. Finally we will learn about Evaluation metrics for classification models, which allows us to pick the very best model for problems we are going to solve together.
Event Date: 14-10-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
In this session, based on our experience, we will speak about the most important DBA maintenance tasks you need to perform to keep your databases GDPR compliant. Session is suitable for beginner DBAs and Developers.
Event Date: 14-10-2017 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
We decide to use localDB as our local cache of data. In this presentation we will show:
Event Date: 14-10-2017 - Session time: 15:45:00 - Track: BI Information Delivery
In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016.
This session is for anyone who is new to R and is interesting expanding their skill set beyond their comfort zone in SQL Server.
Event Date: 14-10-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
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.
Event Date: 14-10-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-10-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-10-2017 - Session time: 15:45:00 - Track: Advanced Analysis Techniques
The essence of privacy by design is that privacy in a service or product is taken into account not only at the point of delivery, but from the inception of the product concept. There is also a requirement that controllers should only collect data necessary to fulfil specific purposes, discarding it when it is no longer required, to protect data subject rights.
This presentation provides a breakdown of the key provisions introduced by the new law, which every organisation must be aware of
Event Date: 14-10-2017 - Session time: 17:00:00 - Track: Advanced Analysis Techniques
Event Date: 14-10-2017 - Session time: 17:00:00 - Track: Application Database Development
Event Date: 14-10-2017 - Session time: 17:00:00 - Track: Application Database Development
Event Date: 14-10-2017 - Session time: 17:00:00 - Track: BI Platform Architecture, Development Administration
Logic Apps provides control-flow style functionality and can orchestrate data from a huge range of common sources. Want to scrape twitter, perform sentiment analysis and write to PowerBI? Its now possible with zero coding.
This session will introduce Logic Apps how it fits into the Modern Azure Warehouse then demonstrate building a twitter scraper step by step, demonstrating the process of building, deploying and debugging an app.
Event Date: 14-10-2017 - Session time: 17:00:00 - Track: Cloud Application Development Deployment
In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.