| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Alex Yates | Enterprise Database Administration Development | DevOps 101 for Data Folks |
| 09:00:00 | Mark Broadbent | Cloud | Azure Cosmos DB for Dummies |
| 09:00:00 | Cédric Charlier | AI(Artificial Intelligence) Machine Learning | Data scientists have left ... How will I deploy their work? |
| 09:00:00 | Ted Malone | BI Analytics/Visualization | Creating ETL/ELT Data Flows for the Modern Data Warehouse |
| 09:00:00 | Lord Richard Douglas | Enterprise Database Administration Development | Investigate TempDB like Sherlock Holmes |
| 10:15:00 | Dennes Torres | Cloud | Why Synapse Analytics is beyond Azure SQL Datawarehouse |
| 10:15:00 | Chris Taylor | Enterprise Database Administration Development | "Kubernetify" your SQL Server Containers |
| 10:15:00 | Dr. Subramani Paramasivam | AI(Artificial Intelligence) Machine Learning | Exploiting Artificial Intelligence within Power BI |
| 10:15:00 | Erland Sommarskog | Enterprise Database Administration Development | When Things go Wrong - Error Handling in SQL Server |
| 10:15:00 | Isabelle Van Campenhoudt | BI Analytics/Visualization | Turn insight into action using Power automate and Power BI |
| 11:30:00 | Terry McCann | AI(Artificial Intelligence) Machine Learning | Machine Learning in Azure Databricks |
| 11:30:00 | Rich Benner | Enterprise Database Administration Development | Choose Your Own Adventure - Performance Edition |
| 11:30:00 | John Martin | Cloud | An Introduction to Terraform, Infrastructure as Code |
| 11:30:00 | Rob Sewell | Enterprise Database Administration Development | SQL Notebooks in Azure Data Studio for the DBA |
| 11:30:00 | Kevin Chant | Enterprise Database Administration Development | Azure DevOps duet (90 minutes version) |
| 12:45:00 | SQLSat927 Gold Sponsor | Sponsors Session | QUORUM Network Resources |
| 12:45:00 | SQLSat927 Gold Sponsor | Sponsors Session | SentryONE |
| 12:45:00 | SQLSat927 Gold Sponsor | Sponsors Session | GethyEllis.com (GE) |
| 12:45:00 | SQLSat927 Gold Sponsor | Sponsors Session | Advancing Analytics |
| 12:45:00 | SQLSat927 Gold Sponsor | Sponsors Session | SIOS |
| 13:30:00 | Grant Fritchey | Enterprise Database Administration Development | 10 Steps Towards Global Data Compliance |
| 13:30:00 | André Kamman | Cloud | Creating an Enterprise Datalake without an Enterprise budget |
| 13:30:00 | Gethyn Ellis | Enterprise Database Administration Development | Driven by the 9s - I need a highly available Microsoft Data Platform – what features should I use? |
| 13:30:00 | Shreeya Subramani | AI(Artificial Intelligence) Machine Learning | Azure AI with Power BI |
| 13:30:00 | Mark Hayes | BI Analytics/Visualization | Rebooting your SME Data Analysis Strategy |
| 14:45:00 | Andrew Pruski | Cloud | SQL Server Kubernetes |
| 14:45:00 | Christophe Laporte | Enterprise Database Administration Development | From Docker to Big Data Clusters: a new era for SQL server |
| 14:45:00 | Mikael Wedham | Enterprise Database Administration Development | A Masters view on Locking and blocking |
| 14:45:00 | Arne Bartels | Enterprise Database Administration Development | Shadow prediction: SQL spatial data types and astronomy well mixed |
| 14:45:00 | Robert French | Professional Development | How to be awesome at getting your next job |
| 16:00:00 | Mark Pryce-Maher | BI Analytics/Visualization | Azure Synapse Analytics : Evolving Azure SQL Data Warehouse |
| 16:00:00 | John Martin | Professional Development | How to establish control when it's all going wrong! |
| 16:00:00 | Mark Broadbent | Enterprise Database Administration Development | Persistence is Futile - Implementing Delayed Durability in SQL Server |
| 16:00:00 | Oskari Heikkinen | Cloud | Best Practices for building a Data Lake with Azure Databricks |
| 16:00:00 | Kevin Chant | Enterprise Database Administration Development | Database Adventure |
Event Date: 01-02-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Development
We all need to learn to survive in this new reality.
In this session we'll cut through the hype and look at the key concepts and findings from the Puppet State of DevOps Reports, The DevOps Handbook and Microsoft's work in this space.
We will finish with an overview of an Azure DevOps Services project that automatically tests and deploys the code from a SQL Server Data Tools (SSDT) project in a public GitHub repo.
Event Date: 01-02-2020 - Session time: 09:00:00 - Track: Cloud
In this session, we will explain how to get started in Cosmos DB and demonstrate simple administrative and development operations so you can learn how to go from zero to hero in no time. We will cover many fundamental topics which include:
Azure Cosmos DB is not just the future for Online-Transaction Processing, it is the present!
Event Date: 01-02-2020 - Session time: 09:00:00 - Track: AI(Artificial Intelligence) Machine Learning
That's it, data scientists have left the house! Behind them, some scripts written in Python or R, thousands of CSV files, three sheets and two whiteboards of mathematical equations, many PowerPoint presentations and a clear instruction from the CEO: go to production ASAP! Unfortunately, no trace of a deployment procedure. Hopefully, this session, will explain how to industrialize data scientists' scripts. How to import and refactor code written in Jupyter Notebooks within VS Code, How to put in place the best practices of DevOps and apply them to Machine Learning with Azure Pipelines and some other tips and tricks for a successful go-live.
Event Date: 01-02-2020 - Session time: 09:00:00 - Track: BI Analytics/Visualization
This session will be very demo-heavy, with demonstrations of effective patterns and practices that have been deployed by some of Microsoft's largest customers throughout the world.
Event Date: 01-02-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Development
You will learn what you can do to reduce issues by investigating your hardware, your SQL Server configurations, and your coding techniques.
Event Date: 01-02-2020 - Session time: 10:15:00 - Track: Cloud
Event Date: 01-02-2020 - Session time: 10:15:00 - Track: Enterprise Database Administration Development
This demo heavy session will walk through some of the challenges around managing container environments and how Kubernetes orchestration can help alleviate some of the pain points.
We will be talking about what Kubernetes is and how it works and through the use of demos we will:
Event Date: 01-02-2020 - Session time: 10:15:00 - Track: AI(Artificial Intelligence) Machine Learning
Event Date: 01-02-2020 - Session time: 10:15:00 - Track: Enterprise Database Administration Development
The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling "fancy", although it may seem to be a good idea in theory. The session also covers a few things to think of on client level.
Once we have learnt how to handle unanticipated errors, we can start to look at how to handle errors we know can occur and in which case we want to take an alternate action. We will also learn how to - and if - to implement retries on deadlocks.
Event Date: 01-02-2020 - Session time: 10:15:00 - Track: BI Analytics/Visualization
Microsoft Flow is a SaaS offering for automating workflows across the growing number of applications and services that business users rely on. You can set up Flows to take care of the important, repeating tasks that take place daily in your organization. For example, you can create a Flow to text you via SMS when your manager sends you an e-mail marked as “high importance.” Or, automatically create a to-do item in Wunderlist when a customer e-mails your support line.
Event Date: 01-02-2020 - Session time: 11:30:00 - Track: AI(Artificial Intelligence) Machine Learning
In this session we focus on how Spark implements Machine Learning at Scale with Spark ML. Spark ML can do a lot, but not everything. In this session we go end-to-end, building a model in an iterative way, monitoring our improvements in MLFlow, training, testing and evaluating a Machine Learning pipeline. We will also discuss how to migrate your models to perform at scale. If you're working with Deep Learning, then let me know and we can discuss how Databricks can scale Deep Learning.
Event Date: 01-02-2020 - Session time: 11:30:00 - Track: Enterprise Database Administration Development
We're going to start with a poorly performing query and choose which route we're going to take to see if we can make it better.
You don't need any previous experience in performance tuning for this session, we'll briefly cover each topic as it's chosen.
Potential topics include;
We'll be voting on where we go at each step to see where our journey takes us.
In the session we'll cover each topic a little but I will also provide a more in-depth explanation of everything we go through after the session if you want to learn more.
Event Date: 01-02-2020 - Session time: 11:30:00 - Track: Cloud
This is where Terraform from Hashicorp can step in, one solution that has a provider model that will interact with Azure, AWS, Google, and others. Meaning that you only need to learn one syntax. Add that to the automation potential and now we have something that can really help get us down the road to infratructure as code.
This session will take an introductory look at how infrastructure can be defined as code and be shipped to standardise the deployment process and minimise the chance of mistakes creeping in when deployed by different memebers of Development or Operations.
Event Date: 01-02-2020 - Session time: 11:30:00 - Track: Enterprise Database Administration Development
We will cover installing Azure Data Studio. What a SQL Notebooks is. Numerous use cases for you to use SQL Notebooks in your daily workload such as creating a Notebook for Glenn Berry's Diagnostic queries.
and some gifs ;-)
Event Date: 01-02-2020 - Session time: 11:30:00 - Track: Enterprise Database Administration Development
This session will cover the process of developing a CI/CD process starting at getting the team on board and ending with making an actual release.
We will discuss
After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.
Event Date: 01-02-2020 - Session time: 12:45:00 - Track: Sponsors Session
Event Date: 01-02-2020 - Session time: 12:45:00 - Track: Sponsors Session
Event Date: 01-02-2020 - Session time: 12:45:00 - Track: Sponsors Session
Event Date: 01-02-2020 - Session time: 12:45:00 - Track: Sponsors Session
Event Date: 01-02-2020 - Session time: 12:45:00 - Track: Sponsors Session
Event Date: 01-02-2020 - Session time: 13:30:00 - Track: Enterprise Database Administration Development
However, it is possible to define a core set of processes that will help to enable your ability to assist your business, or government agency, in meeting these compliance requirements. This session will walk you through the 10 steps you need to implement in order to move your organization towards full compliance with any, or all, of the regulations we all now face. From identifying where your data lives to monitoring for compliance and all the steps in between, you can meet this challenge.
Event Date: 01-02-2020 - Session time: 13:30:00 - Track: Cloud
You get to decide how far you want to go, from cost-effective to penny pinching. Don't worry if you've never used any of these technologies, I will start at the beginning.
Event Date: 01-02-2020 - Session time: 13:30:00 - Track: Enterprise Database Administration Development
If you are driven by the '9s', have strict SLAs and up time is key to you and your business, then combining SQL Server’s high availability features is something you should consider.
In this session we will look at how we can combine SQL Server Availability Groups and SQL Server Failover cluster instances to keep our servers both highly available and maintain a secondary disaster recovery.
Event Date: 01-02-2020 - Session time: 13:30:00 - Track: AI(Artificial Intelligence) Machine Learning
Event Date: 01-02-2020 - Session time: 13:30:00 - Track: BI Analytics/Visualization
This session is based on real-life customer implementations where they were taken away from their Excel and Microsoft Access and LOB based reporting solutions towards the Power Platform. We show how we started with Power BI and evolved into a comprehensive solution that combines SharePoint Online with PowerBI to provide an end to end reporting solution. Further phases of these project introduced Power Apps and Flow to further enhance the analytical capabilities of the company.
Event Date: 01-02-2020 - Session time: 14:45:00 - Track: Cloud
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 pods and services. Deploying SQL Server containers to Kubernetes. Persisting data for SQL Server in Kubernetes. An introduction to Helm Chaos engineering for SQL Server in Kubernetes using Space Invaders!
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: 01-02-2020 - Session time: 14:45:00 - Track: Enterprise Database Administration Development
This session will drive DBAs on their path to modernize their skills. Starting with a single container on a Docker host, the session will also cover Big Data Cluster creation and usage though T-SQL and basic Python scripts.
Event Date: 01-02-2020 - Session time: 14:45:00 - Track: Enterprise Database Administration Development
This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.
Event Date: 01-02-2020 - Session time: 14:45:00 - Track: Enterprise Database Administration Development
It needs some math and the willingness to use SQL objects for purposes, they haven’t been designed for. This session is a (hopefully) entertaining exercise to combine scarcely used data types with a bit of astronomy and math to calculate and visualize the relationship between sun and wind turbines (i.e. moving shadows that may annoy the neighbors) solely by using SQL Management Studio. Only GEOGRAPHY data type will be used to show the richness and beauty of its functionality. Apart from 2-3 formulas everything will be handled in SQL.
Event Date: 01-02-2020 - Session time: 14:45:00 - Track: Professional Development
In this session I will share some of the tips and techniques I have used to get roles over my career. You will get some insider tips on how to deal with those difficult interview questions. How to work with recruitment agents. Ways to get your name to the top of the recruiters list. When you leave this session you have techniques and tips you can use as soon as you leave the session to help you in your search for that role you want
Event Date: 01-02-2020 - Session time: 16:00:00 - Track: BI Analytics/Visualization
In this session we explore Azure Synapse Analytics, we will dive into this limitless analytics service and explore how it brings together enterprise data warehousing and Big Data analytics.
We will explore; *Data ingestion *SQL Pools - Data Warehouses *Spark Pools *SQL-on-Demand *PowerBI
Event Date: 01-02-2020 - Session time: 16:00:00 - Track: Professional Development
Join me as I share a number of tips and tricks about how to take control of the situation. We will cover establishing a control structure, commuincations, and documentation. All of which when done well can result in a calm and controlled resolution and faciliate root cause analysis. We will also look at ways to prepare for such situations and how you can lay the groundwork so that if something does go wrong you are ready for it.
Event Date: 01-02-2020 - Session time: 16:00:00 - Track: Enterprise Database Administration Development
In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput. We will take a look at how this can be used to compliment In-Memory OLTP performance, and how it might impact or compromise other things.
Attend this session and you will be assimilated!
Event Date: 01-02-2020 - Session time: 16:00:00 - Track: Cloud
Event Date: 01-02-2020 - Session time: 16:00:00 - Track: Enterprise Database Administration Development
Members of the audience can then select from the options provided and we will follow that path and see what the outcome is from there. Similar to a role-playing game.
Each selection will have a different outcome, and along the way you will probably learn some new things.
As some of you may have seen on the blog www.KevinRChant.com I've already had dealing with SQL Server 2019. Therefore, this session has been updated to include SQL Server 2019 content.