SQLSaturday #927 - Edinburgh 2020

Event Date: 02/01/2020 00:00:00

Event Location:

  • Edinburgh Training and Conference Venue
  • 16 St Mary’s St, Edinburgh
  • Edinburgh, Scotland, United Kingdom

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


Title: Choose Your Own Adventure - Performance Edition

Abstract: Remember those “choose your own adventure” books from when we were younger? Yep, that’s what we’re doing in this session.

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;

  • Indexes
  • Query Design
  • Settings that might affect performance
  • Scalar Functions
  • SARGability
  • Temp Tables

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.

Speaker(s):

  • Rich Benner

Track and Room: Enterprise Database Administration Development - Spey


Title: When Things go Wrong - Error Handling in SQL Server

Abstract: Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straightforward as one may wish, but it is marred with inconsistencies and surprises. This session starts off by displaying the some of the surprises you can encounter, both when you use TRY-CATCH and when you don’t.

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.

Speaker(s):

  • Erland Sommarskog

Track and Room: Enterprise Database Administration Development - Oban


Title: An Introduction to Terraform, Infrastructure as Code

Abstract: With ever increasing complexity in data platform and application solutions, it is becoming ever more important to take people out of the loop when it comes to system provisioning. Infrastructure as code is the way forward with Azure Resource Manager Templares, Google Deployment Manager, or AWS Cloud Formation.

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.

Speaker(s):

  • John Martin

Track and Room: Cloud - Oban


Title: Azure Cosmos DB for Dummies

Abstract: Azure Cosmos DB is Microsoft’s premier NoSQL Cloud-based globally distributed database offering, providing scalable performance and resiliency, customizable consistency guarantees, multiple data models APIs, and comprehensive service level agreements.

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:

  • Cosmos DB APIs
  • Accounts, Databases, and Containers
  • Geo-Replication
  • Partitioning and indexing
  • Consistency and throughput

Azure Cosmos DB is not just the future for Online-Transaction Processing, it is the present!

Speaker(s):

  • Mark Broadbent

Track and Room: Cloud - Oban


Title: Database Adventure

Abstract: Aimed mostly at administration and based on real life scenarios, this popular audience interactive session we will go through some scenarios DBA’s might encounter whilst dealing with SQL Server databases and you will be provided with some options about what to do.

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.

Speaker(s):

  • Kevin Chant

Track and Room: Enterprise Database Administration Development - Oban


Title: Rebooting your SME Data Analysis Strategy

Abstract: For many businesses out there, adopting a progressive data analysis strategy is the domain of the big players. You need a budget, you need investment and with only a small number of users, the costs are off-putting. Hard to justify some costs when your user base may only be a few or a few dozen users. This is no longer the case with the PowerBI Platform.

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.

Speaker(s):

  • Mark Hayes

Track and Room: BI Analytics/Visualization - Lomond


Title: SQL Server Kubernetes

Abstract: Running SQL Server in containers has huge benefits for Data Platform professionals but there are challenges to running SQL Server in stand alone containers. Orchestrators provide a platform and the tools to overcome these challenges.

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.

Speaker(s):

  • Andrew Pruski

Track and Room: Cloud - Oban


Title: Driven by the 9s - I need a highly available Microsoft Data Platform – what features should I use?

Abstract: Microsoft’s data platform and SQL Server comes with a plethora of High Availability features. Some of these features can work hand-in glove with each other to allow you to configure your SQL Servers to be both Highly-Available and recoverable in the event of the worst happening.

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.

Speaker(s):

  • Gethyn Ellis

Track and Room: Enterprise Database Administration Development - Arran


Title: How to be awesome at getting your next job

Abstract: Finding that job you desire and want can be hard work. Writing that CV that gets your name on the interview list. Making the first good impression at the the interview, handling those tough questions with ease.

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

Speaker(s):

  • Robert French

Track and Room: Professional Development - Jura


Title: Shadow prediction: SQL spatial data types and astronomy well mixed

Abstract: Can you use GEOGRAPHY data types to calculate and display celestial phenomena and does it make sense? 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.

Speaker(s):

  • Arne Bartels

Track and Room: Enterprise Database Administration Development - Arran


Title: Creating ETL/ELT Data Flows for the Modern Data Warehouse

Abstract: One major challenge in the age of “Big Data” is keeping up with the volume and velocity of data with respect to moving it to the Data Warehouse. In this session, attendees will learn about Microsoft’s answer to this problem; Azure Data Factory (ADF), and specifically, Mapping Data Flows. ADF Mapping Data Flows enables data engineers to construct, execute, and monitor data pipelines, based on the highly scalable Azure Databricks Spark Engine, with little to no code.

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.

Speaker(s):

  • Ted Malone

Track and Room: BI Analytics/Visualization - Jura


Title: Data scientists have left … How will I deploy their work?

Abstract: Description 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.

Speaker(s):

  • Cédric Charlier

Track and Room: AI(Artificial Intelligence) Machine Learning - Spey


Title: 10 Steps Towards Global Data Compliance

Abstract: Data compliance in the modern technology landscape feels like a constantly moving target as more and different laws, rules and regulations are passed locally, nationally and internationally. The days when only some organizations or certain countries had to worry about data compliance are gone. It’s everyone’s problem.

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.

Speaker(s):

  • Grant Fritchey

Track and Room: Enterprise Database Administration Development - Oban


Title: Turn insight into action using Power automate and Power BI

Abstract: By combining the power of Power BI data alerts with the hundreds of actions available for Flow, we’re making it easier than ever to go from insight to deep, meaningful action.

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.

Speaker(s):

  • Isabelle Van Campenhoudt

Track and Room: BI Analytics/Visualization - Lomond


Title: DevOps 101 for Data Folks

Abstract: DevOps has fundamentally changed the way we manage IT. Those practicing DevOps well aren’t just outpacing their competitors, they are annihilating them. DevOps brings a whole host of new practices, tools and buzzwords. It has made some roles and tasks redundant, while new opportunities have been created.

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.

Speaker(s):

  • Alex Yates

Track and Room: Enterprise Database Administration Development - Lomond


Title: Azure DevOps duet (90 minutes version)

Abstract: Welcome to Azure DevOps Duet, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for SQL Server related deployments.

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

  • the challenges of implementing DevOps
  • setting up a database solution project
  • getting started with source control
  • testing your database releases using tSQLt
  • setting up your Azure Devops pipelines

After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.

Speaker(s):

  • Kevin Chant

Track and Room: Enterprise Database Administration Development - Arran


Title: Machine Learning in Azure Databricks

Abstract: Databricks is the Swiss Army Knife of the Azure Data Analytics environment. Databricks implements Apache Spark, a robust in-memory cluster data processing framework. Spark Core supports SQL, DataFrames, Streaming, Graph Processing and 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.

Speaker(s):

  • Terry McCann

Track and Room: AI(Artificial Intelligence) Machine Learning - Jura


Title: Persistence is Futile - Implementing Delayed Durability in SQL Server

Abstract: The concurrency model of most Relational Database Systems are defined by the ACID properties but as they aim for ever increasing transactional throughput, those rules are bent, ignored, or even broken.

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!

Speaker(s):

  • Mark Broadbent

Track and Room: Enterprise Database Administration Development - Jura


Title: Advancing Analytics

Abstract: SQLSaturday Edinburgh (SQLSat927) GOLD sponsor session.

Speaker(s):

  • SQLSat927 Gold Sponsor

Track and Room: Sponsors Session - Jura


Title: How to establish control when it’s all going wrong!

Abstract: At some point in time, whether in the past or in the future, we will experience being in a situation where there is a major outage or problem that needs to be dealt with. But how can we ensure that it does not decend into chaos and make the problem worse?

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.

Speaker(s):

  • John Martin

Track and Room: Professional Development - Spey


Title: From Docker to Big Data Clusters: a new era for SQL server

Abstract: Starting with version 2017, SQL server was supported on Docker and Linux. With SQL Server 2019, you will be able to run a container, or a whole AlwaysOn Availability Group on Kubernetes. 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.

Speaker(s):

  • Christophe Laporte

Track and Room: Enterprise Database Administration Development - Spey


Title: Azure Synapse Analytics : Evolving Azure SQL Data Warehouse

Abstract: Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources—at scale.

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

Speaker(s):

  • Mark Pryce-Maher

Track and Room: BI Analytics/Visualization - Arran


Title: A Masters view on Locking and blocking

Abstract: How do the wait stats show you that you have a locking issue? 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.

Speaker(s):

  • Mikael Wedham

Track and Room: Enterprise Database Administration Development - Lomond


Title: Investigate TempDB like Sherlock Holmes

Abstract: The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affects everybody on that instance. You will learn what you can do to reduce issues by investigating your hardware, your SQL Server configurations, and your coding techniques.

Speaker(s):

  • Lord Richard Douglas

Track and Room: Enterprise Database Administration Development - Arran


Title: Exploiting Artificial Intelligence within Power BI

Abstract: Artificial Intelligence is dominating the world and not most of them had any chance to experience these features, due to various complicated reasons. How about if this can be made very easy and to exploit these AI features to visualise in our day to day Power BI? This AI session will cover all AI capabilities within Power BI and also using Azure Cognitive Services to build a live BOT QnA, Vision (Face API), Language (Text Analytics).

Speaker(s):

  • Dr. Subramani Paramasivam

Track and Room: AI(Artificial Intelligence) Machine Learning - Arran


Title: “Kubernetify” your SQL Server Containers

Abstract: We have all now had a play around with Docker and Containers or at least heard about them.

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:

  • Highlight some of the issues with getting setup (Specifically Minikube on Ubuntu),
  • Deploying/Updating containers in Kubernetes (on-Prem as well as AKS using Azure DevOps)
  • Persisting data
  • How to avoid making the same mistakes as I have

Speaker(s):

  • Chris Taylor

Track and Room: Enterprise Database Administration Development - Spey


Title: Creating an Enterprise Datalake without an Enterprise budget

Abstract: In this session we will look at a couple of approaches to create a datalake on a budget. The samples will use Python, Spark and some Databricks. It will all be done in Azure, but we will discuss how you could set this up on-prem as well.

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.

Speaker(s):

  • André Kamman

Track and Room: Cloud - Jura


Title: Why Synapse Analytics is beyond Azure SQL Datawarehouse

Abstract: Synapse Analytics is being announced as the new name of Azure SQL Datawarehouse, but it’s not only that. There is a broader view in Synapse analytics, beyond Azure SQL Datawarehouse. Let’s see in this session what was improved, what changed, and how synapse analytics fits in the data platform.

Speaker(s):

  • Dennes Torres

Track and Room: Cloud - Jura


Title: Azure AI with Power BI

Abstract: Azure Artificial Intelligence and Machine learning models are invoked as functions within Power BI dataflow to create a powerful dataset for your Power BI Reports.

Speaker(s):

  • Shreeya Subramani

Track and Room: AI(Artificial Intelligence) Machine Learning - Spey


Title: SentryONE

Abstract: SQLSaturday Edinburgh (SQLSat927) GOLD sponsor session.

Speaker(s):

  • SQLSat927 Gold Sponsor

Track and Room: Sponsors Session - Oban


Title: Best Practices for building a Data Lake with Azure Databricks

Abstract: Databricks is a Unified Analytics Platform making it easier than ever to do big data analytics on cloud. However, there are a lot of things you need to know and take into account before diving head first into a Data Lake. This session is intended for architects and developers who are looking to build a massive scale data storing and processing solution. I will go through the Best Practices for the purpose. In addition, I will demonstrate how to unify real-time and batch processing using Azure Databricks. As a result, you should feel comfortable building your own Data Lake for your big data processing needs.

Speaker(s):

  • Oskari Heikkinen

Track and Room: Cloud - Lomond


Title: GethyEllis.com (GE)

Abstract: SQLSaturday Edinburgh (SQLSat927) GOLD sponsor session.

Speaker(s):

  • SQLSat927 Gold Sponsor

Track and Room: Sponsors Session - Arran


Title: SIOS

Abstract: SQLSaturday Edinburgh (SQLSat927) GOLD sponsor session.

Speaker(s):

  • SQLSat927 Gold Sponsor

Track and Room: Sponsors Session - Lomond


Title: QUORUM Network Resources

Abstract: SQLSaturday Edinburgh (SQLSat927) GOLD sponsor session.

Speaker(s):

  • SQLSat927 Gold Sponsor

Track and Room: Sponsors Session - Spey


Title: SQL Notebooks in Azure Data Studio for the DBA

Abstract: An Azure Data Studio recent release introduced SQL Notebooks as a capability. While you might have read about notebooks being used for Data Science, this session is primarily for DBAs.

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 ;-)

Speaker(s):

  • Rob Sewell

Track and Room: Enterprise Database Administration Development - Lomond


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Mark Broadbent

Twitter: - @retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.

Dr. Subramani Paramasivam

Twitter: - https://twitter.com/dageop

LinkedIn: Dr. Subramani Paramasivam

Contact: http://www.yoursqlman.com/index.php/blogs

Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.

André Kamman

Twitter: - @andrekamman

Contact: http://andrekamman.com

André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.

Isabelle Van Campenhoudt

Twitter: - @thesqlgrrrl

LinkedIn: Isabelle Van Campenhoudt

Contact: http://thesqlgrrrl.wordpress.com

Isabelle Van Campenhoudt is a system engineer (MCSE; MVP SQL Server) who has been working for more than 15 years in the world of databases; she lives in Belgium; Isabelle has strong experience in Business Intelligence. Trainer (Microsoft Certified Trainer), speaker and consultant, she used to collaborate with developers; infra (design and performance). She is also a teacher at EPHEC (Brussels) for the Bachelor of Computer Science curriculum. Isabelle is co-founder of CLUG; V-chapter Francophone

Cédric Charlier

Twitter: - @Seddryck

LinkedIn: Cédric Charlier

Contact: http://seddryck.wordpress.com

Cédric is a talented architect and Data Platform MVP active in the domain of Business Intelligence and Data warehousing. He has more than 10 years of successful experiences with SQL Server in European industrial groups and services companies. Driven by quality and reliability, he is the main developer of an open-source solution for testing BI solutions (cubes, etl, reports) named NBi (www.nbi.io). Cedric also advocates for the introduction and general usage of agile practices in BI’s world.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Terry McCann

Twitter: - @SQLShark

LinkedIn: Terry McCann

Contact: https://www.advancinganalytics.co.uk/blog

Microsoft MVP. Principal Consultant and Owner of Advancing Analytics Limited, an Advanced Analytics consultancy in the UK. Advancing Analytics helps businesses advance their analytical capabilities. Our focus is on Data Science, Data Engineering, DataOps and applied AI. Terry holds a Master’s degree in Data Science - with a focus on DataOps for Machine Learning. Speaker at conferences across the world and the host of the Data Science in Production Podcast.

Gethyn Ellis

Twitter: - gethyn_ellis

LinkedIn: Gethyn Ellis

Contact: http://www.gethtynellis.com

Gethyn is a SQL Server consultant and trainer and has worked with SQL Server for nearly 20 years. He specialises in version mIgration, performance, security, architecture and design including Azure and virtualisation solutions. He is working with private and public sector organisations in the UK, Europe and USA.

Gethyn delivers a range of SQL Server training, including the Microsoft Official Curriculum. He is the author of three training courses and two published books on SQL Server and Azure. You can find his blog at www.gethynellis.com

Dennes Torres

Twitter: - Dennes

LinkedIn: Dennes Torres

Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/

Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.

Lord Richard Douglas

Twitter: - SQLRich

LinkedIn: Lord Richard Douglas

Contact: http://SQL.RichardDouglas.co.uk

Lord Richard Douglas is a Principal Solutions Engineer at SentryOne, where he specialises in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, having run a PASS Chapter in the UK and having served on the organizing committee for SQLRelay. Richard is on Twitter as @SQLRich.

SQLSat927 Gold Sponsor

SQLSaturday Edinburgh event gold sponsor

Robert French

Twitter: - sql_bob

LinkedIn: Robert French

Contact: http://www.sqlbob.uk/

Data Shepherd, Data Plumber, and Data Dance Teacher. From the first day at university when Robert was introduced to a mainframe computer, it was love at first sight. Since then he has worked hard to establish a career in Business Intelligence. Having worked in a diverse range of industries such as Banking, Retail, Architecture, and now Grant Management software. Currently the co-organizer of the Glasgow SQL Server user group and always on the lookout for more computer mischief.

Mikael Wedham

Twitter: - @wedham

Contact: http://www.wedham.com

Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.

Erland Sommarskog

Contact: http://www.sommarskog.se

Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

Andrew Pruski

Twitter: - https://twitter.com/DBAFromTheCold

LinkedIn: Andrew Pruski

Contact: https://dbafromthecold.com/

SQL Server DBA with over 10 year’s experience. Originally from Wales but now living in Ireland

SQLSat927 Gold Sponsor

SQLSaturday Edinburgh event gold sponsor

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.

John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.

Kevin Chant

Twitter: - kevchant

LinkedIn: Kevin Chant

Contact: https://www.KevinRChant.com/

Senior Database Architect originally from the UK and now living in the Netherlands.

Over 23 years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.

In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications. In addition, was probably the last ever person in the world to gain the MCSD Azure Architect certification and has gained the latest Microsoft DevOps Engineer Expert certification.

Has real life experience with SQL Server and Azure Devops. Currently SQL Server Product Owner of around 1,900 instances.

In addition, done various things over the years for the Data Platform Community.

Shreeya Subramani

Shreeya Subramani is just 10 years old, and has a huge passion to share her knowledge and expertise that she has learnt so far from her father, Dr.Subramani Paramasivam (Microsoft MVP, MCT). Shreeya started speaking alongside her father when she was 6 years old. Since then, she started contributing to build and conduct Data Science classes for Kids.

Mark Pryce-Maher

Twitter: - tsqltidy

Contact: http://tsqltidy.blogspot.com

Mark Pryce-Maher is an Azure SQL Data Warehouse Architect at Microsoft with lots of database /azure experience.

John Martin

Twitter: - SQLDiplomat

LinkedIn: John Martin

Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/

John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.

John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.

Alex Yates

Twitter: - @alexyates

LinkedIn: Alex Yates

Contact: http://www.workingwithdevs.com

Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins.

A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.

Christophe Laporte

Twitter: - conseilit

LinkedIn: Christophe Laporte

Contact: http://conseilit.wordpress.com/

Christophe Laporte is based in Toulouse, France and has worked with SQL Server since 1997, starting with SQL Server 6.5. Focusing on high availability, VLDBs, and virtualization, Christophe also delivers performance audits on SQL Server and helps companies in choosing the appropriate architectures (Cloud, OnPremise, or Hybrid). In addition to his MCM certification, Christophe is also a SQL MVP, speaker, and Microsoft Certified Trainer since 2000.

SQLSat927 Gold Sponsor

SQLSaturday Edinburgh event gold sponsor

Rob Sewell

Twitter: - sqldbawithbeard

LinkedIn: Rob Sewell

Contact: http://sqldbawithabeard.com

Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.

He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.

SQLSat927 Gold Sponsor

SQLSaturday Edinburgh event gold sponsor

Chris Taylor

Twitter: - @SQLGeordie

LinkedIn: Chris Taylor

Contact: http://www.chrisjarrintaylor.co.uk

Chris (@SQLGeordie) is a Principal Consultant working at Jarrin Consultancy providing SQL Server and Microsoft Azure consultancy to clients worldwide in a variety of industries ranging from Financial to Healthcare. He has been working with SQL Server since 2001 and during that time has become extremely strong in all areas of SQL Server but specialises in Security, System Optimisation and SQL Server Internals.

Kevin Chant

Twitter: - kevchant

LinkedIn: Kevin Chant

Contact: https://www.KevinRChant.com/

Senior Database Architect originally from the UK and now living in the Netherlands.

Over 23 years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.

In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications. In addition, was probably the last ever person in the world to gain the MCSD Azure Architect certification and has gained the latest Microsoft DevOps Engineer Expert certification.

Has real life experience with SQL Server and Azure Devops. Currently SQL Server Product Owner of around 1,900 instances.

In addition, done various things over the years for the Data Platform Community.

Mark Broadbent

Twitter: - @retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.

SQLSat927 Gold Sponsor

SQLSaturday Edinburgh event gold sponsor

Rich Benner

Twitter: - https://twitter.com/RichBennerSQL

LinkedIn: Rich Benner

Contact: https://richbenner.com

A performance tuning DBA that loves optimising SQL Servers. I’ve had enough poorly servers thrown at me that I’ve gotten pretty good at fixing them quickly.

Oskari Heikkinen

LinkedIn: Oskari Heikkinen

I have several years of experience in using Azure for data analytics at large scale. I have been implementing numerous projects for some of the largest companies in the Nordics.

I am a Microsoft MVP, and I currently hold the MCSE: Data Management and Analytics certification. As a Microsoft Certified Trainer (MCT), I hold classes for subject-matter experts and consultants internally as well as give external customer training sessions. I am also an active speaker on community events.

Arne Bartels

LinkedIn: Arne Bartels

Master of physic in Germany 2000, worked as MS Flightsimulator Expert on the side. Employed at OLTEC Windamp;Solar as C++/Web/PHP/MySQL -Programmer. Company bought by Vestas 2004 shifting to MS-SQL,SSIS until now.

Mark Hayes

Twitter: - MarkDataGuy

LinkedIn: Mark Hayes

Mark Hayes (Certified Business Intelligence Professional (CBIP), MPP - Data Science, MPP - Big Data) is a freelance Microsoft Data Platform consultant and has worked with Microsoft data technologies since 2000 with a wide range of national and international companies. He is a regular speaker on Microsoft Data Platform topics and co-leader of the Cork SQL User Group and the Cork SQLSaturday.

Ted Malone

Twitter: - @tedmalone

LinkedIn: Ted Malone

Contact: http://blog.sqltrainer.com

Ted is currently a Data and AI Solution Architect with Microsoft’s Customer Success organization. In this role, he works with large organizations to ensure that they properly and efficiently apply AI, Machine Learning, Data Analytics, and Business Intelligence technologies to achieve their business goals. Prior to taking this role, Ted worked with the US Federal Government to help solve “Big Data” problems through the use of cloud technologies.

Prior to joining Microsoft, Ted was an architect in EMC’s CTO organization, and led data development teams for a variety of startup organizations.

Ted has worked with SQL Server since it’s inception, and focuses on applying new technologies and techniques to age-old problems.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page