SQLSaturday #275 - Copenhagen 2014
Event Date: 03/29/2014 00:00:00
Event Location:
- Microsoft Denmark
- Tuborg Boulevard 12
- Hellerup, , Denmark
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: The Irish Economic Crisis, Visualized with Power BI
Abstract: In this session we will explore the Irish Economic Crisis from multiple perspectives, using Microsoft’s latest Visualisation tools including Power BI, Power Query, Power Map, Power View and SharePoint”.
It starts from a very common business angle, where people need to make sense of data, fast, but don’t know what questions to ask, nor how to combine available sources in a way that makes sense.
This session converts the Irish Economic crisis into a story that can be explored in an interactive way, using familiar tools, in a way that people may feel should have been noticed in the run-up to the crisis.
Come by to find out what led to a small country owing over 200 billion euro and if Power BI could have helped.
Speaker(s):
- Carmel Gunn
Track and Room: Harald - N/A
Title: Building Your T-SQL Tool Kit: Window Function Fundamentals
Abstract: Have you pulled a script to identify duplicates from a blog post, but couldn’t quite get it to work, because you weren’t sure what that ROW_NUMBER() function was doing. Maybe you heard talk about creating running totals without using sub-queries, but you got frustrated when the groups weren’t totaling correctly. Or maybe, you’ve never even heard of Window Functions. All are good reasons to attend this all-demo session which demystifies this versatile T-SQL tool. First, we’ll break apart the OVER clause, the key to understanding how window functions work. Then we’ll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we’ll look at real scenarios where this tool works and talk about performance considerations. When you leave, you’ll have the fundamentals you need to fully develop your mastery of Window Functions.
Speaker(s):
- Christina Leo
Track and Room: Harald - N/A
Title: Analyzing I/O Subsystem Performance
Abstract: SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.
Speaker(s):
- Glenn Berry
Track and Room: Gorm - N/A
Title: SQL Server 2014 In-Memory OLTP / XTP Management Deep Dive
Abstract: You have heard about Hekaton, respectively the new Acronym XTP (eXtreme Transactional Processing) and you want to know how it works under the cover? In this session we will take a closer look at the architecture, where the performance benefits come from and how it works in detail. What kind of files is SQL Server using for transactional consistency, what happens when you delete data inside the log and inside the data files. We will see the Merge-Process and the Garbage collector in action, see how memory management works for XTP enabled databases, and thereby get an in-depth understanding of how this completely new storage engine works and how to optimize for it.
Speaker(s):
- Andreas Wolter
Track and Room: Gorm - N/A
Title: Let’s PowerBI Denmark with Big Data!
Abstract: In this fun session, we will use Microsoft’s Big Data and PowerBI tools to learn about Denmark! We will mix and mashup data from a variety of sources such as ‘The Spirit Level’ by Prof Richard Wilkinson, UNICEF, the World Bank and even the CIA to learn more about Denmark. BI and BA professionals need to tackle ever-increasing sources of data that are increasing in volume, velocity and variety. Let’s look at fun example of global data about Denmark to look at common data storytelling by BI and BA professionals: analysing open data with varying degrees of data quality, business puzzles vs business mysteries, and deciding on which chart or graph to use when presenting data. If the ‘too much data, too little information’ scenario is familiar, then come to this session, which isn’t just for the international visitors who come to SQLSaturday Copenhagen every year - like myself! Uncover surprising facts as we mashup, slice and dice the data, and look at Big Data and Data Visualisation
Speaker(s):
- Jen Stirrup
Track and Room: Gorm - N/A
Title: Autogenerating a process data warehouse
Abstract: In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like “What are the typical waiting times in our order process?” are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems.
In this talk I will show you how Rehfeld has overcome this difficult problem using an autogenerated datawarehouse based on metadata on the objects in the EDW/DM layers. In this approach you can autogenerate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos.
Speaker(s):
- Kennie Pontoppidan
Track and Room: Svend - N/A
Title: High Performance Infrastructure for SQL Server 2014
Abstract: Since SQL Server 2012 a paradigm shift is occurring in how SQL Server platforms are designed and built. Come and hear why you no longer will need a SAN to create a high-available SQL Server and why I/O is no longer a problem. In this session I will go into the new storage features in Windows Server 2012 and R2 and how they relate to SQL Server 2012 and how SQL Server 2014 expands on this. Through working with the Core Windows Server team in Redmond during the development of Windows 8.1/R2 I did a lot of work with technologies which have been around for some time, but unavailable to Windows Server installations. We will talk about InfiniBand, Multi-path I/O, RDMA, RoCE, NAND Flash storage, latency and much more. Being in the Data Platforms Advisors group for the SQL Server development team in Redmond, I have worked with completely new concepts of integration between SQL Server and modern hardware, many of these surfacing in SQL Server 2014
Speaker(s):
- Michael Frandsen
Track and Room: Gorm - N/A
Title: Automate your SSIS development with BIML
Abstract: Ever tried to import a file with the Import/Export wizard? Or created a bunch of SSIS packages to process a data warehouse load? Then you know how much work it is to specify the metadata correctly just to create a package that actually works. Wouldn’t it be cool if you had a descriptive language which looks at your metadata and just created the packages for you? This is what BIML is all about. In this session I explain what BIML is, how it works and I’ll show you how you can generate your packages and quickly respond to changes. You can expect a demo rich session with lots of notes from the field and practical examples. This is not just for BI developers, DBA’s or SQL dev’s who need to import or export data occasionally will learn some quick and easy tricks as well.
Speaker(s):
- André Kamman
Track and Room: Harald - N/A
Title: Window Functions Unleashed
Abstract: We have all been in situations where writing a GROUP BY query just didn’t do the job, or aggregation over groups required more work than could be fit into one single SQL statement. For that purpose Window functions have been around since SQL Server 2005. But it is first with SQL Server 2012 that the power of using these functions have been truly released. With the introduction of new functions and optimized performance it is now possible to implement solutions which leverage the strength in the language structure without losing performance in the result. In this demonstration packed session I will introduce the concept of Window Functions, show samples of usages and dive into the workings of the optimizer.
Speaker(s):
- Steen Dybboe
Track and Room: Svend - N/A
Title: Microsoft Master Data Services - Used for more than just data management
Abstract: This session will give you an idea for some alternative uses of Master Data Management.
And how Easy it is to instantiate MDS from SSIS with T-SQL and stored procedures.
Also a short walk through of the tools in MDS from sql server 2012
Speaker(s):
- Kenneth Nielsen
Track and Room: Magnus - N/A
Title: SQL Server 2012 Memory Management
Abstract: SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory. This session will dive into questions related to memory primarily for SQL Server 2012.
Speaker(s):
- Neil Hambly
Track and Room: Knud - N/A
Title: Replay your workload as it’s your actual one!
Abstract: Have you ever wanted to replay your application workload be that because you upgraded to a new hardware, added new indexes or something else? Now there’s a feature for that! It’s called Distributed Replay and in this session you will learn how this new feature in SQL Server 2012 can help you resolve that problem!
Speaker(s):
- Boris Hristov
Track and Room: Magnus - N/A
Title: PowerShell for Data Professionals
Abstract: You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker(s):
- Aaron Nelson
Track and Room: Knud - N/A
Title: Why proper data quality and modelling matters
Abstract: Knowledge about use cases and workload is important input to your data modelling. Different kinds of compression can be relevant depending on your usage scenario. Storing data economically also means that data should be easy to use. Comparison of different compression methods (non lossy, lossy, downsampling for visual presentation).
Speaker(s):
- Bjorn D. Jensen
Track and Room: Magnus - N/A
Title: Overview of a PDW project
Abstract: In this session, you will be introduced to the secret sauce of the PDW - MPP and column-store. You will also learn about some of the differences between a PDW and SQL Server, and be taken through the life-cycle of a PDW project, based on the V1 and V2 projects Mark has worked on
Speaker(s):
- Mark Stacey
Track and Room: Harald - N/A
Title: Unit testing Analysis Services
Abstract: Attend this session to get an overview of two different approaches to automate your testing of Analysis Services cube. The first approach captures snapshot of the cube metadata/structure and a representative sample of values from all measures. With a set of reports it is possible to compare the snapshot and find the differences - ie before and after deployment. The second approach uses the test framework nBI to test result sets, performance, syntax, structure and dimension members.
Speaker(s):
- Just Blindbaek
Track and Room: Knud - N/A
Title: Analysis Services Security
Abstract: Being able to accomodate the most demanding requirements on security is more important now than ever. This session will take you through a variety of approaches on how to implement basic to complex security on dimensions in SSAS. A quick intro through the GUI will bring us to XMLA and AMO as the weapon of choice. Different concepts on hierarchy security models will also be demonstrated.
Speaker(s):
- Jens Vestergaard
Track and Room: Knud - N/A
Title: Dynamic Partitioning Cubes
Abstract: In every project on Business Intelligence there comes a time when the code needs to be deplyed to the production environment. No more development, no more manual work. But what about the partitions on the cube? Do we really need to tell and learn the DBA how to handle that on a periodic plan? The answer is simple: No!
Speaker(s):
- Brian Boenk
Track and Room: Svend - N/A
Title: INSERT / UPDATE / DELETE - deep dive
Abstract: DML is used in most cases without thinking about the multiple operations for the db engine. This session will give a deep dive into the internal storage engine down to record level. After finishing the theory (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated. SEE, what a workload will be caused by a “forwarded record”. What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes
Speaker(s):
- Uwe Ricken
Track and Room: Gorm - N/A
Title: Indexing for denormalization
Abstract: What has the biggest impact on SQL Server overall performance? Hardware, SQL Server configuration or maybe query tuning? No, none of those frequently discussed options. They are important, but the single, most important factor is the database design. A third normal form is great, but sometime a database really should be denormalized to gain a performance boost. This is where indices shine. During this session you will see: how important a proper table design can be, when to use indices on computed columns and why they are way better than triggers, how to create useful indexed views and how to asses their costs and benefits.
Speaker(s):
- Marcin Szeliga
Track and Room: Svend - N/A
Title: SQL Server 2014 - New Cardinality Estimator
Abstract: In SQL Server 2014 query processing has been improved. What we can expect from new cardinality estimator? Does it really estimate better? Will our execution plans be better after migration to 2014? All of them? Is the key ascending column statistics problem solved in new version? Do we finally can have more than 200 steps in the statistics histogram per table? What about column correlation and cardinality estimates - are the predicates still completely independent?
This session will answers all these questions and will demonstrate new query processing capabilities and compare them with those from SQL Server2012.
Speaker(s):
- Miloš Radivojević
Track and Room: Harald - N/A
Title: Prepare your Excel Power Pivot models for QA
Abstract: The new QA function in Power BI will make it possible to ask questions to your Excel Power Pivot models and get a visualization back.
In order to give the best experience for the users of your model you need to prepare it for questions. In this session I will go through how to do this - and will also introduce the natural language syntax and thereby give you an idea of how you can help the user to get the right answer to their questions and the correct visualization as the first answer.
QA will really enable you to rock the way that users interact with data.
Speaker(s):
- Erik Svensen
Track and Room: Harald - N/A
Title: Let’s cook ‘best SQL Server DBA practices’
Abstract: In this session we will go through the topics of performance, scalability and availbility - the 3 core topics that every DBA needs to know. Performance is at the core and required for every database application (small or mission-critical). In this talk we will go through the concepts, tools and procedures that will help you in monitoring and start fine-tuning the performance or find the root-cause on your data platform. The subject covered here is excerpted from my book “Microsoft SQL Server 2008 R2 Administration cookbook”. This will also be an ideal beginning for any IT person who is willing step-into DBA world.
Speaker(s):
- Satya Jayanty
Track and Room: Magnus - N/A
Title: Optimizing DAX Analyzing Query Plans
Abstract: Learn how to optimize DAX measures and queries in this very technical and deep-dive session. Starting from simple performance issues, you will see how to read and understand the query plan of a DAX query. With this information, you will be able to locate bottlenecks in calculation and improve performance by changing DAX expressions, moving the workload from the formula engine to the storage engine and get a complete understanding of the internals of the DAX query engine. A previous knowledge of the xVelocity In-Memory engine and some basics of the DAX Query Engine are suggested in order to follow this session in a more productive way.
Speaker(s):
- Marco Russo
Track and Room: Gorm - N/A
Title: MIgrating to the Azure and the cloud
Abstract: So your CTO wants you to migrate your mission critical database application to the cloud. What’s involved and what are the pitfalls?
In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and then demo performance and scalability impacts.
Speaker(s):
- Bob Duffy
Track and Room: Harald - N/A
Title: Practical use of the SSIS Script components
Abstract: This session will demonstrate some of the functionality of the scripting components in Integration Services based on practical use-cases and real world applications. You’ll see how to parse stange fileformats, how to create your own Data-Driven subscription of Reporting Services among other things.
Speaker(s):
- Mikael Wedham
Track and Room: Svend - N/A
Title: Encryption in SQL Server - things to consider before flipping the switch
Abstract: With an alarming number of high-profile data breaches in the last 12 months, perhaps SQL Server encryption should be a topic to revisit in your data protection strategy. After a brief overview of column-level encryption and TDE, we discuss SQL Server encryption with regard to performance, application-tier and operations.
Speaker(s):
- Hans Hansen
Track and Room: Svend - N/A
Title: Recovering Data from Fatally Corrupt Databases
Abstract: Imagine the worst case scenario: Your database won’t come online. Lots of checksum errors logged. DBCC CheckDB won’t even run on the database. And worst of all - you have no backups! Now what do you do with this 20GB binary blob of an MDF file?
In this demo-rich session I will briefly introduce the internals of MDF files while primarly concentrating on how to manually extract data from corrupt databases. I will be using the OrcaMDF RawDatabase framework to do most of the parsing, which will also be explained during the session.
Speaker(s):
- Mark S. Rasmussen
Track and Room: Gorm - N/A
Title: Advanced Indexing
Abstract: So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you! Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.
Speaker(s):
- Hugo Kornelis
Track and Room: Knud - N/A
Title: Optimizing BI with SQL2014 In-Memory tables
Abstract:
Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can’t optimize our BI solutions with this new feature.
This demo intensiv session is build around a number of hypothesis that are testet and show what we can - and cannot optimize with In-Memeory tables covering both the ETL and (R)OLAP angels of the BI process.
Speaker(s):
- Rasmus Reinholdt
Track and Room: Knud - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Kenneth Nielsen
Twitter: - https://twitter.com/DoktorKermit
LinkedIn: Kenneth Nielsen
Contact: http://funkylab.com
Kenneth M. Nielsen currently work at Microsoft as Data Platform Solution Architect, focusing on data services on Azure. Previously worked as managing consultant and teamlead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large bi installations in Denmark over the last 12 years. He really likes to advice the customers to take the right decisions, but also maintains a high technical knowledge, so he can act at both architect and developer.
Marco Russo
Twitter: - marcorus
LinkedIn: Marco Russo
Contact: https://www.sqlbi.com/blog/marco
Marco is a Business Intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly writes articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and SQLBits. He also enjoys delivering evening sessions at local user groups during his trips.
Mark S. Rasmussen
Twitter: - @improvedk
LinkedIn: Mark S. Rasmussen
Contact: http://improve.dk
Mark S. Rasmussen, a SQL Server MVP, has worked extensively with SQL Server, primarily focused on performance optimization and internals. Besides SQL Server, he is also proficient in the Microsoft .NET development stack, with a decade of experience. Fueled by his interest in the nitty-gritty details, Mark started the OrcaMDF open-source project, which aims to provide a completely standalone parser for SQL Server MDF files. He actively blogs at http://improve.dk and tweets at @improvedk.
Kennie Pontoppidan
Twitter: - @KennieNP
LinkedIn: Kennie Pontoppidan
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Uwe Ricken
Twitter: - https://twitter.com/dbBerater
LinkedIn: Uwe Ricken
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
Hans Hansen
Contact: http://sqlserverdba.dk/
Hans Hansen is a freelance database consultant based in Copenhagen, Denmark and has been working with SQL Server since version 6.5. While his SQL Server focus is on OLTP, core DBA tasks, security and performance tuning his current interests centers around Azure, ‘Internet-of Things’ and complex event processing. Hans offers freelance services at SQLServerDBA.dk and is also a partner at Trustmint.
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
Jen Stirrup
Contact: http://www.jenstirrup.com
Jen is a database strategist, small business owner, SQLFamily and community advocate, public speaker and blogger. Jen was elected Director-At-Large (elect) for the Professional Association of SQL Server, responsible for the EMEA regions plus the Virtual Chapter portfolio. Jen is passionate about all things data and business intelligence, helping leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investments.
Mikael Wedham
Twitter: - @wedham
Contact: http://www.wedham.com
Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.
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.
Steen Dybboe
Steen Dybboe works as a senior BI consultant at Netcompany A/S with focus on designing and implementing Data Warehouses. In the Microsoft Business Intelligence sphere he has a particular interest in designing and developing database solutions and has been working with SQL Server since version 6.5, both as certified developer and instructor. Beside database technology Steen has a wide experience on various programming platforms
Jens Vestergaard
Twitter: - @vestergaardj
LinkedIn: Jens Vestergaard
Contact: http://www.t-sql.dk
Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).
Andreas Wolter
Twitter: - AndreasWolter
LinkedIn: Andreas Wolter
Contact: http://www.andreas-wolter.com/blog/
Andreas Wolter is a Program Manager for SQL Server- and Azure Security at Microsoft. In this role he is working on Security features of SQL Server, Azure SQL Database and Managed Instance. He is currently focusing on “Separation of Duties”-concepts and RBAC-Integration. He has 18 years of experience with SQL Server before joining Microsoft and is the founder of Sarpedon Quality Lab, the Germany-based company specialized on SQL Server HA, Performance and Security. He is Microsoft Certified Master (MCM) for SQL Server and Microsoft Certified Solutions Master for the Data Platform (MCSM) and was recognized as MVP for multiple years in row.
Brian Boenk
Twitter: - @brianbonk
LinkedIn: Brian Boenk
Contact: http://www.bonk.dk
Brian is a BI consultant born in 1979, certified MCSE: BI and MCSE: Data Platform from Denmark with around 10 years experience of BI. His knowledge is broad around the whole spectrum of a BI project. Brians main interest is SSIS and cubes. The few spare hours besides work is being used on a spiritual approach to life and the familiy.
André Kamman
Contact: http://andrekamman.com
André is a freelance SQL Server specialist. In previous roles he’s done a lot of DBA work on 100’s of servers where he discovered his love for Powershell and automating processes in general. Today the better part of his day he’s building and tuning ETL processes. André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Rally Amsterdam and SQLSaturday Holland
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Erik Svensen
Twitter: - @donsvensen
LinkedIn: Erik Svensen
Contact: http://eriksvensen.wordpress.com
Microsoft MVP - Dataplatform Leader of Denmark - Power BI Usergroup
Passionate about Power *, Excel , Analysis Services, Reporting Services.
CTO @CatManSolution - delivering a BI as service solution for suppliers to FMCG Retailers based on the Microsoft BI Stack
Bjorn D. Jensen
Twitter: - @BjornDJensen
LinkedIn: Bjorn D. Jensen
Bjørn Dörr Jensen, Decision Intelligence Specialist, who is developing a system that turns raw sensor data into recommended actions to improve turbine availability and decreasing cost of energy. Working for Vestas Wind Systems A/S with Microsoft SQL Server 2016. Worked as a (PL/)SQL Developer from 2000 - 2006 at TDC, Stibo and IBM. Broad experience with structured query languages. Microsoft Certified Solutions Expert (Data Management and Analytics). M. Sc. in Physics and a Six Sigma Green Belt certification.
Michael Frandsen
Twitter: - @Guru_Frandsen
LinkedIn: Michael Frandsen
Michael Frandsen is an Microsoft MVP on Cloud amp; Datacenter and the lead consultant on areas of technical consulting, performance optimization and migration/consolidation projects, with special focus on storage, scalability and virtualization.
He started with Windows NT 3.1 and SQL Server 4.21a and has been involved in Tech betas and TAP customers ever since.
He has also contributed to best-practices at Microsoft and HP, through working with Microsoft product groups and SQLCAT in Redmond and HP Ramp;D in Palo Alto and Houston
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.
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.
Carmel Gunn
Twitter: - @carmelgunn
LinkedIn: Carmel Gunn
Contact: http://blogs.prodata.ie
Carmel is the Managing Director of the Prodata SQL Centre of Excellence in Dublin, Ireland, where she is a data management specialist, working in the areas of analytics and visualisations.
As a committee member for the SQL Server Ireland User Group, she has played an active roll in bringing 2 SQLSaturdays to Dublin, and is heavily involved in the SQL community.
Glenn Berry
Twitter: - GlennAlanBerry
LinkedIn: Glenn Berry
Contact: https://glennsqlperformance.com/
Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQLSaturdays, and the PASS Community Summit.
Rasmus Reinholdt
Twitter: - @RasmusReinholdt
LinkedIn: Rasmus Reinholdt
Contact: http://rasmusreinholdt.wordpress.com
Rasmus is the Data Warehouse architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards. Rasmus is certified is MSCE SQLServer (Data platform amp; BI), a long time speaker at various SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen and blogs at http://rasmusreinholdt.wordpress.com.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.
Mark Stacey
Twitter: - @MarkGStacey
Contact: http://MarkGStacey.net
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
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
Just Blindbaek
Twitter: - justblindbaek
LinkedIn: Just Blindbaek
Contact: http://blog.justb.dk
Independent BI consultant with extensive experience in all phases of BI development on Microsoft SQL Server, Azure and Power BI. Founder and coordinator of Microsoft Business Intelligence Professionals Denmark (MsBIP.dk) and Power BI UG Denmark (PowerBI.dk). Is a Microsoft Certified Trainer at Orange Man.
Boris Hristov
Twitter: - https://twitter.com/BorisHristov
LinkedIn: Boris Hristov
Contact: http://borishristov.com/blog/
Boris is a SQL Server Consultant, but also an Author for Pluralsight and a SQL Server MVP. He is frequently speaking at conferences all accross Europe and is heavily involved in training students and organizations in what he calls quot;The Art of SQL Serverquot;. Boris is frequently blogging and is the host of SQLHangouts.
Sponsors
The following is a list of sponsors that helped fund the event: