SQLSaturday #862 - Cork 2019
Event Date: 06/29/2019 00:00:00
Event Location:
- University College Cork
- Western Gateway, Western Road, Cork
- Cork, County Cork, Ireland
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: Performance Dreams started at SQL Server 2014 and came true now at SQL Server 2016,2017
Abstract: “Performance Dreams started at SQL Server 2014 and came true now at SQL Server 2016,2017 “, it is just like this because you there are unbelievable performance reads and substantial improvements that can drive your DB environment to a distinct level of stability and Performance to be a leading environment in a very short time ..! It looks like apparently a myth or legend to see those new SQL Server 2016 features how they could flipped up SQL Server Powers from the old generation to the new generation of in-advanced analytics using In-memory and CCI (Colmnstore indexes) where no longer need for any DWH solutions at all but just reading data directly from production DBs with ZERO performance impacts on end users ..! come in here to my session and you will know more about many new features and rich powers of SQL Server 2014 2016 regarding performance particularly like Microsoft project “Hekaton” for In-memory built in for OLTP , CCI( columnstore index) ,Resource Governor for IO
Speaker(s):
- Shehab El-Najjar
Track and Room: Enterprise Database Administration Deployment - Room1
Title: Understanding the Transaction Log For Faster Throughput
Abstract: Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log? There’s no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log, however, is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It’s as if it doesn’t matter, an afterthought, a relic of the platform architecture. In this session, you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices. From understanding the internals we can design for faster recovery and batch processes and ironically a smaller transaction log!
Speaker(s):
- Lord Richard Douglas
Track and Room: Enterprise Database Administration Deployment - Room3
Title: Connecting SQL and Blockchain: The Azure Blockchain Workbench [EN]
Abstract: Hype as it is, a valid business case currently is the most critical point for a Blockchain project. So better check it out with a PoC and best with a fast PoC before you start burning money. But getting even a simple PoC for a Blockchain project running still is hard. Connecting Blockchain data to classical databases, making them available to analytics or standard applications is worse (ever queried LevelDB?). Microsofts new “Azure Blockchain Workbench” let you do this in hours, not months. So (besides wondering why one needs this hype stuff at all) we will see how to
- Deploy a Blockchain on Azure in a breeze
- Start coding with Solidity
- Generate templates for smart contracts
- Connect them to IoT devices
- Get a PoC Web UI for free
- Push all the data into a “real” database automatically
Last but not least, we can look at some real world projects.
Speaker(s):
- Christoph Seck
Track and Room: Cloud Application Development Deployment - Room1
Title: Training a large-scale recommendation engine on SQL server 2019
Abstract: In this session, we will show how to train a recommendation engine on SQL Server 2019 Big Data clusters (BDC) on Azure Kubernetes Services (AKS) using Python, Spark, and SQL. SQL Server 2019 is the first version that tightly integrates HDFS and Apache Spark with a SQL Server engine. We will start with an overview of the SQL Server 2019 architecture for Big Data clusters. After a brief introduction to Recommender Systems, we will load product ratings to HDFS and link them to the customer and product data in SQL using Polybase. Then we will explore the dataset using Spark, Python and Data Studio and ultimately create a Training and Validation split. In the next step, we will train the Recommendation engine in Spark and persist the model to HDFS. Every step will be performed within the same SQL Server 2019 BDC cluster showcasing the incredible capabilities of SQL 2019. On-top, by building on SQL Server 2019 BDC and Kubernetes you can run your cluster locally, on premises, or in the cloud.
Speaker(s):
- Kaijisse Waaijer
Track and Room: Advanced Analysis Techniques - Room2
Title: 2 Fast 2 Furious - designing for speed, concurrency, and correctness
Abstract: With the multitude of isolation levels, concurrency models, and specialist technologies available in SQL Server, it is no surprise that transaction throughput and correctness can be directly correlated to the ability and knowledge of the person that wrote the code.
In this session, we will reveal how SQL Server concurrency and correctness often goes wrong, how we can avoid this, and how we can use our knowledge to design and develop for optimal server throughput for our applications and processes using tips and tricks gained from real-world scenarios.
We will cover SQL Server’s traditional locking model, In-Memory OLTP, Columnstore, Delayed Durability, and many other technologies and techniques you can use to make your transactions more robust.
Speaker(s):
- Mark Broadbent
Track and Room: Application Database Development - Room4
Title: An introduction to Data Mining with SQL Server 2017
Abstract: With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
1) Defining what questions we want answered and how to go about this in an effective and efficient manner.
2) Creating the data model.
3) How to gather the necessary data, discussing the training and testing aspect.
4) Processing the model.
5) Extracting information from our finished model, discussing the implications of this information.
Speaker(s):
- Steve Simon
Track and Room: Analytics and Visualization - Room1
Title: SQL Server Kubernetes
Abstract: Running SQL Server in containers has huge benefits for Data Platform professionals but there are challenges to running SQL Server in stand alone containers. Orchestrators provide a platform and the tools to overcome these challenges.
This session will provide an overview of running SQL Server in Kubernetes, which is the leading orchestrator.
Topics covered will be: - An overview of Kubernetes. Definition of deployments, pods, and services. Deploying SQL Server containers to Kubernetes. Persisting data for SQL Server in Kubernetes.
This session is aimed at SQL Server DBAs and Developers who want to learn the what, the why, and the how to run SQL Server in Kubernetes.
Speaker(s):
- Andrew Pruski
Track and Room: Enterprise Database Administration Deployment - Room4
Title: Many roads to reporting with Microsoft BI technologies
Abstract: This session looks at the reporting technologies that are available from Microsoft for BI reporting. We will look at how Microsoft BI technologies can be used to meet a wide range of user needs, from personal BI to Enterprise-wide reporting. We will demo of various technologies can be used to meet your reporting needs and the similarities and differences between them.
Topics: Excel, Power BI, SQL Reporting Services 2017, Power BI Server, Data Models, Self Service Reporting
In this session we will see cover;
- Organisational Information Needs
- Data Modeling
- Microsoft Reporting technologies overview
- Demo on Key Reporting Technologies
Speaker(s):
- Mark Hayes
Track and Room: BI Information Delivery - Room2
Title: Complex Azure Orchestration with Dynamic Data Factory Pipelines
Abstract: If you have already mastered the basics of Azure Data Factory (ADF) and are now looking to advance your knowledge of the tool this is the session for you. Yes, Data Factory can handle the orchestration of our ETL pipelines. But what about our wider Azure environment? In this session we’ll go beyond the basics looking at how we build custom activities, metadata driven dynamic design patterns for Data Factory. Plus, considerations for optimising compute costs by controlling other service scaling as part of normal data processing. Once we can hit a REST API with an ADF web activity anything is possible, extending our Data Factory and orchestrating everything.
Speaker(s):
- Paul Andrew
Track and Room: BI Platform Architecture, Development Administration - Room1
Title: Modern Data Warehousing - The Lambda Approach to Azure BI
Abstract: Technology changes quickly - patterns and approaches less so. As we move towards distributed cloud architectures we will employ a range of disparate tools, the patterns that were designed for single box solutions may not be appropriate any more.
We will first review the patterns and processes that underpin the Lambda architecture, providing advice and guidance on the tool sets and integration points between them.
This intense, demo-packed session implements real-time reporting using the Lambda Architecture in Azure, demonstrating Azure Data Lake Store, Azure Databricks, Data Factory, SQL Datawarehouse and Stream Analytics. Time permitting, we will compare and contrast against an alternative pattern using Cosmos DB Spark Structured Streaming.
Speaker(s):
- Simon Whiteley
Track and Room: BI Platform Architecture, Development Administration - Room3
Title: Data Vault data warehousing - an introduction
Abstract: In addition to the Data Vault approach being touted as the next generation data warehouse modelling technique, with the arrival of Data Vault 2.0 comes a complete data modelling, methodology and architectural offering. This talk will introduce you to the core Data Vault concepts including support for an agile data warehouse, how it can contribute to faster sprints, how it lends itself to automated data model creation, how the Hub, Link and Satellite design is a perfect fit for massively parallel data load and how to virtualize a Data Mart over a Data Vault. It will also cover how a single version of the facts edges out a single version of the truth. Demo: Using a SQL 2017 data source, we will orchestrate the extraction, transformation and load to a Data Vault data warehouse including an example virtualized Data Mart layer. The orchestration will take place using Azure Data Factory v2.
Speaker(s):
- Dan Galavan
Track and Room: Strategy and Architecture - Room2
Title: Keeping your SQL Code safe – An introduction to GIT and SSDT for DB professionals
Abstract: Imagine that you have been hard working in that amazing project, your SQL code has been tuned and contains new features and followed the standard that will be crucial for the success of this project. The deploy date has arrived and you have deployed early in the morning but some minutes after the deploy, the users started to call for reporting several issues in the different systems which are using the Databases that were part of your deployment, after stressful minutes, you realized some SQL code deployed were not the same that were tested and you must rollback your code.
In this session, I’m going to show you how to avoid problems derived of mistakes during the development process through the proper use of source control code strategy which can combine the potential of GIT and SQL Server Data Tools (SSDT) for managing latest version, detecting changes, code review and deploying through environment without stress.
Speaker(s):
- Geovanny Hernandez
Track and Room: Application Database Development - Room1
Title: Using Azure Cosmos DB and DataBricks to provide Realtime Customer Matching
Abstract: Find out how a major UK hotel chain unified their wildly different sources of customer data to build a supercharged automated customer communication engine.
Cosmos DB and Databricks where used to process and match customer data in real-time, helping them get to know their customers, how best to retain them, and how best to keep them happy, all while ensuring GDPR compliance.
Learn how downstream systems received customer identifiers allowing tailored content to be produced in near real time, and how business users consumed the insights via Power BI
Learn how scale up and scale down allowed us to meet challenges around massive initial data loads, without blowing the project budget.
Find out what lessons were learned and what best practices helped ensure that the Cosmos DB, Azure Functions, Event Hubs and Azure Databricks instances all played harmoniously together. Hear how we used partitioning, indexing, scaling and other cloud design patterns to deliver incredible performance.
Speaker(s):
- Brynn Borton
Track and Room: BI Platform Architecture, Development Administration - Room2
Title: SQL Notebooks in Azure Data Studio for the DBA
Abstract: An Azure Data Studio recent release introduced SQL Notebooks as a capability.
While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.
You will learn about SQL Notebooks from installing them in Azure Data Studio to creating a Notebook for Glenn Berry’s Diagnostic queries as well as numerous use cases for you to use in your daily workload
Speaker(s):
- Rob Sewell
Track and Room: Enterprise Database Administration Deployment - Room4
Title: Database Continuous Integration and Delivery (CI/CD) using Visual Studio and DACFx for SQL Server
Abstract: Implementing CI/CD on a database platform is never going to be straightforward! During this session, I will provide a high level overview of our pipeline, the tools we use, and some of the lessons we’ve learned along the way.
Speaker(s):
- Angela Ross Innes
Track and Room: Application Database Development - Room2
Title: Power BI KISS, make it beautiful
Abstract: In this session Mary will demo building a Power BI solution using Low-Code/No-Code while using the principle of Keep it Simple Stupid. This will allow attendees to see how quickly you can build out an simple but effective solution with relative ease. She will also share some of her technics for creating a unique look and feel to the report that makes for a positive user experience, by using PowerPoint, Power BI Bookmarks the new Filter Pane. This session is for folks who are new to Power BI but should be of interest to fellow Power BI Pros.
Speaker(s):
- Mary Fealty
Track and Room: PowerBI - Room2
Title: Intro Into Index Analysis
Abstract: Indexing in SQL Server is both - art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes.
In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: Enterprise Database Administration Deployment - Room3
Title: Architecting SQL Server environments for Mission Critical and High Performance
Abstract: Mission critical SQL Servers require right architecture to satisfy SLAs, high availability, and disaster recovery requirements for your critical IT operational data environment. The ability to scale up these environments, to provide the level of performance required by OLTP and provide adequate resources is a significant operational challenge.
Speaker(s):
- Marcelo Fernandes
Track and Room: Enterprise Database Administration Deployment - Room4
Title: Rock Your Session - Best Practices for Presentations
Abstract: Just because you’re a technical rock star doesn’t mean your technical presentation is going to rock. And even if you own the room for technical presentations, you may find that your business presentations often fall short. This session is for veteran presenters as well as first-timers, offering prescriptive guidance and best practices for structuring, building, and delivering a compelling presentation every time—whether technical or non-technical. Effective and persuasive presentation skills are critical for survival and success in the workplace—this is a session worth checking out.
Speaker(s):
- Douglas McDowell
Track and Room: Professional Development - Room3
Title: Working with SQL Managed Data Types
Abstract: The Geospatial and Hierarchical managed data types were introduced with SQL 2005 but are sadly seldom used (or understood) by most developers more than a decade later. In this session Peter Willmot will take you on a guided tour of these data types (along with the basics of SQL CLR integration with C#) and help you to understand the pros and cons of their inclusion in your database/application design.
Speaker(s):
- Peter Willmot
Track and Room: Application Database Development - Room4
Title: Launching A Data Science Project: Cleaning Is Half The Battle
Abstract: There’s an old adage in software development: Garbage In, Garbage Out. This adage certainly applies to data science projects: if you simply throw raw data at models, you will end up with garbage results. In this session, we will build an understanding of just what it takes to implement a data science project whose results are not garbage. We will use the Microsoft Team Data Science Process as our model for project implementation, learning what each step of the process entails. To motivate this walkthrough, we will see what we can learn from a survey of data professionals’ salaries.
Speaker(s):
- Kevin Feasel
Track and Room: Advanced Analysis Techniques - Room4
Title: Implementing AI solutions using the cognitive services in Azure
Abstract: Artificial Intelligence (AI) is bringing big changes in the way people and businesses relate to technology. As well as the arrival of the personal computer, the cloud computing and smartphones, the AI is the artificial technology that takes you to where you’re going so much faster, intuitive and smart. In this session we will discuss the basics of IA and how we can apply it in our business using the Azure Cognitive Services.
Speaker(s):
- Vitor Fava
Track and Room: Advanced Analysis Techniques - Room2
Title: Eight hours of work in 20 minutes
Abstract: A case study of how a monthly data load has evolved, from just loading data into a table, through some indexes being disabled before loading and enabled after data is loaded, to partitioning the table and loading into a staging table. The last Changes to the solution has taken loading time from eight hours down to 20 minutes, saving a whole day of work for the staff checking and refining the data. The presentation also includes some reflections on how partitioning the table has changed how both T-SQL and Entity Framework code is being written, to take advantage of partition elimination.
Speaker(s):
- Magnus Ahlkvist
Track and Room: Application Database Development - Room3
Title: ADF Data Flows: Build scalable, cloud-based ETL without code
Abstract:
- SSIS gave you a graphical user interface for building your Extract, Transform and Load processes hosted in SQL Server
- Azure Data Factory v1 gave you a UI for more scalable Extracting and Loading of data, but the Transformation plug-in was left up to you
- Azure Data Factory v2 gave you more control over how your processes were triggered and the path through your steps (like the Control Flow in SSIS)
- Now coming to ADF is Mapping Data Flows, a UI for building in Transformations into your ETLs, still taking full advantage of scalability in the cloud
Speaker(s):
- Daire Cunningham
Track and Room: Azure / Cloud - Room1
Title: Lightning Talks
Abstract: Short (5-10 mins.) talks on a variety of technical topics.
All welcome - feel free to turn up and speak on the day!
Speaker(s):
- Mark Hayes
Track and Room: Azure / Cloud - Room3
Title: Database Adventure
Abstract: Aimed mostly at administration and based on real life scenarios, in this 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 will then select from these options what to do and we will follow that path and see what the outcome is from there.
Each selection will have a different outcome, and along the way you will probably learn some new things.
Speaker(s):
- Kevin Chant
Track and Room: Enterprise Database Administration Deployment - Room3
Title: Secrets of Azure storage and SQL
Abstract: SQL disk configuration and planning can really hurt you if you get it wrong in azure. There is a lot more to getting SQL right on Azure VMs than next-next-next.
Come along and chat to SQL Certified Architect, Bob Duffy, as we dive deeper into azure storage for SQL. Topics covered include:
- SQL storage Capacity Planning concepts
- Understanding Storage Accounts, VM limits, and disk types
- Understanding and planning around throttling.
- Benchmarking
- Optimising SQL configuration to match Azure disk layout:
- Hitting “max” disk throughput
Speaker(s):
- Bob Duffy
Track and Room: Enterprise Database Administration Deployment - Room1
Title: How to win Kaggle competition and get familiar with machine learning ?
Abstract: Have you heard that knowing machine learning is the easiest way to get rich quickly? Let’s test this statement. Kaggle is the place to do data science projects, why not to start there? During this session we will solve simple Kaggle competition. Actually, we will submit two solutions. The first made with super-duper deep neural network (black-box approach). Then we will follow proven ML methodologies and solve the problem methodically. All that using SQL Server Machine Learning Services. Minimum slides and maximum fun guaranteed.
Speaker(s):
- Marcin Szeliga
Track and Room: Advanced Analysis Techniques - Room4
Title: Power BI and PowerShell - A Match Made in Heaven
Abstract: Power BI is the shiny new tech for processing and visualizing data in the Microsoft Data Platform. However, the plumbing in the background does need managing (even if it is cloud-based and supposedly automagic).
In this session we will take a look at how to manage your datasets, security, monitor licensing and more, all through the ultimate administration interface: PowerShell!
You’ll leave the session with an overview of the management capabilities of Power BI and couple that knowledge with the awesome power (and automation possibilities) of PowerShell
Speaker(s):
- Craig Porteous
Track and Room: PowerBI - Room3
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Kaijisse Waaijer
“Kaijisse Waaijer is an experienced technologist, specializing in Data Platforms, Machine learning and IoT. She is an Erasmus University graduate and currently undergoing her Master’s degree in the field of Health Economics with Econometric context at Erasmus University combined with previous attendance at Tilburg University. Kaijisse currently works for Microsoft EMEA as a Data Platform Consultant, specializing in Data Science, Machine learning and Big Data. She constantly works with customers across multiple industries as their trusted tech advisor, helping them optimize their organizational data creating better outcomes and business insights that drives value, using Microsoft technologies.
Shehab El-Najjar
Twitter: - https://twitter.com/MSQLPerformance
LinkedIn: Shehab El-Najjar
Contact: http://sqlserver-performance-tuning.net/
Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts to broadcast Microsoft SQL Server technologies all over the Gulf such as KSA and Emirates and other Gulf cities ahead ..)
He is now Professional Services Manager at Saudi Emircom
He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years
He is an influencing Database community leader all over the region A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region
Craig Porteous
Twitter: - https://twitter.com/CPorteous
LinkedIn: Craig Porteous
Contact: https://craigporteous.com
Craig is a Data Platform MVP working with Incremental Group as a Data Engineer. He has more than 10 years working with the Microsoft Data Platform and related technologies, supporting global BI Environments, automating processes with PowerShell and implementing BI Solutions. Craig is actively involved in the SQL community as a co-leader of the Glasgow SQL User group creator of the DATA:Scotland Conference in Scotland.
Mark Hayes
Twitter: - MarkDataGuy
LinkedIn: Mark Hayes
Mark Hayes (Certified Business Intelligence Professional (CBIP), MPP - Data Science, MPP - Big Data) is a freelance Microsoft Data Platform consultant and has worked with Microsoft data technologies since 2000 with a wide range of national and international companies. He is a regular speaker on Microsoft Data Platform topics and co-leader of the Cork SQL User Group and the Cork SQLSaturday.
Dan Galavan
Twitter: - @dangalavan
LinkedIn: Dan Galavan
Contact: https://galavan.com/blog/
Dan has been working with databases for 20 years. He has delivered data platform solutions in Ireland and Germany in a variety of industries including Retail, Corporate and Investment Banking, Aerospace, CRM, Social Protection, Telecoms, and Health Product Regulation. Specializes in database design development, data migration, analytics, master data management, enterprise data warehousing, data solution architecture, and the data life-cycle in general. Regular contributor to SQL Server User Group community. Data Vault 2.0 certified practitioner. Member of the Munich Colmcilles European Gaelic Football League winning team…a long time ago!
Vitor Fava
Twitter: - sqlservermaniacs
LinkedIn: Vitor Fava
Contact: https://www.vitorfava.com
I’m a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation, and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I’m a speaker at various technology events such as SQLSaturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I’m the Chapter Leader of SQLManiacs PASS chapter.
Peter Willmot
Peter has been writing software (and teaching folk how to write software) for over 30 years. He has worked with SQL Server as an architect and developer for more than 20 years (since SQL 4.2) and has also worked extensively with the .Net and various other development platforms.
Peter is a past MSDN Regional Director and was also an MVP (SQL Server and Architecture) for many years. He is a passionate and regular speaker and various industry events around the world.
Magnus Ahlkvist
Twitter: - @Transmokopter
LinkedIn: Magnus Ahlkvist
Contact: http://www.tsql.nu
Independent database consultant and certified trainer with a passion for chasing that extra millisecond. 20 years of database development and administration but trying to be humble enough to understand that I’m still learning.
Daire Cunningham
LinkedIn: Daire Cunningham
Daire Cunningham is the Business Intelligence Practice Lead in Spanish Point Technologies, an award winning software company working with Microsoft technologies to provide business systems which remove complexity, increase productivity and connect users to critical business information. He has over twenty years’ experience working with Microsoft technologies including working with some of the earliest Microsoft BI products. Recent projects have included analysis and reporting on National Patient Waiting list data for the NTPF and order payment and fulfilment data-processing for eShopWorld
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.
Mary Fealty
Twitter: - https://twitter.com/Br0adtree
LinkedIn: Mary Fealty
Mary Fealty - Power BI Evangelist Mary is an old gamer who replaced her enjoyment of gaming with working with data. That’s how satisfying working with data is to her. She has been a massive fan of Power BI from its infancy to now. She makes her living from Power BI, as owner of Broadtree Solutions. Broadtree Solutions develop business intelligence, consult also provide training on Power BI. Based in Belfast, covering the UK Ireland. She can also be spotted on Game of Thrones, as a Wildling.
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
Douglas McDowell
Twitter: - @douglasmcdowell
LinkedIn: Douglas McDowell
Douglas McDowell is Chief Strategy Officer for SentryOne. He is a 10-year recipient of Microsoft’s MVP award for Data Platform (and SQL Server), has served as a PASS volunteer (Chapter Leader, Regional Mentor, Board member) since 2001 and a member of the Microsoft Partner Advisory Council for Business Data Platform and Business Analytics (DPBA PAC) since 2005. He has lots of degrees and constantly applies his dry, cutting self-deprecating humor to most situations,
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.
Mark Broadbent
Twitter: - @retracement
LinkedIn: Mark Broadbent
Contact: http://tenbulls.co.uk
Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.
Marcin Szeliga
LinkedIn: Marcin Szeliga
Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at user groups meetings. The author of many books and articles devoted to Microsoft Data Platform. An independent consultant, database-centric application practitioner and architect totally focused on SQL Server and Azure. Huge fan of Data Science and Machine Learning.
Rob Sewell
Twitter: - sqldbawithbeard
LinkedIn: Rob Sewell
Contact: http://sqldbawithabeard.com
Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.
He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.
Dmitri Korotkevitch
Twitter: - aboutsqlserver
LinkedIn: Dmitri Korotkevitch
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.
Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
Marcelo Fernandes
Twitter: - marcelodba
LinkedIn: Marcelo Fernandes
Contact: http://marcelodba.wordpress.com
Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba
Angela Ross Innes
Twitter: - https://twitter.com/AngelaRossInnes
LinkedIn: Angela Ross Innes
I’m a SQL Server DBA, previously a SQL Developer with over 13 years experience, currently working for Verizon Connect in Dublin
Mark Hayes
Twitter: - MarkDataGuy
LinkedIn: Mark Hayes
Mark Hayes (Certified Business Intelligence Professional (CBIP), MPP - Data Science, MPP - Big Data) is a freelance Microsoft Data Platform consultant and has worked with Microsoft data technologies since 2000 with a wide range of national and international companies. He is a regular speaker on Microsoft Data Platform topics and co-leader of the Cork SQL User Group and the Cork SQLSaturday.
Brynn Borton
Twitter: - @brynnborton
LinkedIn: Brynn Borton
Brynn is a Azure Data Platform Architect and Principal Consultant with over 20 years’ experience working for various Microsoft gold partners. After initially starting his career building enterprise .NET solutions Brynn decided to focus on building Microsoft data focused solutions around 10 years ago. Brynn consults for Altius Ltd and currently works with a number of clients in the Hospitality and Retail Sector. Being very early adopters in helping clients move their data to the Azure cloud, Brynn has over 5 years hands on experience implementing what we would describe as the Azure Modern Data Platform.
Andrew Pruski
Twitter: - https://twitter.com/DBAFromTheCold
LinkedIn: Andrew Pruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year’s experience. Originally from Wales but now living in Ireland
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Lord Richard Douglas
Twitter: - SQLRich
LinkedIn: Lord Richard Douglas
Contact: http://SQL.RichardDouglas.co.uk
Lord Richard Douglas is a Principal Solutions Engineer at SentryOne, where he specialises in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, having run a PASS Chapter in the UK and having served on the organizing committee for SQLRelay. Richard is on Twitter as @SQLRich.
Geovanny Hernandez
Twitter: - @datawithgeo
LinkedIn: Geovanny Hernandez
Contact: https://geohernandez.net/
Geovanny Hernandez is a Database Engineer and Microsoft Certified Trainer with more than twelve years of experience in software development, passionate for performance tuning in MS SQL Server, Unit Testing and Python.
In addition, Geovanny collaborates with MS SQL Server community as a speaker on different sessions for PASS Malaga (Spain chapter) and virtual events for students and professionals in Universities from Nicaragua (Central America) as well in PASS Marathon and international events as SQLBits and SQLSaturday.
He is passionate about Databases and teaching, who is Microsoft Certified Solution Associate in SQL Server professional and Microsoft Certified Trainer.
Bob Duffy
Twitter: - @bob_duffy
LinkedIn: Bob Duffy
Contact: http://blogs.prodata.ie/author/bob.aspx
Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified.
Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.
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.
Kevin Chant
Twitter: - kevchant
LinkedIn: Kevin Chant
Contact: https://www.KevinRChant.com/
Senior Database Architect originally from the UK and now living in the Netherlands.
Over 23 years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.
In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications. In addition, was probably the last ever person in the world to gain the MCSD Azure Architect certification and has gained the latest Microsoft DevOps Engineer Expert certification.
Has real life experience with SQL Server and Azure Devops. Currently SQL Server Product Owner of around 1,900 instances.
In addition, done various things over the years for the Data Platform Community.
Sponsors
The following is a list of sponsors that helped fund the event: