SQLSaturday #742 - Cork 2018
Event Date: 06/09/2018 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: T-SQL advanced: Grouping and Windowing
Abstract: This session aims to explore all the features offered by the language T-SQL for aggregating and calculating data. There’s much more of the clause GROUP BY. With grouping and ranking functions you can calculate in your query grandtotal, running totals, find islands in intervals, select the last-not-null value, etc. Windows functions apply directly on a set of rows defined by the OVER clause (“a window”). Windows function do not perform aggregation on group level and do not hide row details. So they allow mixing detail and total elements in the same query. The session is mainly based on a copious array of demos, to make explicit every concept introduced taking into account the impact on performances for every solution.
Speaker(s):
- Andrea Martorana Tusa
Track and Room: Application Database Development - Room4
Title: SSIS Custom Data Flow Components
Abstract: SQL Server Integration Services (SSIS) include several most important components required in data acquisition, transformation, and load operations. If the problem at hand demands a solution that cannot be solved using the built-in components alone, you can resort to the freely extensible Script Component, but when the circumstances also call for a more complex, and more robust solution, that will be deployed to more than one destination server, the more appropriate alternative is to design a Custom Component.In this session you will learn how this can be achieved, what advantages it provides, and how to perform even the most complex data transformations in a standardised and reliable environment.
Speaker(s):
- Matija Lah
Track and Room: BI Platform Architecture, Development Administration - Room2
Title: Administrating SQL Server with PowerShell dbatools
Abstract: Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.
Afraid of PowerShell? Worried its too complicated? Don’t want to go through the learning curve?
Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday
Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session
Speaker(s):
- Rob Sewell
Track and Room: Enterprise Database Administration Deployment - Room1
Title: When Things go Wrong - Error Handling in SQL Server
Abstract: In an ideal world, we would not need any error handling, because there would be no errors. But in the real world we need to have error handling in our stored procedures. Error handling in SQL Server is a most confusing topic, because there are such great inconsistencies. But that does not mean that we as database developers can hide our head in the sand.
This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
Speaker(s):
- Erland Sommarskog
Track and Room: Application Database Development - Room1
Title: Query Folding in Power BI
Abstract: The Query Editor is possibly the most underutilised tool in Power BI Desktop. People are often more fascinated in the pretty visuals and Dashboard reporting, rather than the data transformations that take place before any of this is even possible. The Query Editor enables us to carry out a vast array of data manipulations, but often at a cost. If the transformations are not structured and ordered properly, we can find ourselves watching them complete in what feels like an eternity.
So, how can we speed up data transformations in Power BI and in turn, enhance the capabilities of the Query Editor? The answer is Query Folding. This technique takes the processing strain away from Power BI and the machine you are developing on, instead using the greater capabilities from where the data is sourced.
The 1 hour session will explain Query Folding in more detail, give examples of where/when it can be used and tips of how to get transformations to perform at their best.
Speaker(s):
- Callum Green
Track and Room: BI Information Delivery - Room2
Title: Database version control deployment: model or migration scripts
Abstract: There are fundamentally two ways to source control and deploy your databases. Either you source control the desired state/model and let software work out the upgrade scripts or you source control your upgrade scripts and run them in sequence.
Which is better? Well, that question has a tendency to divide the room.
I’m irritated whenever I go to a “how to do database DevOps” session and the speaker presents just one as “the right way”, perhaps referring to the other as “the wrong way”. Like most things, it depends.
I’ll illustrate the limitations of each approach with a simple scenario. I’ll describe which projects are better suited to a model or a migrations approach. I’ll also discuss whether it’s possible to get the best of both worlds.
Speaker(s):
- Alex Yates
Track and Room: Application Database Development - Room4
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: BI Information Delivery - Room4
Title: Data Science, easy until it’s not
Abstract: Data Science, it really is easier than you think. You’re a DBA or BI Developer? You don’t have time to become an expert in R or Python? You’re sick of these data science sessions that assume everyone knows statistics? Using demo’s in SQL Server 2017 ML Services, I’ll share my experience applying Machine Learning experiments as both a DBA and BI Developer. This way you’ll finally see how easy it can actually be to build and bring a Machine Learning experiment to production. I’ll share good practices you should apply to make your job easier and will guide you through the end to end process using Microsoft’s Team Data Science Process. That way you’ll also have all the practical knowledge you need to do this yourself.
Speaker(s):
- Jan Mulkens
Track and Room: Advanced Analysis Techniques - Room3
Title: Data Storytelling for Business Intelligence with SQL Server 2017
Abstract: SQL Server 2017 extends Business Intelligence tools from previous versions. This is an exciting time for the Business Intelligence Professional, with new tools for the Data Visualization toolbox including R, Python and Power BI. In this session, we will have an overview of these tools and learn ‘what to use, when’ so that you have a blueprint for your Business Intelligence strategy, using SQL Serve 2017 as the supporting technology.
Takeaways:
- SQL Server Reporting Services (SSRS) has been given the love it deserves
- Learn the latest about SSRS and Power BI
- See the new capabilities for SQL Server Analysis Services
- Learn R in SQL Server for the purposes of building intelligent applications to drive action
Join this session to get the inside scoop on SQL Server 2017 from the Business Intelligence perspective.
Speaker(s):
- Jen Stirrup
Track and Room: BI Information Delivery - Room2
Title: Enterprise Data Warehousing - the Data Architectural perspective
Abstract: Not only does Enterprise Data Warehousing success depend on the right technology, the right Data Architecture and supporting processes also need to be in place.
The Data Modelling life cycle necessitates solid foundation stones, from maintained Glossaries Data Dictionaries, to Data Stewardship and Master and Reference Data Management, to ensuring regulatory compliance and Business buy-in of all of the above.
This session will cover:
- End to End EDW delivery from a Data Architectural perspective
- The Data modelling lifecycle, data consolidation and the value of auditing the process
- Business Data Lineage vs. Technical Data Lineage
- How to select the right Data Modelling tool for you
- The pro’s and con’s of off the shelf data models v.s. a blank canvas approach
- Release management
- Regulatory compliance including BCBS 239 and GDPR
- The EDW Methodologies throw down
Speaker(s):
- Dan Galavan
Track and Room: Strategy and Architecture - Room3
Title: Azure Cosmos DB - What you need to know to build globally distributed apps?
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: Cloud Application Development Deployment - Room1
Title: Azure SQL Data Warehouse: One Cog in the Cortana Intelligence Sui
Abstract: Azure SQL Data Warehouse is a massively parallel, cloud-based relational data warehouse-as-a-service (PaaS). In this session you will learn more about what ASDW is and how it scales to handle your enterprise workload. The session also discusses ASDW’s place in the Microsoft’s Intelligence Suite of services including, how the data is loaded in (Azure Data Factory), how we can learn from the data (Machine Learning) and how we can analyse and visualise the data (Power BI)
Speaker(s):
- Daire Cunningham
Track and Room: BI Platform Architecture, Development Administration - Room3
Title: End-to-End Troubleshooting for SQL Server
Abstract: Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.
Speaker(s):
- Kevin Kline
Track and Room: Application Database Development - Room1
Title: Persistence is Futile - Implementing Delayed Durability in SQL Server
Abstract: The concurrency model of most Relational Database Systems are defined by the ACID properties but as they aim for ever increasing transactional throughput, those rules are bent, ignored, or even broken.
In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput. We will take a look at how this can be used to compliment In-Memory OLTP performance, and how it might impact or compromise other things.
Attend this session and you will be assimilated!
Speaker(s):
- Mark Broadbent
Track and Room: Enterprise Database Administration Deployment - Room1
Title: Azure SQL DWH: Tips and Tricks for developers
Abstract: Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can’t use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching and so on. In this session, I’m going to cover several tips and tricks how we can handle with this limitations using available possibilities.
Speaker(s):
- Sergiy Lunyakin
Track and Room: BI Platform Architecture, Development Administration - Room3
Title: Discover the new graph features of SQL Server 2017
Abstract: In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.
Speaker(s):
- Rudi Bruchez
Track and Room: Professional Development - Room2
Title: SQL Server on your favourite operating system….Linux
Abstract: Hopefully you will have heard last year that Microsoft have release their premier database platform on Linux. After you spat your coffee all over your keyboard and then clean up, you must be wondering why?
In this session, I will talk about where and when SQL Server on Linux is a good fit, how it works under the covers ( don’t worry I won’t go into too much deal ) - then we will hit the demos; installing and configuring, but mostly showing it’s just the same great SQL Server we know and love, just not on Windows. I will also show SQL Server in docker container for those of your that love docker.
Speaker(s):
- Mark Pryce-Maher
Track and Room: Enterprise Database Administration Deployment - Room2
Title: Where Should My Data Live (and Why)?
Abstract: Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy.
Speaker(s):
- Matt Gordon
Track and Room: Strategy and Architecture - Room3
Title: Lightning Talks!
Abstract: All welcome! These short (5-10 mins) are a quick and fun way of getting up to speed on various data-related technologies. Email sqlsaturday742@sqlsaturday.com if you have an idea for a talk.
Speaker(s):
- Various Speakers
Track and Room: Advanced Analysis Techniques - Room4
Title: PowerShell - Grow Your Script From Simple to Module
Abstract: With todays features within PowerShell developers are able to create the most advanced functions imaginable.
We’re talking about multiple functions interacting with each other, parameter validation, pipelines, use of the -WhatIf, modules, classes etc.
If you’re someone who wants to learn more to upgrade your current scripts to advanced functions, come to my session. I’ll show you in a couple of easy steps how a simple script can be turned into something beautiful.
Have you written a couple of scripts but want to get them to the next level. Than you’ll want to attend this session and we’ll see how far the rabbit hole goes.
Speaker(s):
- Sander Stad
Track and Room: Application Database Development - Room4
Title: R for Reporting
Abstract: R is actually a really nice, practical language that you can use to do ETL and reporting. You can do it for free and you don’t even need a Coursera course in stats to be able to use it. In this talk, we’re going to look at how we can get started using R for reporting.
We’ll look at building dashboards, from connecting to our database, wrangling our data, to presenting good looking charts back to the user.
Speaker(s):
- Stephanie Locke
Track and Room: Advanced Analysis Techniques - Room1
Title: Chronicles of Power BI
Abstract: In this session Mary Fealty @Br0adtree will take you through her personal review of Power BI by looking back at the many updates there have seen since it’s launch She will give us a walk through of the many updates to Power BI and will demo some of the more recent additions. It’s a fun session that demonstrates the pace at which the Power BI team at Microsoft continue to deliver improvements to an amazing piece of software.
Speaker(s):
- Mary Fealty
Track and Room: BI Information Delivery - Room2
Title: Azure SQL Database - Lessons learned from the trenches
Abstract: In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos
Speaker(s):
- Jose Manuel Jurado Diaz
Track and Room: Application Database Development - Room3
Title: Realizing ROI for Data Projects
Abstract: Data Project should always be aligned and driven by the business. Statistics for failed data projects are discouraging, but you can prevent this in your organization. In this session we cover how to assess and agree on realistic return on investment (ROI) calculations before, during and after a data project in addition to other critical considerations that will assure your data project remains focused on the needs for all stakeholders.
Speaker(s):
- Douglas McDowell
Track and Room: Professional Development - Room2
Title: Partitioning 101
Abstract: Partitioning has been available in SQL Server since 2005 but there can be a lot of misconceptions around it. This session will give attendees a refresher through partitioning concepts and the implementation of those concepts through live demos.
Topics covered will be: - Partitioning definition Partitioning key Indexing considerations Overview of partitioning functions and schemes Table design considerations Splitting and merging partitions Switching data Implementing sliding windows
Speaker(s):
- Andrew Pruski
Track and Room: Enterprise Database Administration Deployment - Room3
Title: Planning and Deploying PowerBI Report Server – On Premise!
Abstract: This session guides you through important considerations for deploying your own Power BI Infrastructure on site. Topic covered are:
- Architecture and Scalability
- Selecting Hardware and Capacity Planning
- Service Account Planning
- Configuring and Testing Kerberos
- Configuring Office online integration
- Licensing
Speaker(s):
- Bob Duffy
Track and Room: BI Platform Architecture, Development Administration - Room1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Erland Sommarskog
Contact: http://www.sommarskog.se
Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
Callum Green
Twitter: - https://twitter.com/CallumGAdatis
LinkedIn: Callum Green
Contact: http://blogs.adatis.co.uk/callumgreen/
Callum is a Senior BI Consultant with Adatis Consulting, passionate about improving presentation layer architecture and finding new ways to exploit traditional warehouse structures. He has worked on many BI projects over a 9 year period, deviating from the typical Microsoft Stack and more into the Azure domain. Callum has written a number of blogs on subjects like Power BI, Power Query and the M programming language.
Mary Fealty
Twitter: - @Br0adtree
LinkedIn: Mary Fealty
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, who provide business intelligence solutions for the insurance sector. Based in Belfast, covering the UK Ireland. She can also be spotted on Game of Thrones, as a Wildling.
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.
Matt Gordon
Twitter: - sqlatspeed
LinkedIn: Matt Gordon
Contact: http://www.sqlatspeed.com
Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He’s an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.
Rudi Bruchez
Twitter: - nepasderanger
LinkedIn: Rudi Bruchez
Contact: http://www.babaluga.com/
(same as before)
Kevin Kline
Twitter: - kekline
LinkedIn: Kevin Kline
Contact: http://blogs.sentryone.com/author/kevinkline
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.
Alex Yates
Twitter: - @alexyates
LinkedIn: Alex Yates
Contact: http://www.workingwithdevs.com
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins.
A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.
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
Matija Lah
Twitter: - @MatijaLah
LinkedIn: Matija Lah
Contact: http://milambda.blogspot.com
Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.
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!
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.
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
Various Speakers
Me
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.
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.
Andrea Martorana Tusa
Twitter: - bruco441
Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category
Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups.
Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).
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).
Jen Stirrup
Twitter: - @jenstirrup
LinkedIn: Jen Stirrup
Contact: http://www.jenstirrup.com
Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.
Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012
Sergiy Lunyakin
Twitter: - slunyakin
LinkedIn: Sergiy Lunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
Sander Stad
Twitter: - @SQLStad
LinkedIn: Sander Stad
Contact: http://www.sqlstad.nl
Sander is a SQL Server DBA with over 15 years of experience in IT. He has worked with SQL Server since version 2000 and is a PowerShell enthusiast.
Stephanie Locke
Twitter: - @stefflocke
LinkedIn: Stephanie Locke
Contact: https://itsalocke.com
Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.
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
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: