Event Location:
Edinburgh Training and Conference Venue
16 St Mary's St, Edinburgh
Edinburgh, Scotland, United Kingdom
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
Abstract:
SQL Saturday Edinburgh (SQLSat927) GOLD sponsor session.
Speaker(s): SQLSat927 Gold Sponsor,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
Abstract:
SQL Saturday Edinburgh (SQLSat927) GOLD sponsor session.
Speaker(s): SQLSat927 Gold Sponsor,
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,
Abstract:
SQL Saturday Edinburgh (SQLSat927) GOLD sponsor session.
Speaker(s): SQLSat927 Gold Sponsor,
Abstract:
SQL Saturday Edinburgh (SQLSat927) GOLD sponsor session.
Speaker(s): SQLSat927 Gold Sponsor,
Abstract:
SQL Saturday Edinburgh (SQLSat927) GOLD sponsor session.
Speaker(s): SQLSat927 Gold Sponsor,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/retracement
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.
LinkedIn: http://uk.linkedin.com/in/dageop
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.
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 SQL Saturday Holland.
LinkedIn: http://be.linkedin.com/pub/isabelle-van-campenhoudt/2/558/52b/
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
LinkedIn: http://be.linkedin.com/in/cedriccharlier
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.
LinkedIn: http://www.linkedin.com/in/scarydba
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.
LinkedIn: https://uk.linkedin.com/in/tpmccann
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.
LinkedIn: https://uk.linkedin.com/in/gethynellis
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
LinkedIn: https://www.linkedin.com/in/dennestorres/
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.
LinkedIn: http://uk.linkedin.com/in/richardpdouglas
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.
SQL Saturday Edinburgh event gold sponsor
LinkedIn: https://www.linkedin.com/in/rwlpfrench/
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.
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.
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.
LinkedIn: https://www.linkedin.com/in/andrewpruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year's experience. Originally from Wales but now living in Ireland
SQL Saturday Edinburgh event gold sponsor
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
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.
LinkedIn: https://www.linkedin.com/in/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 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.
Contact: http://tsqltidy.blogspot.com
Mark Pryce-Maher is an Azure SQL Data Warehouse Architect at Microsoft with lots of database /azure experience.
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
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.
LinkedIn: http://uk.linkedin.com/in/alexanderyates
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.
LinkedIn: http://fr.linkedin.com/in/christophelaporte
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.
SQL Saturday Edinburgh event gold sponsor
LinkedIn: https://uk.linkedin.com/in/robsewellsqldba
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.
SQL Saturday Edinburgh event gold sponsor
LinkedIn: https://uk.linkedin.com/in/jarrinuk2000
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.
LinkedIn: https://www.linkedin.com/in/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.
LinkedIn: http://www.linkedin.com/in/retracement
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.
SQL Saturday Edinburgh event gold sponsor
LinkedIn: https://www.linkedin.com/in/richard-benner-856a0b47/
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.
LinkedIn: https://www.linkedin.com/in/oskariheikkinen/
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.
LinkedIn: https://www.linkedin.com/profile/view?id=207669359amp;trk=nav_responsive_tab_profile
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.
LinkedIn: https://www.linkedin.com/in/markhayes/
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 SQL Saturday.
LinkedIn: https://www.linkedin.com/in/temalone/
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.
The following is a list of sponsors that helped fund the event.