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
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: 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- Anthony Nocentino
Track and Room: Enterprise/ Administration - Iceni
Speakers
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.
Sponsors
The following is a list of sponsors that helped fund the event: