SQLSaturday #748 - Cambridge 2018

Event Date: 09/08/2018 00:00:00

Event Location:

  • The Møller Centre
  • Churchill College, Storey’s Way
  • Cambridge, , 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).


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

Title: Azure Data : SELECT People FROM DataLake WHERE HappyFace = TRUE

Abstract: Discover the Advanced Analytics and Data Lake pattern in Azure Data Platform through a complete demo : how to get insights from text, photos and videos ? From different media files and raw data, we will analyze sentiment of characters and get valuable information in a Power BI dashboard, using Cognitive Services, CNTK, .NET and U-SQL. This session will mainly showcase Azure Data Lake and U-SQL language. But demos will involve different tools like Azure Data Factory for data supply chain and orchestration, Azure SQL Database for corporate data or even Machine Learning technics. Even if this session is demo-driven, concepts and features of Azure Data technologies will be discussed


  • Jean-Pierre Riehl

Track and Room: BI/ Analytics/ Data Scientist - Regnenses

Title: Adding unit tests with tSQLt to the database deployment pipeline

Abstract: Any database change is a good candidate for breaking the proper behavior of the system. How to avoid this? Unit tests at database level can help avoiding breaking the contract with the applications that consume data from the database, and also can help ensuring database correct behavior (for example: a stored procedure do what’s supposed to do, or a specific table indeed exists). In this talk I will address the basic steps to introduce unit tests at databases using tSQLt. tSQLt is a unit testing framework the allow to write, execute and diagnose tests for T-SQL code. After writing the tests, I will explore how can tests execution be include in the deployment pipeline.


  • Eduardo Piairo

Track and Room: Developer - Durotriges

Title: Enabling Citizen Data Science with Microsoft

Abstract: In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics. Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure. These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about creating fools-with-tools or should we embrace the democratization of data science as the golden age of data? In this demo heavy session we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.


  • Jan Mulkens

Track and Room: BI/ Analytics/ Data Scientist - Trinobantes

Title: Azure Data Factory v2 – SSIS Data Flows Custom Extensibility

Abstract: Azure Data Factory version 2 (ADFv2) arrived in Sept17 with a bunch of new concepts and features to support our Azure data integration pipelines. In this session, we’ll update your ADFv1 knowledge and start to understand the true nature of scale out control flows and data flows. What’s the integration runtime? Can we easily lift and shift our beloved SSIS packages into the cloud? How do we embed expressions to achieve dynamic activity executions? Do we still need SSIS with the ADF platform as a service? The answers to all these questions and more in this demo packed session. An awareness of Azure Data Factory v1 is recommended before attending this session.


  • Paul Andrew

Track and Room: BI/ Analytics/ Data Scientist - Trinobantes

Title: Azure Managed Instances—Your Bridge to the Cloud

Abstract: Many organizations would like to take advantage of the benefits of using a platform as a service database like Azure SQL Database. Automated backups, patching, and costs are just some of the benefits. However, Azure SQL Database is not a 100% feature compatible with SQL Server—features like SQL Agent, CLR and Filestream are not supported. Migration to Azure SQL Database is also a challenge, as backup and restore and log shipping are not supported methods.

Microsoft recently introduced Managed Instances—a new option that provides a bridge between on-premises or Azure VM implementations of SQL Server and Azure SQL Database. Managed Instances provide full SQL Server surface compatibility and support database sizes up to 35 TB.

In this session, you will learn about migrating your databases to Managed Instances, developing applications for managed instances. You will also learn about the underlying high availability and disaster recovery options for the solution.


  • Joseph D’Antoni

Track and Room: Enterprise/ Administration - Durotriges

Title: Using AI to write session submission to SQLSaturday

Abstract: Deep learning has been used to write new Shakespearean sonnets, to imagine new delicious recipes, write hilarious Harry Potter novels and even come up with new names for beer! In this session we will understand, what is deep learning, what are neural nets, what are the steps required to build a deep learning model and look at some of the great examples mentioned.

We will then turn our new skills to the problem most speakers have! Writing session abstracts. Together we will develop a recursive neural net designed to generate new SQLSaturday session abstracts, entirely based on previously submitted sessions to SQLSaturday. Will we be able to produce a session you would have attended? Come along and fine out.


  • Terry McCann

Track and Room: BI/ Analytics/ Data Scientist - Iceni

Title: Let’s Build SSIS Packages with Biml – Live!

Abstract: Have you heard about the Business Intelligence Markup Language (Biml)? Maybe you’ve even seen a session about it before but you still have doubts about how easily you can make something useful out of it. In this session, we’ll use Biml to build and populate a staging area including the corresponding SSIS packages. But there won’t be any pre-compiled demos - everything is happening live! Starting with a blank staging database, we will end up building a complete solution over the course of this session to prove that you can start from scratch and still quickly be successful. Let’s see, how that goes… 

PS: Even if you have not heard about Biml but are still tired of manually building SSIS packages, this is the right session for you!


  • Ben Weissman

Track and Room: BI/ Analytics/ Data Scientist - Regnenses

Title: Open Knowledge Platform Use-Cases

Abstract: Many of Open Knowledge International’s projects are technical in nature. Its most prominent project, CKAN, is used by many of the world’s governments to host open catalogues of data that their countries possess.

CKAN is a tool for making open data websites. (Think of a content management system like WordPress – but for data, instead of pages and blog posts.) It helps you manage and publish collections of data. It is used by national and local governments, research institutions, and other organizations who collect a lot of data.

In this talk I’ll go over some use-cases of Open Knowledge Platform implementations by the Portuguese Government, the architectural features, the difficulties and different approaches to solve them.


  • Pedro Sousa

Track and Room: Business/ End user - Belgae

Title: Graph Databases and Solutions

Abstract: The modern connected world requires connected solutions, beyond basic relational engine - think about web pages connections, social media network communications or map path finding. Even though one can implement eventually everything with a relational engine, the bigger amount of analysed data is involved, the less probable is that your analysis will be done on time and with acceptable ease for the developers.

Graph databases do exist in the wild since 1960s, but only in the last 2 decades - with the advances of the internet, started to conquer wider recognition and usage.

Let’s dive into this diverse world of graph databases and discover the new kid on the block - the GraphDB in SQL Server 2017 Azure SQL Database, which promises to allow you to expand and convert your workloads for solving modern connected world problems.


  • Niko Neugebauer

Track and Room: Enterprise/ Administration - Trinobantes

Title: Enterprise Power BI – Development Lifecycle

Abstract: When your development team is up to a certain size, and often no matter what size it is, you want to start following best development practices. These include things like source control, multiple environments, deployment processes, and governance. As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are, these things can get tricky. In this session we will look at what Power BI has to offer when it comes to development lifecycle. We will look at the different options available to the developer when it comes to source control, multiple environments, deployment and distribution of Power BI content. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI. For all these topics we will look at the capabilities Power BI offers and how we, in the company where I work, decided to implement it.


  • Asgeir Gunnarsson

Track and Room: BI/ Analytics/ Data Scientist - Belgae

Title: Monitoring Linux Performance for the SQL Server Admin

Abstract: So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we’ll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, and Memory and monitoring techniques for each.


  • Anthony Nocentino

Track and Room: Enterprise/ Administration - Iceni

Title: Modern Data Warehousing - The Lambda Approach to Azure BI

Abstract: Technology changes quickly - patterns and approaches less so. As people move towards the cloud, there are clear benefits of adopting a polyglot cloud architecture employing a range of distributed components.

This session will take you through the pattern known as the Lambda architecture, a reference pattern for building data analytics systems that can handle any combination of data velocity, variety and volume. The session will outline the set of tools and integration points that can underpin the approach. Do you design real-time reporting systems? Or crunch petabytes of data? Perhaps you are adopting a cloud architecture and just want to handle anything the future throws at you? This session is for you.

We will follow the movement of data through batch and speed layers via Azure Data Lake Store Analytics and Streaming Analytics before considering the serving layer with Azure SQL DataWarehouse and downstream reporting tools.


  • Simon Whiteley

Track and Room: BI/ Analytics/ Data Scientist - Durotriges

Title: Deep dive into Adaptive Query Processing

Abstract: Until SQL Server 2016, the Query Optimizer and the Execution Engine were strictly separated. The Query Optimizer produces an execution plan that, based on statistics and estimates, should be fast. That execution plan is then faithfully executed by the Execution Engine, even if reality turns out to be different from expectations.

SQL Server 2017 changes this! Three new features now allow execution plans to adapt to reality. Memory Grant Feedback increases or decreases assigned memory based on past experience. The Adaptive Join operator allows the optimizer to create two alternative plans, the best of which will be decided at execution time. And with Interleaved Execution, parts of the plan are even completely recompiled mid-execution, with much better cardinality estimates.

If you are more interested in how all this ACTUALLY works than in shiny marketing slides, come to this session. We will spend the full 60 minutes knee-deep in execution plan internals!


  • Hugo Kornelis

Track and Room: Developer - Iceni

Title: A Gentle Intro to Multi-master Replication

Abstract: Whenever we have two independently updatable copies of a piece of data, we live with the spectre of merge conflicts. This problem has existed for ages, but with so much distributed architecture in the cloud era, more of us get exposed to the pain.

Conflict-free replicated data types (CRDTs) evolved as a way to accept updates at multiple replicas with automatic conflict resolution, and to remove such concerns from application development. Inevitably though, you have to apply a different mindset to data design.

In this talk, I’ll cover the basic premise of what CRDTs are, a few example CRDTs, the kind of programming interface they expose, and a glimpse into their internal workings. While the literature in this area tends to be a bit academic, we’ll be taking a commonsense approach, giving you a useful toehold into the subject for further exploration.


  • Ewald Cress

Track and Room: Developer - Trinobantes

Title: Blockchain - The data platform perspective

Abstract: Popularized by Bitcoin, now with Ethereum Co already at least in version 2.x. What is technically behind the ominous blockchain, what does it have to do with databases and data warehousing? Are smart contracts only interesting for the financiers? And why should you program contracts? In the first part of this session, we deliver the background, and not just technically.

In the second part we take a closer look at the bitcoin blockchain as a “database”. Starting point here: How anonymous really is the whole thing, when everything must be visible to everyone? After a brief introduction to its structure, we load the blockchain of bitcoin (that is, all the transactions that have been done so far) into Neo4J, a graph database and look what analyzes are possible (and why does a Graph DB work better here? And why aren’t we using the new exciting Graph stuff of SQL Server 2017???) Visualization and further analysis we do with Power BI, directly connected to Neo4j.


  • Christoph Seck

Track and Room: Enterprise/ Administration - Belgae

Title: Back to the future - Migrating our SQL Server OnPremise Database Minicon

Abstract: ALL receipts (minus Eventbrite booking fee) goes directly and immediately to Children’s Cancer Charity Edie’s Butterfly Appeal -giving hope through research for all children fighting ependymoma

Only 8 slots available for this special intimate charity 2-hour mini-con session on SQL Server migration to Azure by two of Microsoft Espana’s top escalation engineers! https://www.eventbrite.co.uk/e/migrating-our-sql-server-onpremise-database-to-azure-tickets-48645214145

This session will cover the main aspects required to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise.

In this workshop we will cover:

What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse. Best Practices and best tools for our migration process depending on the platform chosen.

After the migration, we will address several outstandin


  • Jose Manuel Jurado Diaz

Track and Room: Charity Mini-Con - Cornovii

Title: Climbing the SQL Server Index B-Tree (from a user perspective)

Abstract: SQL Server® has many performance WOMs (Word of Mouth), especially concerning indexes to include: • keep clustered index width small • unique indexes perform better • keep non-clustered index width small • compressed indexes have fewer logical reads This session dives down and looks at important items within index pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command to factually document index WOMs. The effect of row data compression on clustered and non-clustered indexes are also investigated. The demos will ascertain how the SQL Server® optimizer might use them and strive to gain some insight from a performance advantage. The session is 80% demos. This presentation will propel the layman to a new level of index understanding. Performance! That’s what we are all looking for. Blast off with this presentation.


  • Mike Byrd

Track and Room: Enterprise/ Administration - Durotriges

Title: Branding Yourself for a Dream Job

Abstract: Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it’s important to raise your profile in today’s highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.


  • Steve Jones

Track and Room: Business/ End user - Trinobantes

Title: Azure Cosmos DB - What you need to know to build globally distrib

Abstract: In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB. There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.


  • Satya Jayanty

Track and Room: Enterprise/ Administration - Regnenses

Title: SQLOpsStudio Vs SSMS - There can be only one

Abstract: SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS? In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.


  • Warwick Rudd

Track and Room: Developer - Durotriges

Title: Azure Machine Learning 101

Abstract: You have probably heard the buzz about Azure Machine Learning, aka Azure ML, over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.


  • Kathi Kellenberger

Track and Room: BI/ Analytics/ Data Scientist - Regnenses

Title: Data Science for Kids and beyond

Abstract: I play a vital role in building and test run the modules that is developed for DSKA (Data Science Kids Academy) and also I deliver few lessons. In this session, I am going to share my experience in what I have learnt about Data Science and also will do a demo in Program R.


  • Shreeya Subramani

Track and Room: BI/ Analytics/ Data Scientist - Regnenses

Title: Hiding data with SQL Server

Abstract: Security is unquestionably a major priority for Microsoft. Join me in this session and see what security features Microsoft has released since SQL Server 2016. In this session you will see how Dynamic Data Masking and Row-Level Security works in on-perm and Azure environments and how to use Always Encrypted.


  • Ivan Campos

Track and Room: Developer - Durotriges

Title: Data Classification in SQL Server and Azure SQL Database

Abstract: In this session to look at the functionality built into SQL Server Management Studio (SSMS) and in Azure SQL Database to classify your database. I run through the need for data classification in general and why its important for GDPR. We will run though classifying your data and how to report on it.


  • Mark Pryce-Maher

Track and Room: Enterprise/ Administration - Iceni

Title: Data Cleansing With SQL And R

Abstract: On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.


  • Kevin Feasel

Track and Room: BI/ Analytics/ Data Scientist - Regnenses

Title: Power BI server and Office Online server, modernize your on-premises BI approach.

Abstract: Your company is not-yet- ready for the cloud ? How to refresh your BI solution by providing the beauty of Power BI reports on premises and the ability from the same place to consume your legacy reports or to share efficiently your data model through a unique place. Demo based session with a strong architecture introduction and a “from the field” real project feedback.


  • Isabelle Van Campenhoudt

Track and Room: BI/ Analytics/ Data Scientist - Iceni

Title: Containers - You Better Get on Board

Abstract: Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get your started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

In this session we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes


  • Anthony Nocentino

Track and Room: Enterprise/ Administration - Iceni


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

Paul Andrew

Twitter: - mrpaulandrew

LinkedIn: Paul Andrew

Contact: https://mrpaulandrew.com/

Paul Andrew is a principal consultant and architect, specializing in big data solutions on the Microsoft Azure cloud platform. Paul’s data engineering competencies include Azure Data Factory, Data Lake, Databricks, Stream Analytics, Event Hub, IoT Hub, Functions, Automation, Logic Apps, and of course the complete SQL Server Business Intelligence stack.

He has many years’ experience working within healthcare, retail, and gaming verticals, delivering analytics using industry leading methods and technical design patterns.

Paul is a STEM ambassador and a very active member of the data platform community delivering training and technical sessions at conferences both nationally and internationally.

He is a father, husband, swimmer, cyclist, r

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

Ben Weissman

Twitter: - bweissman

LinkedIn: Ben Weissman

Ben Weissman has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. He is a Data Platform MVP, MCSE Data Management and Analytics, and a Certified Data Vault Data Modeler. He is also the first BimlHero Certified Expert in Germany and a co-author of ‘SQL Server Big Data Clusters’ and ‘The Biml Book’. Ben has been involved in more than 150 BI Projects and is always looking for ways to become more productive and make SQL Server even more fun! Together with his team at Solisyon, Ben provides training, implementation and consultancy for SQL/BI developers and data analysts in upper-mid-market companies around the globe.

Jose Manuel Jurado Diaz

Twitter: - jmjuradodiaz

LinkedIn: Jose Manuel Jurado Diaz

José Manuel Jurado currently works as SQL Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 20+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events such as SQLSaturday, SQL Nexus, SQLBits, Pass Summit, SQL Server Konferenze, TechReady, DotNetConference, and Azure BootCamp. In the past, he worked as Project Manager for large global retail company for more than 10 years developing projects using different Microsoft Technologies.

Simon Whiteley

Twitter: - MrSiWhiteley

LinkedIn: Simon Whiteley

Contact: http://blogs.adatis.co.uk/blogs/simonwhiteley/

Simon Whiteley is the Director of Engineering for Advancing Analytics Ltd and a Microsoft Data Platform MVP. Simon is a seasoned solution architect and technical lead with well over a decade of Microsoft Analytics experience. A deep techie with a focus on emerging cloud technologies and applying “big data” thinking to traditional analytics problems, Simon also has a passion for bringing it back to the high level and making sense of the bigger picture. When not tinkering with tech, Simon is a death-dodging London cyclist, a sampler of craft beers, an avid chef, and a generally nerdy person.

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

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Jean-Pierre Riehl

Twitter: - djeepy1

LinkedIn: Jean-Pierre Riehl

Contact: http://blog.djeepy1.net

Architect, Consultant, Trainer and also Manager, Jean-Pierre leads the Data BI Practice at AZEO, a French Microsoft “pure-player” partner. Jean-Pierre is MVP Data Platform since 2008 and speaks at many events in France and in Europe. JP leads the local community (GUSS) and organize events in France since 2011 : MS Cloud Summit, Les Journées SQL Server, SQLSaturday, etc. JP is passionate by data concerns in business like Data Governance, Data Quality or Data Vizualisation and since 2010, he’s specialized in Self-Service BI. His favorite topic is Power BI and business usages and technical architectures that go with.

Jan Mulkens

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

LinkedIn: Jan Mulkens

Contact: http://www.janmulkens.be

Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).

Hugo Kornelis

Twitter: - Hugo_Kornelis

LinkedIn: Hugo Kornelis

Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx

Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of “the Execution Plan Reference” (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey’s “SQL Server Execution Plans, 3rd edition” and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present).

When not working for the community, he is busy at his day job: freelance database developer/consultant.

Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.

When not working for the community, he is busy at his day job: freelance database developer/consultant.

Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.

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.

Ewald Cress

Twitter: - @sqlonice

LinkedIn: Ewald Cress

Contact: http://sqlonice.com

Ewald is a software developer with particular interest in SQLOS and SQL Server internals. He spends an unseemly amount of time engaged with x64 assembly language. In a previous life he earned his bread as a musician, but then discovered the joys of databases, regular working hours, and middle age.

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.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

Asgeir Gunnarsson

Twitter: - bidgeir

LinkedIn: Asgeir Gunnarsson

Ásgeir Gunnarsson is a Data Platform MVP and Chief Consultant at Datheos in Denmark. He works on Business Intelligence solutions using the whole of the Microsoft BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI, Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.

Ásgeir speaks regularly at events both domestically and internationally, and is the group leader of the Icelandic PASS Group, as well as the Icelandic Power BI User Group.

Ásgeir is passionate about data and loves solving problems with BI.

Anthony Nocentino

Twitter: - nocentino

LinkedIn: Anthony Nocentino

Contact: http://www.centinosystems.com/blog/

Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com

Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.

Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.

Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

Ivan Campos

Twitter: - WizardDBA

LinkedIn: Ivan Campos

Contact: http://wizarddba.com/

Ivan Campos is currently a database administrator in 3C Payment a fin-tech in Luxembourg. (3CPayment.com). He is Microsoft Most Valuable Professional, active speaker at local community meetings in Portugal and outside Portugal. He is the leader and one of the founders of the community based in the north of Portugal Porto.Data (www.portodata.net) and the organizer of SQLSaturday in Porto Portugal.

Warwick Rudd

Twitter: - @warwick_Rudd

LinkedIn: Warwick Rudd

Contact: http://www.sqlmastersconsulting.com.au/Blog

Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.

Pedro Sousa

Twitter: - psousa75

LinkedIn: Pedro Sousa

Contact: http://www.devscope.net

Pedro Sousa lives in Porto, Portugal and he currently works as a Senior IT Operations Analyst at Basecone. Started working with SQL Server at version 6.5 and although DBA is not his primary role, always had a particular interest for it. Nowadays one of his main focus is Microsoft Azure and integration with on-premises networks, working from the copper wire to the Cloud.

Christoph Seck

Christoph works as a BI Architect for KI Performance. With SQL Server and its BI Stack he is dealing for more than 15 years. He is cofounder and chapter leader of the German PASS chapter of Hannover, Visiting Lecturer at the University of Hildesheim and regular speaker at conferences and German PASS events on DWH topics and agile project management.

Anthony Nocentino

Twitter: - nocentino

LinkedIn: Anthony Nocentino

Contact: http://www.centinosystems.com/blog/

Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.

Eduardo Piairo

Twitter: - @EdPiairo

LinkedIn: Eduardo Piairo

Contact: http://www.eduardopiairo.com/

Deployment pipeline craftsman always ready to learn new ways to implement Source Control, Continuous Integration and Continuous Delivery for databases, applications and infrastructure.

Database administrator with special interest in database changes and data modeling.

Operations engineer, DevOps Agent with automation, collaboration and communication as priorities.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

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.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.


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

Back to the SQLSaturday Event List

Back to the home page