| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Steve Simon | Analytics and Visualization | An introduction to Data Mining with SQL Server 2017 |
| 08:30:00 | Marcelo Fernandes | Enterprise Database Administration Deployment | Architecting SQL Server environments for Mission Critical and High Performance |
| 08:30:00 | Simon Whiteley | BI Platform Architecture, Development Administration | Modern Data Warehousing - The Lambda Approach to Azure BI |
| 08:30:00 | Mary Fealty | PowerBI | Power BI KISS, make it beautiful |
| 09:30:00 | Kevin Feasel | Advanced Analysis Techniques | Launching A Data Science Project: Cleaning Is Half The Battle |
| 09:30:00 | Dmitri Korotkevitch | Enterprise Database Administration Deployment | Intro Into Index Analysis |
| 09:30:00 | Brynn Borton | BI Platform Architecture, Development Administration | Using Azure Cosmos DB and DataBricks to provide Realtime Customer Matching |
| 09:30:00 | Daire Cunningham | Azure / Cloud | ADF Data Flows: Build scalable, cloud-based ETL without code |
| 10:45:00 | Andrew Pruski | Enterprise Database Administration Deployment | SQL Server Kubernetes |
| 10:45:00 | Christoph Seck | Cloud Application Development Deployment | Connecting SQL and Blockchain: The Azure Blockchain Workbench [EN] |
| 10:45:00 | Angela Ross Innes | Application Database Development | Database Continuous Integration and Delivery (CI/CD) using Visual Studio and DACFx for SQL Server |
| 10:45:00 | Douglas McDowell | Professional Development | Rock Your Session - Best Practices for Presentations |
| 10:45:00 | Mark Hayes | Azure / Cloud | Lightning Talks |
| 11:45:00 | Craig Porteous | PowerBI | Power BI and PowerShell - A Match Made in Heaven |
| 11:45:00 | Geovanny Hernandez | Application Database Development | Keeping your SQL Code safe – An introduction to GIT and SSDT for DB professionals |
| 11:45:00 | Rob Sewell | Enterprise Database Administration Deployment | SQL Notebooks in Azure Data Studio for the DBA |
| 11:45:00 | Dan Galavan | Strategy and Architecture | Data Vault data warehousing - an introduction |
| 13:30:00 | Marcin Szeliga | Advanced Analysis Techniques | How to win Kaggle competition and get familiar with machine learning ? |
| 13:30:00 | Kaijisse Waaijer | Advanced Analysis Techniques | Training a large-scale recommendation engine on SQL server 2019 |
| 13:30:00 | Kevin Chant | Enterprise Database Administration Deployment | Database Adventure |
| 13:30:00 | Bob Duffy | Enterprise Database Administration Deployment | Secrets of Azure storage and SQL |
| 14:30:00 | Peter Willmot | Application Database Development | Working with SQL Managed Data Types |
| 14:30:00 | Lord Richard Douglas | Enterprise Database Administration Deployment | Understanding the Transaction Log For Faster Throughput |
| 14:30:00 | Paul Andrew | BI Platform Architecture, Development Administration | Complex Azure Orchestration with Dynamic Data Factory Pipelines |
| 14:30:00 | Mark Hayes | BI Information Delivery | Many roads to reporting with Microsoft BI technologies |
| 15:45:00 | Vitor Fava | Advanced Analysis Techniques | Implementing AI solutions using the cognitive services in Azure |
| 15:45:00 | Magnus Ahlkvist | Application Database Development | Eight hours of work in 20 minutes |
| 15:45:00 | Shehab El-Najjar | Enterprise Database Administration Deployment | Performance Dreams started at SQL Server 2014 and came true now at SQL Server 2016,2017 |
| 15:45:00 | Mark Broadbent | Application Database Development | 2 Fast 2 Furious - designing for speed, concurrency, and correctness |
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: Analytics and Visualization
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
Defining what questions we want answered and how to go about this in an effective and efficient manner.
Creating the data model.
How to gather the necessary data, discussing the training and testing aspect.
Processing the model.
Extracting information from our finished model, discussing the implications of this information.
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
We will first review the patterns and processes that underpin the Lambda architecture, providing advice and guidance on the tool sets and integration points between them.
This intense, demo-packed session implements real-time reporting using the Lambda Architecture in Azure, demonstrating Azure Data Lake Store, Azure Databricks, Data Factory, SQL Datawarehouse and Stream Analytics. Time permitting, we will compare and contrast against an alternative pattern using Cosmos DB Spark Structured Streaming.
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: PowerBI
She will also share some of her technics for creating a unique look and feel to the report that makes for a positive user experience, by using PowerPoint, Power BI Bookmarks the new Filter Pane. This session is for folks who are new to Power BI but should be of interest to fellow Power BI Pros.
Event Date: 29-06-2019 - Session time: 09:30:00 - Track: Advanced Analysis Techniques
Event Date: 29-06-2019 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.
Event Date: 29-06-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Cosmos DB and Databricks where used to process and match customer data in real-time, helping them get to know their customers, how best to retain them, and how best to keep them happy, all while ensuring GDPR compliance.
Learn how downstream systems received customer identifiers allowing tailored content to be produced in near real time, and how business users consumed the insights via Power BI
Learn how scale up and scale down allowed us to meet challenges around massive initial data loads, without blowing the project budget.
Find out what lessons were learned and what best practices helped ensure that the Cosmos DB, Azure Functions, Event Hubs and Azure Databricks instances all played harmoniously together. Hear how we used partitioning, indexing, scaling and other cloud design patterns to deliver incredible performance.
Event Date: 29-06-2019 - Session time: 09:30:00 - Track: Azure / Cloud
Event Date: 29-06-2019 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
This session will provide an overview of running SQL Server in Kubernetes, which is the leading orchestrator.
Topics covered will be: - An overview of Kubernetes. Definition of deployments, pods, and services. Deploying SQL Server containers to Kubernetes. Persisting data for SQL Server in Kubernetes.
This session is aimed at SQL Server DBAs and Developers who want to learn the what, the why, and the how to run SQL Server in Kubernetes.
Event Date: 29-06-2019 - Session time: 10:45:00 - Track: Cloud Application Development Deployment
Last but not least, we can look at some real world projects.
Event Date: 29-06-2019 - Session time: 10:45:00 - Track: Application Database Development
Event Date: 29-06-2019 - Session time: 10:45:00 - Track: Professional Development
Event Date: 29-06-2019 - Session time: 10:45:00 - Track: Azure / Cloud
All welcome - feel free to turn up and speak on the day!
Event Date: 29-06-2019 - Session time: 11:45:00 - Track: PowerBI
In this session we will take a look at how to manage your datasets, security, monitor licensing and more, all through the ultimate administration interface: PowerShell!
You'll leave the session with an overview of the management capabilities of Power BI and couple that knowledge with the awesome power (and automation possibilities) of PowerShell
Event Date: 29-06-2019 - Session time: 11:45:00 - Track: Application Database Development
In this session, I'm going to show you how to avoid problems derived of mistakes during the development process through the proper use of source control code strategy which can combine the potential of GIT and SQL Server Data Tools (SSDT) for managing latest version, detecting changes, code review and deploying through environment without stress.
Event Date: 29-06-2019 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.
You will learn about SQL Notebooks from installing them in Azure Data Studio to creating a Notebook for Glenn Berry's Diagnostic queries as well as numerous use cases for you to use in your daily workload
Event Date: 29-06-2019 - Session time: 11:45:00 - Track: Strategy and Architecture
This talk will introduce you to the core Data Vault concepts including support for an agile data warehouse, how it can contribute to faster sprints, how it lends itself to automated data model creation, how the Hub, Link and Satellite design is a perfect fit for massively parallel data load and how to virtualize a Data Mart over a Data Vault. It will also cover how a single version of the facts edges out a single version of the truth. Demo: Using a SQL 2017 data source, we will orchestrate the extraction, transformation and load to a Data Vault data warehouse including an example virtualized Data Mart layer. The orchestration will take place using Azure Data Factory v2.
Event Date: 29-06-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
During this session we will solve simple Kaggle competition. Actually, we will submit two solutions. The first made with super-duper deep neural network (black-box approach). Then we will follow proven ML methodologies and solve the problem methodically. All that using SQL Server Machine Learning Services. Minimum slides and maximum fun guaranteed.
Event Date: 29-06-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
We will start with an overview of the SQL Server 2019 architecture for Big Data clusters. After a brief introduction to Recommender Systems, we will load product ratings to HDFS and link them to the customer and product data in SQL using Polybase. Then we will explore the dataset using Spark, Python and Data Studio and ultimately create a Training and Validation split. In the next step, we will train the Recommendation engine in Spark and persist the model to HDFS. Every step will be performed within the same SQL Server 2019 BDC cluster showcasing the incredible capabilities of SQL 2019. On-top, by building on SQL Server 2019 BDC and Kubernetes you can run your cluster locally, on premises, or in the cloud.
Event Date: 29-06-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Each selection will have a different outcome, and along the way you will probably learn some new things.
Event Date: 29-06-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Come along and chat to SQL Certified Architect, Bob Duffy, as we dive deeper into azure storage for SQL. Topics covered include:
Event Date: 29-06-2019 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 29-06-2019 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log, however, is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session, you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices. From understanding the internals we can design for faster recovery and batch processes and ironically a smaller transaction log!
Event Date: 29-06-2019 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 29-06-2019 - Session time: 14:30:00 - Track: BI Information Delivery
Topics: Excel, Power BI, SQL Reporting Services 2017, Power BI Server, Data Models, Self Service Reporting
In this session we will see cover;
Event Date: 29-06-2019 - Session time: 15:45:00 - Track: Advanced Analysis Techniques
As well as the arrival of the personal computer, the cloud computing and smartphones, the AI is the artificial technology that takes you to where you're going so much faster, intuitive and smart. In this session we will discuss the basics of IA and how we can apply it in our business using the Azure Cognitive Services.
Event Date: 29-06-2019 - Session time: 15:45:00 - Track: Application Database Development
The presentation also includes some reflections on how partitioning the table has changed how both T-SQL and Entity Framework code is being written, to take advantage of partition elimination.
Event Date: 29-06-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-06-2019 - Session time: 15:45:00 - Track: Application Database Development
In this session, we will reveal how SQL Server concurrency and correctness often goes wrong, how we can avoid this, and how we can use our knowledge to design and develop for optimal server throughput for our applications and processes using tips and tricks gained from real-world scenarios.
We will cover SQL Server’s traditional locking model, In-Memory OLTP, Columnstore, Delayed Durability, and many other technologies and techniques you can use to make your transactions more robust.