SQLSaturday #434 - Holland 2015
Event Date: 09/26/2015 00:00:00
Event Location:
- University of Utrecht - Marinus Ruppert Building
- Leuvenlaan 21
- Utrecht, Utrecht, Netherlands
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: SQL Server Power BI Geographic and Temporal Predictions
Abstract: Data science, predictive analytics, insights, statistics… There are so many buzzwords around these days. These words are frequently used in an introduction to some technical article, at the beginning of a presentation, and even in regular talk. However, when it comes down to a real analysis, you typically get reports with very nice Power BI graphs, but without real forecasting. It is up to you to recognize the patterns and then probably make some kind of interpolation by yourself. Data mining is the part that is based on statistics and can really make forecasts automatically. Data mining is part of SSAS installed in multidimensional mode. Is it possible to get the best from both words? This advanced session explains the forecasting algorithms and shows how you can integrate geographic and temporal predictions in Power View and Power Map visualizations and interactive animations. Popular buzzwords finally get some real meat behind them.
Speaker(s):
- Dejan Sarka
Track and Room: Data Science - Zaal D
Title: Become the DBA of the future, everything you need to know about A
Abstract: In the world of Data Platform a variety of solutions are available going from on premises, hybrid to cloud solutions. Database Administrators play a crucial role in application design and architecture, providing mission critical and highly available solutions. In this session you will learn everything a DBA needs to know about Azure. You’ll learn about SQL Server running in Windows Azure virtual machines, Azure Storage and network configurations, SQL Database and how to manage and support workloads running in a traditional, hybrid and cloud based environment. Become the DBA of the future!
Speaker(s):
- Dandy Weyn
Track and Room: Cloud - Zaal 040
Title: Best practices in modelling Power pivot.
Abstract: Power pivot in Excel or SQL server have quite similar in user interfaces. Power pivot in SQL server has a lot more to offer, which you, as Excel user, will like. You prototype in Excel Power pivot, while bearing in mind you want to port your Excel power pivot model to SQL server Power pivot. There are best practices you should stick to in order to port without problems. This session will discuss the advantage and disadvantages of porting your Excel Power pivot model to SQL. After that the best practices in using formula, structuring Power pivot models and even before that how to look at your data will be showed.
Speaker(s):
- Henk Vlootman
Track and Room: Business Intelligence - Zaal 042
Title: Introduction to Azure DocumentDB
Abstract: Azure DocumentDB is a new highly-scalable NoSQL database platform on Microsoft Azure, designed as a fully managed cloud service for modern web and mobile applications. Like other NoSQL platforms, DocumentDB supports schema-free designs, and scales across replicas with fast write performance and eventual consistency. But DocumentDB also offers several unique features that make it a compelling candidate for NoSQL scenarios, which you will learn about in this session. The platform is based on HTTP/REST, embraces JSON as a standard document format, and is supported by a wide range of SDKs for .NET, JavaScript, Java, Python, and Node.js. Without defining any index paths, new documents are queryable within milliseconds, using SQL grammar or LINQ. Learn these and other capabilities, including server-side JavaScript-based stored procedures, user-defined functions, triggers, tunable consistency, and more.
Speaker(s):
- Leonard Lobel
Track and Room: Cloud - Zaal D
Title: Debugging SQL Server
Abstract: When you were young, did you enjoy taking things apart to look at their inner workings? If you did, or still do, this session might be just the thing for you! Combining SQL Server internals with our curiosity on how things work, we will take a look underneath the hood of SQL Server by debugging it.
In this session we will debug the various parts of SQL Server using WinDbg. I’ll show you how to setup, configure and use WinDbg to extract information from a running SQL Server process. We will take a look at the various dump files that record information when a SQL Server crash occurs, capturing valuable information on why SQL Server crashed. And finally, I will demonstrate how you can use Extended Events to create dump files when specific conditions occur, helping you learn more about why they occur.
Don’t worry if you are not a programmer. We will go through this session at a relaxed pace without causing (too many) headaches!
Speaker(s):
- Enrico van de Laar
Track and Room: Database Adminstration - Zaal 2
Title: Now Where Did THAT Estimate Come From? - Part 1
Abstract: NB: This is part one of a two-part session The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there’s nothing you can do about it. Or is there? In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates. Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Speaker(s):
- Hugo Kornelis
Track and Room: Database Development - Zaal A
Title: The dangerous beauty of Bookmark Lookups
Abstract: You know Bookmark Lookups in SQL Server? You like their flexibility to retrieve data? If yes, you have to know that you are dealing with the most dangerous concept in SQL Server! Bookmark Lookups can lead to massive performance losses that blows up your CPU and I/O resources! Join me in this session to get a basic understanding of Bookmark Lookups, and how they are used by SQL Server. After laying out the foundation we will talk in more details about the various performance problems they can introduce. After attending this session you have a better understanding of Bookmark Lookup and you are finally able to tell if a specific Bookmark Lookup is a good or bad one.
Speaker(s):
- Klaus Aschenbrenner
Track and Room: Database Development - Zaal 040
Title: Desigining Complex Tabular Models - A Case Study
Abstract: While building of Tabular Models may be straight forward it rapidly becomes more complex when you steer off-piste and into more complex design pattern such as:
- Many to Many relationships
- Semi-Additive Measures
- Last Ever Non Empty
- Events in Progress
- Versioned Fact Tables
- Almost real time processing requirements
- Huge volume
- Non Star Schema Data Warehouses
- measure explosion and lack of calculated dimensions
- Selecting Hardware
This one hour session will walk through an actual case study of a tabular model and discuss the pain points we encountered on the way, along with solutions and workarounds.
Speaker(s):
- Bob Duffy
Track and Room: Business Intelligence - Zaal 042
Title: Performance Troubleshooting Using DMVs
Abstract: Performance troubleshooting is a complex subject with many factors under consideration when you find poorly performing SQL statements, using proven methodologies, and evaluating performance data available in the Dynamic Management Views and Functions. In this session, we’ll go over a foundation of how and which DMVs to use to identify those problematic statements for versions of SQL Server from 2005 – 2014.
We’ll be demonstrating using practical examples, including code that can be taken away and used on attendees’ own SQL Servers. We’ll also discuss how to identify common causes of performance issues, and learn how to quickly review and understand the wealth of performance data available
Speaker(s):
- Neil Hambly
Track and Room: Database Adminstration - Zaal 040
Title: Flying Through the Clouds–Performance Tuning in Azure
Abstract: So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:
• Optimizing TempDB in an Azure VM • Reducing latency between application VMs and database VMs • Right sizing Azure VMs for performance and cost • Striping I/O across devices in Azure VMs • Performance Tuning in Azure DB
You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.
Speaker(s):
- Joseph D’Antoni
Track and Room: Cloud - Zaal Rood
Title: Azure Machine Learning - drag, drop, predict
Abstract: Microsoft Azure Machine Learning (AML) changes the way we work with data and what knowledge and skills are required in order to predict outcome of future events. AML is a comprehensive “drag, drop, predict” technology with all the benefits of the cloud. The transfer of machine learning to the new platform with ability to use R programming language makes common machine learning tasks very simple for the different customers and academic community.
Speaker(s):
- Tanja Vukov
Track and Room: Data Science - Zaal D
Title: Big Data for the SQL Ninja
Abstract: As more enterprises start implementing big data solutions, how does the DBA support these efforts and do they have the skills and knowledge to integrate big data solutions into your current architecture and processes? This demo-filled session has two purposes; first, to help DBAs understand how to apply their existing SQL Server skills in understanding and utilizing HDInsight and related technologies. Big data technologies don’t need to be intimidating, and this session will help DBAs see how they can easily apply their current skill when working with big data. Second, this session will show how SQL Server and HDInsight be used together to create solutions to solve big data problems without the complexities of massive learning curves and using technologies DBAs are already familiar with. We’ll look at technologies that make working with big data much less daunting, including HiveQL and Sqoop, both of which don’t require a rocket science degree to use.
Speaker(s):
- Scott Klein
Track and Room: Business Intelligence - Zaal D
Title: Introductie van Azure SQL Data Warehouse (MPP in de cloud)
Abstract: SQL DW is wederom een mijlpaal in de geschiedenis van SQL Server voor wat betreft schaalbaarheid: deze Massive Parallel Processing (MPP) SQL Server versie @ Cloud scale biedt de mogelijkheid om binnen een minuut de rekenkracht en in-memory geheugencapaciteit met een factor 60x op te schalen of in z’n geheel te pauzeren wanneer je de database even niet nodig hebt! Tijdens deze presentatie krijg je via een boel live demo’s snel een overzicht van de mogelijkheden van SQL DW inclusief antwoord op vragen als: hoe werkt SQL DW en hoe begin ik hiermee? Hoe migreer ik m’n database naar SQL DW? Hoe kan ik het beste data laden, via BCP of Polybase? En met welke dmv’s kan ik SQLDW het beste monitoren ?
Speaker(s):
- Henk van der Valk
Track and Room: BI Platform Architecture, Development Administration - Zaal Rood
Title: Now Where Did THAT Estimate Come From? - Part 2
Abstract: NB: This is part two of a two-part session The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there’s nothing you can do about it. Or is there? In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates. Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Speaker(s):
- Hugo Kornelis
Track and Room: Database Development - Zaal A
Title: Power BI API
Abstract: With the release of the Power BI Preview, last year, Power BI is now also accessible via an API. Although (at this moment) the API is limited, it provides the basic operations which can be used for real-time dashboarding scenarios. During this session I will show the possibilities of the API and how it can be integrated with other services, like Stream Analytics and AzureML, to provide real time dashboard for realistic IoT scenarios.
Speaker(s):
- Jan Pieter Posthuma
Track and Room: Business Intelligence - Zaal 042
Title: Optimizing SQL Server Performance in a Virtual Environment
Abstract: In this session, we’ll explore some of the things you should be looking at within your virtual environment to ensure that you are getting the best possible performance out of it.
We will discuss how to look for CPU performance issues at the host level. We will also be looking at the Memory Balloon drivers and what they actually do, as well as how you should be configuring them and why.
We will then talk about some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server, and we’ll finish up the session with some storage configuration options.
Speaker(s):
- Denny Cherry
Track and Room: Database Adminstration - Zaal 040
Title: T-SQL : Bad Habits Best Practices
Abstract: Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
Speaker(s):
- Aaron Bertrand
Track and Room: Database Development - Zaal A
Title: Microsoft SQL Server Data Warehouse Fast Track – Understanding th
Abstract: The SQL Server Data Warehouse Fast Track (DWFT) program is designed to provide customers standard and proven system architectures optimized for a range of enterprise data warehousing needs. DWFT is a joint effort between Microsoft and many hardware partners. The goal is to help enterprise customers deploy Data Warehouse solutions with recommended hardware configuration appropriate for the requirements of the workload with reduced risk, cost and complexity.
Speaker(s):
- Niall MacLeod
Track and Room: Business Intelligence - Zaal A
Title: What’s new in SSIS 2016
Abstract: This session is about all the new SSIS features in SQL Server 2016 public preview that was released summer 2016.
Speaker(s):
- Joost van Rossum
Track and Room: SQL Server 2016 - Zaal Rood
Title: Scoped assignments – Threat or salvation? Some real life experiences…
Abstract: Did you ever reach the state in your multidimensional projects when you just didn’t want to implement a new scoped assignment? Will it have any side effects on existing scopes? How about performance? Sometimes your projects get that complex. You will need to choose between many options and it might get hard to even measure the impact or test out all consequences. This session will not answer all your questions, but you will get some real life experiences on what better not to do…
Speaker(s):
- Gabi Münster
Track and Room: Business Intelligence - Zaal 042
Title: An introduction to Data Science
Abstract: Data Science is hot. But what does it take to be a Data Scientist? And how do you get started? This session will give you a brief introduction to Data Science. We’ll explore the steps involved to take on an analytical endeavour, and show how these concepts work with several demos. Attend this session and discover what (Microsoft) tools and technologies you can use to extract value from (big) data! This session will be co-presented by Maarten van Duren.
Speaker(s):
- M Streutker
Track and Room: Data Science - Zaal D
Title: SQL Server 2016 New Feaures (Not Query Store!)
Abstract: SQL Server 2016 New Features (Not Query Store!)
- In-memory OLTP Enhancements
- Native JSON
- Always Encrypted
- Row Level Security
- Dynamic Data Masking
- Enhance Database Caching
- Enhanced Always On
- Power Query for Analytics and Reporting
- Enterprise Grade Analysis Services
- Enhanced MDS
- Enhanced Reporting Services
- Built in Advanced Analytics with R
Speaker(s):
- David Williams
Track and Room: SQL Server 2016 - Zaal Rood
Title: Moving away from SQL Profiler to use Extended Events
Abstract: This session will guide you with practical tips tricks to move away from SQL Profiler and use Extended Events instead. Extended Events were first introduced in SQL Server 2008 and should be used instead of the SQL Profiler. Still lots of DBA’s and DEV’s use SQL Profiler nowadays because of the convenience and lack of an Extended Events GUI in SQL 2008. Extended events however impose a minimal performance penalty on SQL Server and provides much more detailed tracing.
Speaker(s):
- Peter Jonk
Track and Room: SQL Server 2016 - Zaal Rood
Title: SQL Server 2016 Security Innovations
Abstract: Microsoft and the SQL Server team take security very seriously. SQL Server has the lowest number of security vulnerabilities across the major database vendors. To keep this number of vulnerabilities as low as possible, Microsoft introduced several security innovations in SQL Server 2016. In this session you will get an overview of the new security features in SQL Server 2016 like Always Encrypted – Row-Level Security – Dynamic Data Masking - SQL Server audit tools and many more. After attending this session you will have a good idea which new features might be helpful for you, when it comes to security for your mission-critical applications.
Speaker(s):
- Pieter Vanhove
Track and Room: SQL Server 2016 - Zaal 5
Title: SQL Security in the Cloud
Abstract: Our data should be secure. And our environment too. What we can do for maximize security in a hybrid environment, where SQL Server exist in two forms: premise and cloud. How organize our job, how control our data if we use Windows Azure SQL Database - The CLoud Database. Physical security, policy based management, auditing, encryption, federation, access and authorization. All of those subjects will be covered on my session.
Speaker(s):
- Tobias Koprowski
Track and Room: Cloud - Zaal A
Title: Temporal Tables in SQL 2016
Abstract: SQL Server 2016 offers a cool new feature: Temporal Tables. This new functionality allows you to have the system “automagically” record all changes that happen to the data. Querying the data is also much easier than it was before with the workarounds that we had to use. In this hour you will understand the concept, learn how to create temporal tables and how to query them, and what the pros and cons are.
Speaker(s):
- Edgar Walther
Track and Room: SQL Server 2016 - Zaal Rood
Title: Dive into NoSQL with Azure
Abstract: Are you curious about the array of NoSQL technologies available in Azure, but aren’t sure how they differ from each other or the relational models available? Or maybe you’ve got specific data in mind, but aren’t sure which NoSQL technology is best for your application.
Microsoft Azure supports a variety of NoSQL technologies (i.e. key/value, document, column and graph databases). In this session we walk through the options, explaining what each one provides.
Speaker(s):
- Niels Naglé
Track and Room: Data Science - Zaal D
Title: Taming the Beast – How a SQL DBA can keep Kerberos under control
Abstract: The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators. What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works
Speaker(s):
- David Postlethwaite
Track and Room: Database Adminstration - Zaal 040
Title: Boost your analytical superpowers with spatial data
Abstract: Analyzing huge sets of data isn’t something humans are made for. Humans are more suitable for making decisions based on things they can see. So how do you bring that into the business? One of the options you have is to visualize some of your (location based) data on maps. A feature for this in SQL Server is called spatial data (geo data). By using physical locations and shapes to visualize data, you can quickly analyze big sets of data.
In this session, we’re going to take a look at how spatial data works, how you can query it, and how to use it to leverage your decision making process.
Speaker(s):
- Jeffrey Verheul
Track and Room: Data Science - Zaal 4
Title: SQL Server 2014 Memory-optimized Data Exchange
Abstract: SQL Server 2014 introduces Extreme Transaction Processing, a brand new memory-optimized data management feature, targetting OLTP workloads. In this session you will learn about two new, and not very well known, features that you can use to share sets of data between modules - either within the database, or between client applications and databases:
- Memory-optimized Table Variables; and
- Memory-optimized Table-valued Parameters.
Speaker(s):
- Matija Lah
Track and Room: Database Development - Zaal A
Title: Monitoring SQL Server, Key performance metrics and how to interpret them
Abstract: SQL Server has many moving parts with a massive amount of metrics that you can monitor to see how your system is performing, but which ones do you need to pay attention to, what do they mean and how do you interpret them? In this session we will look at the key areas of CPU, Memory and Storage, from performance counters to DMVs that you can use to check on the health of your server and gain insight into how it is performing. We will also look at some of the configuration options that exist which you can use to ensure that you have a healthy base on which to build.
Speaker(s):
- John Martin
Track and Room: Database Adminstration - Zaal 040
Title: Agile BI from the cloud with Team Foundation Services
Abstract: Agile BI promises to deliver value much quicker to its end users. But how do you keep track of versions and prioritize all the demands users have?
With Visual Studio Online (cloud version of Team Foundation Server) it is possible to start for free with 5 users, with Version Control, Work Item management and much more.
In my session you will get the directions to a quick start with Visual Studio Online. You will learn the possibilities of Version Control and in which way to implement Scrum work item management with all available tools.
Speaker(s):
- Sander van der hoeff
Track and Room: Business Intelligence - Zaal 042
Title: Datazen – Microsoft’s shiny dashboard-tool
Abstract: To compete with other vendors supplying mobile BI dashboarding solutions, Datazen has entered the SQL Server BI stack. In this session we will discover what it has to offer and what kind of effort is needed for publishing your very own dashboards. We will go through local dashboards on Excel and evolve to a basic server setup with your dashboards published to mobile devices and SharePoint. Let us guide you on your way to the future of mobile BI.
Speaker(s):
- Jan Van humbeek
Track and Room: Business Intelligence - Zaal 042
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
David Postlethwaite
Twitter: - @postledm
LinkedIn: David Postlethwaite
Contact: http://www.gethynellis.com/
David Postlethwaite has been a DBA for Liverpool Victoria in Bournemouth, England since 2008 He supports both Oracle and SQL Server from 2000 to 2017, DBMS, SSIS, SSAS and Reporting Services. In 2015 David built and deployed the company’s first cloud solution using Microsoft Azure SQL Database and web services
Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator.
He is an occasional blogger on www.gethynellis.com
David is a regular speaker for SQLSaturday. Most of his presentations can be found on his YouTube channel www.youtube.com/c/DavidPostlethwaiteSQL
Sander van der hoeff
Twitter: - shoeff
LinkedIn: Sander van der hoeff
Contact: http://www.du-sabot.nl
With over 20 years of experience in automation Sander van der Hoeff knows his way around in the ICT business. Since 2000 Sander is Specialized in business intelligence and data warehousing using the full SQLServer Stack. In 2012 Sander founded his own BI-company: Du Sabot. Nowadays Sander spends his time on several BI- and DWH-projects as an independent professional. Sander combines deep technical knowledge with the capability to explain difficult BI- and DWH-concepts to the non-technical people
Dandy Weyn
Twitter: - ILIKESQL
LinkedIn: Dandy Weyn
Contact: http://WWW.ILIKESQL.COM
With over 20 years of experience in the database world, Dandy Weyn is very experienced on database platforms and business intelligence. As content developer for hands-on-labs, owner of technical events, and multiple years as international consultant and trainer Dandy offers the unique combination of deep technical and solid presentation skills. He is an MCM for SQL Server, Microsoft Certified Trainer and Global Technical Lead for Data Platform in the Enterprise Partner Group (EPG) at Microsoft.
Henk Vlootman
Twitter: - Henk4Excel
LinkedIn: Henk Vlootman
Contact: http://www.vlootman.nl
Henk Vlootman is trainer in Excel and Power pivot to managers throughout the world in the Dutch or English language since 1992. I also do assignments from the industry, partly consultancy and partly direct modelling. I do seminars and congresses. With Michiel Rozema (Rubicon, The Netherlands, I wrote the quot;Practice Book PowerPivot in Excel.quot; At this moment, again with Michiel Rozema I’m finishing a new Power pivot book. I write a monthly blog on Power BI for two different Dutch (financial) e-magazine. I’m manager of the LinkedIn group Power BI Gebruikersgroep. Henk is board member of the Dutch Power BI gebruikersgroep.
Jeffrey Verheul
Twitter: - @devjef
LinkedIn: Jeffrey Verheul
Contact: http://devjef.wordpress.com/
Jeffrey Verheul is a DBA and database developer from the Netherlands, with over 8 years experience in the Microsoft stack. After a short side-track as a software engineer, he returned to his true love: SQL Server. His main focus is on database development, performance tuning and database administration. He is a member of the Friends of Red Gate and the Professional Association for SQL Server (PASS), and blogs regularly on devjef.wordpress.com.
Tobias Koprowski
Twitter: - @KoprowskiT
LinkedIn: Tobias Koprowski
Contact: http://koprowskit.eu/geek/
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.
Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.
Traveler. Coffee Addicted.
Leonard Lobel
Twitter: - @lennilobel
LinkedIn: Leonard Lobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.
Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.
Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
Jan Van humbeek
Twitter: - janvanhumbeek
LinkedIn: Jan Van humbeek
Jan Van humbeek is a Microsoft BI consultant working for Micropole Belgium. Over the years, he’s gathered experience with all the core BI components the SQL Server stack has to offer. This led him to becoming fully MCSE certified on the SQL Server stack and more recently he achieved an MCSA certification in Office 365. When the working day is done, he loves learning about all the latest and greatest features Microsoft has to offer.
John Martin
Twitter: - SQLDiplomat
LinkedIn: John Martin
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.
John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
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.
Aaron Bertrand
Twitter: - @AaronBertrand
Contact: https://blogs.sentryone.com/author/AaronBertrand
Aaron, Product Manager at SentryOne, produces performance and optimization tools for the entire Microsoft data platform, as well as Plan Explorer, a free tool for SQL Server execution plan analysis. In his spare time, he is either playing volleyball, curling, blogging at sqlperformance.com and blogs.sentryone.com, or contributing to SQL Server conversations on Twitter and dba.stackexchange.com. He has worked with SQL Server since 6.5 and has been an MVP since 1997.
Tanja Vukov
LinkedIn: Tanja Vukov
Tanja Vukov, PhD – research associate at Institute for Biological Research, University of Belgrade. She is an expert in biostatistics and her role is to transform data into meaningful scientific conclusions. As a bio-analyst she helped to develop new practices in a field of agriculture and medicine. She published more than 20 papers in leading international scientific journals. She was a speaker on using different Azure technologies. She holds a PhD in Evolutionary biology.
Henk van der Valk
LinkedIn: Henk van der Valk
Contact: http://www.henkvandervalk.com
Since 2000 Henk has specialized in optimizing large-scale Microsoft application and database solutions.
He’s been authoring and contributing numerous whitepapers around SQL Server performance tuning and also produced the famous ETL Data loading World Record with SSIS.
About a year ago, Henk left Microsoft and co-founded a new company: SQLMasters BV and dedicates his time since in developing cool SQL Estate data management solutions and full stack performance tuning.
During his presentations he usually dives into the real-world performance challenges @customer sites and shares tips that will make you job easier!
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.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
Scott Klein
Twitter: - SQLScott
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
Dejan Sarka
Twitter: - DejanSarka
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
Enrico van de Laar
Twitter: - twitter.com/evdlaar
LinkedIn: Enrico van de Laar
Contact: https://www.enricovandelaar.com
Enrico has been working with data in all kinds of formats and sizes for over 15 years. He is a Data Advanced Analytics Consultant for Dataheroes where he helps organisations take their first steps in the world of Advanced Analytics. Enrico is a Data Platform MVP since 2014 and a frequent speaker on various data related events all over the world. He authored the book “Pro SQL Server Wait Statistics” and blogs about technologies like Microsoft SQL Server and Azure Machine Learning on his blog at www.enricovandelaar.com
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”.
Niels Naglé
Twitter: - https://twitter.com/NielsNagle
LinkedIn: Niels Naglé
Contact: http://blogs.infosupport.com/author/nielsn/
Niels Naglé is a Data Solution Architect, Trainer and Speaker at Info Support. As a consultant he specializes in data solutions, business intelligence, data management and Analytics. Niels has consulted for a wide variety of companies in diverse sectors on enterprise business intelligence, Analytics, self-service BI etc. He is passionate about data (and much more) and loves to share his experiences and expertise with like-minded individuals and organizations unlocking their data dividend. Currently working as architect, on designing smart data solutions and frequently delivering training as a Microsoft Certified Trainer.
David Williams
Twitter: - @smooth1x1
LinkedIn: David Williams
Contact: http://justdave.info
David is a cross product DBA (SQL Server, DB2, Oracle, Informix, Sybase) who has worked for 25 years as a DBA for both private, local/central government customers including a Fortune 50 investment bank. Certifications include MCSE 2014 Data Platform, MCTS SQL Server 2008 DBA and Developer as well as certifcations in other products. David has spoken at multiple SQLSaturdays as well as local usergroups and is a regular volunteer at events including SQLBits.
Niall MacLeod
Niall is a Senior Applications Architect for SanDisk, specializing in Microsoft SQL Server and Flash Storage Solutions. Niall has extensive knowledge and experience in utilizing infrastructure resources to deliver application performance. Having began his career in IT in the late 1990s at Data General and EMC, Niall has since worked with several enterprise storage companies; the latter being Fusion-io where he was responsible for the direction of technical marketing in EMEA.
Pieter Vanhove
Twitter: - http://twitter.com/Pieter_Vanhove
LinkedIn: Pieter Vanhove
Contact: http://pietervanhove.azurewebsites.net/
Pieter Vanhove is a Premier Field Engineer at Microsoft Belgium and has been working with SQL Server since 2000. Pieter has a profound knowledge in implementing high availability and disaster recovery solutions and loves the new Azure stuff. Together with the dataMinds team in Belgium, he helps organizing dataMinds Connect and is also a regular speaker at Belgian and international events.
Jan Pieter Posthuma
Twitter: - jppp
LinkedIn: Jan Pieter Posthuma
Contact: https://azurebi.jppp.org
Jan Pieter Posthuma is a certified Microsoft Data Consultant at his own company DataScenarios and has helped multiple clients as the leading (technical) expert in their Microsoft Data challenges. Besides working for customers is Jan Pieter also involved into the Microsoft Data Platform community by co-organizing the yearly Dutch SQLSaturday event and presenting at local and foreign Microsoft Data Platform events. Also he has created several community solution for the Microsoft Data Platform, like Power BI custom visuals and VisualStudio Team Services extensions.
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.
Edgar Walther
Twitter: - @edgarwalther
LinkedIn: Edgar Walther
Contact: http://www.itsmart.eu/Blog/tabid/180/Default.aspx
Edgar Walther has been an independent BI consultant for over 12 years and specializes in the Microsoft Data Platform. He runs a BI consulting firm, ITsmart, based in the Netherlands, and he is one of the founders of the Dutch Power BI User Group. With a background of both Business Economics and IT development the area of Business Intelligence is where he can bridge the gap between Business and IT. He is very eager to stay up to date with the latest developments in Microsoft BI products, and he likes to share them with other BI enthusiasts. He has been a speaker at several SQL Server and Power BI events.
M Streutker
Twitter: - https://twitter.com/mstreutker
LinkedIn: M Streutker
T.b.d.
Peter Jonk
Twitter: - https://twitter.com/dba60k/
LinkedIn: Peter Jonk
Contact: http://dba60k.net
Peter Jonk is a Premier Field Engineer for Microsoft Services and supports customers to get the most out of SQL Server. Areas of expertise include high availability, SQL migrations and performance tuning.
Gabi Münster
Twitter: - @SQLMissSunshine
LinkedIn: Gabi Münster
Gabi Münster is working as a Business Intelligence consultant and team lead and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, and Master Data Services, as well as project management into the community as a regional PASS Local Group lead. She is also passionate about motivating other women to start a technical career and therefore initiates and supports “Women in Technology” events. Apart from SQLSaturdays, she also spoke at SQLBits, SQL Nexus, Tuga IT, and 2015’s and 2017’s PASS Summit. In October 2017 Gabi received her first Data Platform MVP award.
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.
Joost van Rossum
Twitter: - https://twitter.com/ssisjoost
LinkedIn: Joost van Rossum
Contact: http://microsoft-ssis.blogspot.com/
I#39;m a Microsoft Business Intelligence consultant at ilionx with a focus on SQL Server Integration Services (SSIS). I started my career with some ASP, ASP.Net, MCMS and SPS assignments and made the switch to BI when Microsoft released SQL Server 2005. I try to blog at least once a month about SSIS (and related stuff) and try to answer questions on the SSIS forum on MSDN where I#39;m a moderator. And last year I wrote an SSIS Scripting book to show you how to use C# or VB.Net within SSIS.
Klaus Aschenbrenner
Twitter: - @Aschenbrenner
Contact: http://www.SQLpassion.at/blog
Klaus Aschenbrenner provides independent SQL Server consulting services across the United States and Europe, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, he received the Microsoft MVP award for his support of the .NET community. Klaus has also written a book, “Pro SQL Server 2008 Service Broker,” published by Apress (2008).
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Sponsors
The following is a list of sponsors that helped fund the event: