SQLSaturday #413 - Denmark 2015
Event Date: 09/19/2015 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: Power BI – getting it right
Abstract: First we’ll start with an introduction to each of the components of Power BI, you’ll learn about the evolution, how to get access, and how some of the great capabilities are enabled within some of the data visualizations directly in Excel and learn about the differences with the Power BI Desktop. In this part we’ll also discuss Power Pivot, Power View, and Power Map data visualizations, as well as use case scenarios to maximize gaining fast insights into any data. You’ll get an introduction to Dashboard creation using a variety of data sources including content packs. By the end of the session you have anything you need to ingest data from multiple data sources and bring data into quick visualizations, you’ll understand how to create quick dashboards, content packs, and build visualizations on top of streaming data.
Speaker(s):
- Dandy Weyn
Track and Room: BI - Discovery
Title: Excel Services in SharePoint 2013
Abstract: Excel has over the years become a very powerful BI tool and so has Excel Services in SharePoint.
We start with an overview of the new features in Excel Services in SharePoint 2013 and go on with the publish options with focus on the “Items in the workbook” option which is especially handy when you will embed in SharePoint without it resembles Excel too much. Second item on the agenda is the integration in SharePoint with a demonstration of three possibilities: (1) Full page - The lazy solution. (2) PerformancePoint Services Dashboard - The smart solution. (3) WebPart page - The customizable solution.
Last but not least the session will include “Tips Tricks” including how to remove the Excel look. How to control the layout with “Named Items” and the “Name Manager” and how you can burst the limits from PivotTables with the of use “Cube Functions” and “Names Sets”.
Speaker(s):
- Just Blindbaek
Track and Room: SharePoint - Azure
Title: This is how developers might punish your database
Abstract: SQL Server has traditionally been the go-to database for software development teams looking for a way of persisting their data, but the recent NoSQL movement has rendered visible just how limiting the relational model can be - and that may have led people to use other kinds of databases, like key-value stores, document databases, etc.
SQL Server does have some ways of misusing it, though, that you might have missed! In this session we’ll take a look at three alternative ways of using SQL Server, since we’ll see exactly how your favorite RDBMS can be turned into a document database, a reliable message queue, and an event store in a CQRS architecture.
Participants will get an introduction to all the mentioned concepts, and there will be code examples in C#.
Speaker(s):
- Mogens Heller Grabe
Track and Room: DBA - Jupiter
Title: Upgrading from SSIS Package Deployment to Project Deployment
Abstract: Are you still using the package deployment model in your SSIS projects, but want to upgrade to the project deployment model? Are you unsure how to go from using package configurations, configuration files and the SSIS configurations table, to using parameters, environments and the SSISDB catalog?
In this session I will explain the differences between the package deployment model and the project deployment model, and show you step-by-step how you can upgrade your SSIS projects. You will learn how to configure the SSISDB catalog, set up environments and environment variables, work with parameters and monitor your projects.
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: BI - A and B
Title: Intro to R
Abstract: R, a fantastic open-source language, will rock your world.
Instead of showing you how to do dry old statistics and worrying about your random trees and bagging methods, this session is going to take you through the super-cool stuff. No TLAs allowed in this session, only cool terms like shiny LaTeX!
We’re gonna get your data out of SQL Server in just a few lines, then we’re going to chart it for awesomeness, and then the fun begins.
We’ll go through the easy experience of using shiny to make interactive, real-time reports.
I’ll show you how you can add markdown to the mix to replace PowerPoint Word so that you can save yourself months over your lifetime formatting bullet points and headers.
By the end of this session, you’ll truly know your Rs from your elbow.
Speaker(s):
- Stephanie Locke
Track and Room: BI - A and B
Title: End to end risk assessment – affordable solution using Power BI
Abstract: Risk assessment is becoming an integral part of many organizations. In order to do it successfully you need to do it regularly and consistently. You need to register the risk factors, the risks them self, evaluate them and then plan the actions required to mitigate them. Besides the registration you need to have compelling and easy reading reports that help managers quickly find how the assessment is going. The familiar Excel interface helps assessors register the risk factors and risks and then plan the actions. The solutions then uses Power Query to load data into PowerPivot without overwriting and the Power View to report the results. The results can then be monitored in Power BI.
This method can easily transfer to any other data collection solution such as budgeting or incident registration
Speaker(s):
- Asgeir Gunnarsson
Track and Room: Azure - Jupiter
Title: A deep dive into SQL Server Plan Cache Management
Abstract: As an experienced DBA you have probably asked yourself questions like how the memory is consumed, is my system well-tuned, and is my memory configuration well defined. In order to understanding such processes as local and global Memory pressure, caches concurrency, adding and removing plans from cache we will go through the internal organization of the plan cache, the metadata available, how SQL Server finds a plan in cache, plan cache sizing, and the plan eviction policy. We will point out the important cache consumers that affect your workload and how to get metadata about them, what are the thresholds in Cache Size Management. At the end you will understand how to monitor the memory consumers in your SQL Server, what are wait types that we need to look for, how to understand if your system is well-tuned and the memory configuration is well defined. You will have a clear understanding of cache plan problems and how to avoid them.
Speaker(s):
- Margarita Naumova
Track and Room: DBA - Discovery
Title: High Performance Statistical Queries
Abstract: SQL Server Database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient inventive algorithms for the statistical queries. The queries use Window functions, CLR aggregate functions, and other SQL Server capabilities. The session also explains the formulas and usage of those statistical procedures. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.
Speaker(s):
- Dejan Sarka
Track and Room: Dev - Discovery
Title: FILETABLEs: What They Are and How to Use Them
Abstract: Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d
Speaker(s):
- Matija Lah
Track and Room: Dev - A and B
Title: How to create a Windows app with Project Siena, SharePoint and Of
Abstract: Microsoft Project Siena (code name) is the release of a new technology for business experts, business analysts, consultants and other app imagineers. Without any programming, you can create powerful Windows 8/10 apps, with the potential to transform today’s business processes. Combined with SharePoint/SharePoint Online, and Office 365, Project Siena is even more powerful! You can unleash your SharePoint data from the boring List Views and show it off in an app, all without writing any code. This session will introduce you to Project Siena and show you how to use it with SharePoint Online and Office 365 data by building on-the-fly Windows 10 apps. No coding skills required!
Speaker(s):
- Knut Relbe-Moe
Track and Room: SharePoint - Azure
Title: Shadow prediction: SQL 2014 spatial data types and astronomy well mixed
Abstract: In the Wind turbine industry it is often desirable to know where a wind turbine casts its shadow as it can case annoyance to neighbours. This session is supposed to be a more entertaining then practical exercise to combine scarsely used data types in unusual fashion, combined with a bit of astronomy and math, to calculate and visualize the relationship between sun and wind turbine purely by using SQL2014 Management Studio.
The calculation of the daily path of a shadow can be seen as a rather complex three-dimensional problem. By turning around the perspective and ‘painting’ the picture of turbines in the sky this can be decribed as a much simpler two-dimensional problem on a sphere. For this the geography data type will be used and in turn the richness of its functionality demonstrated. Even a sufficient visualisaton is included in SSMS 2014. Apart from 2-3 formulas everything will be handeled in SQL and no complex math is needed.
Speaker(s):
- Arne Bartels
Track and Room: DBA - Showroom
Title: Professional Recycling - SSIS Custom Control Flow Components with Visual Studio Community
Abstract: SQL Server Integration Services (SSIS) are an extensible data-integration platform. If the functionality of stock items do not suffice, the script component is the first point of extensibility. If these custom scripts are used in multiple SSIS packages/projects their handling gets quite cumbersome. For a professional recycling of (script) logic SSIS custom control-flow tasks are an option. With the announcement of Visual Studio Community edition there is no need of a full (and expensive) development environment. This session will cover the required tools, development tips tricks and best practices for Custom ControlFlow development.
Speaker(s):
- Wolfgang Strasser
Track and Room: BI - Jupiter
Title: Azure SQL Database Tips and Tricks for Beginners
Abstract: Microsoft released SQL Azure more than three years ago - that’s enough time for testing. So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually (sic!) restoring data. In this session, you’ll see the differences, functionalies, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012/2014. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
Speaker(s):
- Tobias Koprowski
Track and Room: Azure - Discovery
Title: Introduction to SQL Server high availability solutions
Abstract: This presentation is about the high availability solutions in SQL Server starting w/ SQL 2005 SP1 until the latest versions. It is for decision makers mainly and for those who just started working with SQL Server and interested about the different options. The followings will be covered:
- DBM
- FCI
- AAG
- Log Shipping
- Replications
Presentation will try to show all in cost and feature set point of view along with their pro’s and con’s.
Demos:
- DBM: basic setup + failover + monitoring
- FCI: basic setup + failover
- AAG: basic setup + failover + monitoring
Speaker(s):
- Janos Berke
Track and Room: DBA - Showroom
Title: Configure on-premises SharePoint environment for App/Add-in
Abstract: This session will cover how to setup your on-premises SharePoint environment for App/Add-in. The session will start with some theory and basis understanding of the nuts and bolts for configuring app/add-in for SharePoint. It ends with a “how-to” walkthrough, for a complete setup and deployment of a provider-hosted app.
Speaker(s):
- Anders Dissing
Track and Room: SharePoint - Jupiter
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: BI - Restaurant
Title: ( virtual ) SQL on Steroids
Abstract: I/O performance and operational ease of use are key requirements for SQL Server deployments. While virtualization has delivered operational ease of use it has done so at the expense of I/O performance. This has resulted in excessive database tuning or expensive and disruptive infrastructure changes to alleviate the I/O bottlenecks. Database level In-Memory Computing while promising brings with it a slew of challenges including application rewrites.
What if one could guarantee SQL Server latency would take a vacation as In-Memory performance would be smoking fast without any of the challenges that contemporary approaches incur? In this presentation Frank Brix Pedersen will introduce ‘( virtual ) SQL on Steroids’ as a bullet proof way of providing RAM performance for SQL Server without any side effects, any application rewrites or changes to infrastructure.
Speaker(s):
- Frank Brix Pedersen
Track and Room: Sponsor - A and B
Title: Akademisk Track: Hvordan kan man bruge Big Data i det offentlige
Abstract: Vi lever i en tidsalder, hvor alt digitaliseres og registreres. Den generation, der fødes nu erden første, hvor hele deres liv er registreret. Fra det offentliges sundhedsdata i spædbarnsårene til Facebooks registrering af kærlighedskvaler i teenageårene. Deres liv er digitalt fra vugge til grav.
Det offentlige vil kunne forudsige Big Data områder såsom behov for infrastruktur og børneinstitutioner. Og det vil kunne forudsige Small Data områder såsom hvilken undervisning, der passer bedst til hvert enkelt barn eller hvilken pleje, der passer passer bedst til netop denne patient.
Speaker(s):
- Mikkel Freltoft Krogsholm
Track and Room: DBA - Showroom
Title: In-Memory or Violin Memory - or both?
Abstract: What is an In-Memory database and what impact does it have on requirements for storage IO. Violin Memory technology and why this is almost required if you deploy In-Memory databases. Can Violin Memory be used instead of In-Memory database configurations? Use case combining SQL2014 In-Memory (Hekaton) and Violin Memory storage acceleration.
Speaker(s):
- Jens Melhede
Track and Room: Sponsor - Showroom
Title: Toolkit for DAX Optimization
Abstract: How do you optimize a DAX expression? This session will introduce you to the useful tools to measure performance, gathering data to find the bottlenecks and helping you in writing new optimized versions of DAX. Starting from SQL Profiler, you will learn which events are relevant for DAX, and how to collect them in different environments (Analysis Services, Power Pivot, Power BI). We will show DAX Studio, which simplify and speed-up the data collection process, and makes it easy to find bottlenecks in storage engine and formula engine. The goal of the session is to provide you a methodology to measure performance of your DAX measures, to find the bottleneck and to identify the main reason of a performance issue.
Speaker(s):
- Alberto Ferrari
Track and Room: BI - Discovery
Title: From MDS to SSRS - a short walkthrough
Abstract: MDS makes the administration and maintenance of your master data quite easy and comfortable. But how is the effect on your business interfaces? This session will present demos of how the changes to your master data will effect your cube and reports - and how quick they can be available to your business users.
Speaker(s):
- Gabi Münster
Track and Room: BI - Azure
Title: Blue Sky Thinking: SQL Azure Geospatial Mashup
Abstract: In this session we’ll be integrating a variety of geospatial data sources to provide a scalable website using a Windows Azure SQL Database and it’s built in Geospatial features such as nearest neighbour. Then we’ll take this a step further and introduce another live data stream, finally rendering it all using Bing Maps to an Azure Website. The presentation is targeted at individuals wanting a quick overview of the rapidly evolving Azure Service offerings for today’s cloud ready business.
Speaker(s):
- Thomas Sykes
Track and Room: Azure - A and B
Title: AzureML: Welcome to the future of predictive analytics
Abstract: Predictive analytics is touching more and more lives every day. Machine Learning lets you predict and change the future. Do you know that Microsoft products like Xbox and Bing integrate some machine learning capabilities in their workflows? Come to the session and take a look of the new cloud-based machine learning platform called AzureML from a BI architect perspective, without all the data scientist knowledge. Real machine learning solutions and some best practices when integrating ML on Apps and websites.
Speaker(s):
- Ruben Pertusa Lopez
Track and Room: Azure - Showroom
Title: Introduction to MDX
Abstract: Multi Dimensional eXtension (MDX) query language is still the most prominently used language, used to query Multi Dimensional Cubes. If you are ventouring into the world of MOLAP or taking over projects that contains cubes, this will bring you a basic understanding of the MDX language and hopefully give you a good platform to advance from.
Aspects covered in the session: • Select, From and Where clauses • Sets, Tuples, Members • Period, Hierarchy, String, Math and Filtering functions
Speaker(s):
- Jens Vestergaard
Track and Room: Dev - XBox lounge
Title: SQL Server Security In An Insecure World
Abstract: One of your first responsibilities of a SQL Server DBA is to safeguard the data and protect it from unauthorized access. Over and over we hear about hacker attacks and data leaks: if you don’t want to be the next Sony, you have to take action and activate all the available protection measures. In this session you’ll learn how attackers take advantage of weaknesses in your infrastructure and how to secure it using SQL Server security features and best practices.
Speaker(s):
- Gianluca Sartori
Track and Room: DBA - A and B
Title: PowerQuery and M
Abstract: Getting the right data in the right format is critical for all data analytics. PowerQuery helps you to achieve this. Using the GUI to do this is one thing. To use the tool to its full potential you want to use M, the language behind PowerQuery. In this demo rich session we will start simple by doing some data transformations in the GUI. We will then dive into M to get to the real powerful stuff.
Speaker(s):
- Peter ter Braake
Track and Room: BI - Jupiter
Title: Building a meta-driven near realtime ETL solution with BIML and S
Abstract: This all demo session will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you. Being able to do this and have the system finding the fastest way to load data automatically using system stored procedures enables you to offer near real-time reporting to your users. Topics covered in the session
- BIML SSIS
- MDS
- Near Real-time reporting, what it takes and how to do it.
Speaker(s):
- Rasmus Reinholdt
Track and Room: BI - Restaurant
Title: Securing your SQL Azure Database. How?
Abstract: Do you think that your data is not secured in the cloud? Is that one of the reasons for you to not migrate at least some workloads there? Things changed in the last few months in terms of Azure database security. In this session we will take a closer look at what the features Row Level Security(RLS) and Dynamic Data Masking can do for your business and how they can help you secure your data.
Speaker(s):
- Boris Hristov
Track and Room: Azure - Showroom
Title: Build your own metadata repository with Powershell
Abstract: Love to run Brent’s sp_Blitz and use Ola’s MaintenanceSolution, but you have dozens or even hundreds of servers?
Let’s build a Powershell script together that will use Remoting to run whatever script you like in parallel on any number of servers. We’ll talk about remoting, remoting across domains or even without, how to run scripts in the background and in parallel. I’ll show you how to store the results and report on it across all your servers in one go.
Speaker(s):
- André Kamman
Track and Room: Dev - Restaurant
Title: Introduction to Replication from concepts to a running system!
Abstract: We will be taking you through how to setup replication, what types of options are available to you (snapshot,merge,transaction,peer to peer), how to implement them, an explanation of the various SQL Agent Jobs and Replication binaries involved and what the limitations are. This session will provide you with almost everything you need to know to get started with replication or give you a valuable refresher to the topic if you haven’t done it in a while.
Speaker(s):
- David Williams
Track and Room: DBA - Restaurant
Title: SQL Server Data Warehouse Fast Track – Understanding the Program
Abstract: The SQL Server Data Warehouse Fast Track (DWFT) program is designed to provide customers standard and proven system architectures optimised 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: Sponsor - Discovery
Title: 5 reasons I am excited for IoT and Cortana Analytics
Abstract: Internet of Things (IoT) is now even more practicable with the power of the cloud analytics. Now with Cortana Analytics which have included components across a broad set of Azure Services, Power BI and APIs, you can connect your sensors and devices to the cloud to do more intelligent stuff and “Connect the Dots”. In this session you will get an overview of the capabilities in Cortana Analytics, and Iman will show you an outlook of the future.
Speaker(s):
- Iman Eftekhari
Track and Room: Azure - Jupiter
Title: Datazen - On-premise mobile bi
Abstract: Introducing Microsofts Onpremise Mobile BI solution, Datazen, a leader in mobile business intelligence and data visualization on Windows, iOS and Android devices serving for the on-premise mobile BI.
I want to show you how simply and easy it is to gets started and find data insights that you can use to improve your business. This session will contain a demo of the UI, creation of dashboards, KPIs and a walk-through of the current architecture and security of the software.
Speaker(s):
- Bent Pedersen
Track and Room: BI - Showroom
Title: Putting Your head in the Cloud - Working with SQL Azure
Abstract: You’ve learnt the basics of cloud computing and taken a tour of Microsoft Azure. It’s now time to take a deeper look at using SQL Azure. In this presentation we will have wall to wall demos on creating, configuring, connecting, using, securing, monitoring, uploading, scheduling and syncing your SQL Azure database. By the end of this sessions you will some way to becoming an Azure Jedi
Speaker(s):
- David Postlethwaite
Track and Room: Azure - Azure
Title: Branding SharePoint and Office 365
Abstract: Drive user adoption and get more business value of your investment by branding and customizing smarter and not harder. While for end-users, SharePoint still looks pretty much the same, branding SharePoint on Office 365, the cloud technology, and continuous Microsoft updates require a different approach to branding. I’ll talk about what it takes to apply consistent corporate branding on Office 365, and how to keep up with Office 365 updates that roll out new features and changes in design and navigation.
Speaker(s):
- Sonja Madsen
Track and Room: SharePoint - Azure
Title: Data Quality Improvement through Master Data Driven Business Inte
Abstract: Today’s Business Intelligence systems are increasingly perceived as mission critical, but their value is only as good as the quality of data they contain. How can you improve BI value by ensuring data quality through Microsoft SQL Server Master Data Services, accelerated by Profisee’s Master Data Maestro.
Speaker(s):
- Dave Lawrence
Track and Room: Sponsor - Azure
Title: SQL Server Batch Mode and CPU Architectures
Abstract: This session will explain how modern CPU architectures work, illustrate the nuances of in-memory performance using a simple fact to dimension table join which demonstrates that a larger column store index can outperform a smaller one under certain conditions. How batch mode leverages modern CPUs will be described along with the pressure points batch mode places on the CPU, to help illustrate this tooling will be used which goes to a level deeper than that which anything furnished by Windows or SQL Server can provide.
Speaker(s):
- Christopher Adkin
Track and Room: Azure - Azure
Title: CDC - Change Data Capture in Detail
Abstract: Change data capture records insert, update, and delete activity that is applied to a SQL Server table. This makes the details of the changes available in an easily consumed relational format. Column information and the metadata that is required to apply the changes to a target environment is captured for the modified rows and stored in change tables that mirror the column structure of the tracked source tables.
This session demonstrates the basic concepts, detailed components and implementation strategies of CDC. The demo is based on a real scenario which has been implemented that way!
Speaker(s):
- Uwe Ricken
Track and Room: Dev - Restaurant
Title: From Navision to Power BI Dashboard in 45 minutes
Abstract: In this session I will show you how you can build a Power BI dashboard based on your sales data in your Navision database.
We will travel through the data from Navision on a SQL Server database to the visualization possibilities in Power BI Dashboard using the travel companions - Power Query, Excel Power Pivot , Power BI Designer and will end with Q A on the data.
Join me on an exciting journey through the Power BI tool belt on Navision data.
Speaker(s):
- Erik Svensen
Track and Room: BI - A and B
Title: WTF with SQL
Abstract: SQL is based on the relational algebra, right? Relational algebra is based on set theory, right? So we would expect SQL to kind-of respect common sense from set theory. Like A union A has the same number of elements as A. Well, this is not always the case with SQL.
Come and have fun when we explore scenarios of simple SQL statements, where I guarantee you moments of inner WTF.
Speaker(s):
- Kennie Pontoppidan
Track and Room: Dev - Restaurant
Title: Extracting tables with Ontrack PowerControls
Abstract: Extracting a table from a database backup without having to restore the entire database reduces restore time from hours to minutes or even seconds.
Henrik Andersen from Kroll Ontrack will show you how to restore tables with Ontrack PowerControls from native SQL backups without restoring the entire database – in seconds!
Speaker(s):
- Henrik Andersen
Track and Room: Sponsor - Jupiter
Title: Under Construction - Power BI Development
Abstract: Power BI is the Self-Service BI offering of Microsoft to all Information Workers out there, but hey: Is there anything for the macro geeks and development folks? This session will have a look on anything you can do or should not do with the Power BI offering in the cloud and on your desktop. What’s in it if you want to go beyond the self-service experience? Is there more than create your own cool “M” functions? Let’s see in this session, including PowerShell or the new REST-API.
Speaker(s):
- Oliver Engels
Track and Room: DBA - Discovery
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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”.
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.
Alberto Ferrari
Twitter: - @FerrariAlberto
Contact: http://www.sqlbi.com
Alberto Ferrari started working with SQL Server in 2000 and immediately focused his interest on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence. Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.
Today, Alberto’s main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.
Alberto is a well-known speaker at many international conferences, like PASS Summit, SQLBits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses. Outside of SQLBI, most of Alberto’s personal time is spent practicing video games, in the vain hope of eventually beating his son.
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
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
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.
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.
Jens Melhede
LinkedIn: Jens Melhede
I have worked in the IT industry for just over 23 years. The first 12 years with infrastructure technologies at companies like KMD, Navision, Egmont and Microsoft. Both as Infrastructure Teamlead and specialist. Then 8 years at NetApp as the Nordic Consulting Systems Engineer specialist for Virtualization. Since April 2012 I have worked as the Nordic Systems Engineer for Violin Memory. Specialty areas: Microsoft and Storage Infrastructure, Flash Memory impact on application performance.
Mikkel Freltoft Krogsholm
Mikkel Freltoft Krogsholm er indehaver af 56north, der netop udnytter kombinationen af de store mængder data, der findes nu og de kraftfulde analyseredskaber, der er tilgængelige. Mikkel ved fra personlig erfaring, hvad han taler om.
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.
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.
Knut Relbe-Moe
Twitter: - @shareptkarm
LinkedIn: Knut Relbe-Moe
Contact: http://www.sharepointblog.no
Office 365 MVP, MCT, MCSE SharePoint, MCSA Office 365, SharePoint evangelist, speaker, mentor, Chief Technical Architect, working for Knowledge Factory in Norway. Knuts main focus is advising the clients on how to get the most out of the investment on SharePoint/Office 365, Knut helps his clients on upgrading SharePoint either with upgrade or Migrations. And also he helps with healt checks, and to set up the correct Infrastructure, and optimizing the SQL server database together with SharePoint
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.
Henrik Andersen
Twitter: - https://twitter.com/Ibasdanmark
LinkedIn: Henrik Andersen
Contact: http://blog.ibas.dk/
Henrik Andersen has since 2005 been the Country Manager of Kroll Ontrack Danmark, which is a subsidiary of the Company Kroll Ontrack. Henrik has his background from the world of it, where he amongst other things has worked in sales, marketing and development.
With more than 10 years of data recovery experience, Henrik has worked with many high-profile cases in Denmark.
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).
Frank Brix Pedersen
Twitter: - @frankbrix
LinkedIn: Frank Brix Pedersen
Contact: http://www.vfrank.org/
Frank is Systems Engineer working for PernixData with an extensive experience with SAN, Network, Servers, Operating systems and everything related to the main IT infrastructure. He has been working with virtualization for the past 10 years and has experience ranging from SMB customers to Large Datacenter Deployments. As of 2010-2011-2012-2013-2014-2015 Frank is a designated VMware vExpert for my contribution to the VMware community.
Asgeir Gunnarsson
Twitter: - bidgeir
LinkedIn: Asgeir Gunnarsson
Ásgeir Gunnarsson is a Data Platform MVP and Chief Consultant at Datheos in Denmark. He works on Business Intelligence solutions using the whole of the Microsoft BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI, Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.
Ásgeir speaks regularly at events both domestically and internationally, and is the group leader of the Icelandic PASS Group, as well as the Icelandic Power BI User Group.
Ásgeir is passionate about data and loves solving problems with BI.
Janos Berke
Twitter: - @JanosBerke
LinkedIn: Janos Berke
Contact: http://www.iamberke.com
I am an IT professional with over a decade of technical and management experience. I am using SQL Server since version 6.5. Currently I am a consultant and helping companies in SQL Server design, migrations, operation and developments as well as providing customized training .
Mogens Heller Grabe
Twitter: - mookid8000
LinkedIn: Mogens Heller Grabe
Contact: http://www.d60.dk/om-os/organisation/konsulenter/mogens-heller-grabe/
Mogens is a programmer and architect at d60, a pretty cool software development and BI consultancy in Aarhus, where he#39;s building simple solutions to complex problems, while attempting to reduce the amount of pain that he and his team must endure along the way.
He has an unhealthy interest in building distributed systems in enterprisey environments, which led him to build the free and open-source .NET service bus, Rebus, and the equally free event sourcing and CQRS framework, Cirqus.
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.
Christopher Adkin
Twitter: - ChrisAdkin8
LinkedIn: Christopher Adkin
Contact: http://www.chrisadkin.io
Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.
Dave Lawrence
Contact: http://www.profisee.com
Dave has over 30 years’ experience in providing sales support for data management software vendors, at Profisee he works with customers to build help them unleash the power of Microsoft SQL Master Data Services using Profisee’s Maestro Software. Dave holds a BSc in Mechanical Engineering from the University of Surrey.
Peter ter Braake
Twitter: - @pbraake
LinkedIn: Peter ter Braake
Peter ter Braake, SQL Server MVP, co-founder of the Dutch PASS Chapter and organizer of the Dutch SQLSaturday, teaches SQL Server since 2002. Teaching is for Peter the perfect opportunity to share his SQL Server knowledge and his enthusiasm for the product. Since 2008 he works as an independent contractor giving him the opportunity to use his classroom experience in the real world and use his real world experience in the classroom.
Gianluca Sartori
Twitter: - http://twitter.com/#!/spaghettidba
LinkedIn: Gianluca Sartori
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
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
Ruben Pertusa Lopez
Twitter: - @rpertusa
LinkedIn: Ruben Pertusa Lopez
Contact: http://www.sqlpass.es
Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.
Margarita Naumova
LinkedIn: Margarita Naumova
Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/
Magi Naumova is SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP Data Platform, MCT, Founder of SQL Master Academy, founder and leader of the Bulgarian SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, trains and consults people on SQL Server technology. She runs a Data Platform consulting company part of which is SQL Master Academy training program. It helps hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.
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.
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.
Thomas Sykes
Twitter: - @sqltomato
LinkedIn: Thomas Sykes
Contact: http://sqltomato.com/
Tom is a Senior SQL Server consultant for Quorum Network Resources, a Microsoft Gold Data Platform Partner based in Edinburgh. He is a MCT in addition to being multiple MCSE in Data and Cloud. Current projects include SQL Infrastructure and Performance Tuning, Hybrid Azure SQL Solutions and SQL 2014 migrations.
Sonja Madsen
Twitter: - https://twitter.com/sonjamadsen
LinkedIn: Sonja Madsen
Contact: http://sp2013.blogspot.com
I#39;m SharePoint MVP, and my blog on SharePoint 2013 has well over 1 million hits. I own Sonjasapps with over 20 apps in Microsoft SharePoint App Store. I#39;m both Microsoft Partner and Microsoft vendor.
I started with SharePoint with MA degree in Multimedia and Information Science, and as a .NET developer back in 2004.
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.
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.
Arne Bartels
LinkedIn: Arne Bartels
Master of physic in Germany 2000, worked as MS Flightsimulator Expert on the side. Employed at OLTEC Windamp;Solar as C++/Web/PHP/MySQL -Programmer. Company bought by Vestas 2004 shifting to MS-SQL,SSIS until now.
Iman Eftekhari
LinkedIn: Iman Eftekhari
Contact: http://www.agilebi.com.au
Iman Eftekhari (MCSE BI, MCITP, CSP) has been involved in many successful BI implementations mainly with financial services, health and the public sectors.
He has presented at number of events such as PASS SQLSaturday Sydney, Brisbane, Melbourne, Copenhagen,Sydney BI User Group, SQL Server User Group, etc.
Iman is the co-founder of the Agile BI consulting, co-organiser of the Sydney BI Social group (SYBIS) and Sydney Power BI User Group (PUG).
Bent Pedersen
Twitter: - https://twitter.com/SQLBent
LinkedIn: Bent Pedersen
Contact: http://www.biblog.eu
Bent is a Data Platform MVP and working as Senior Business Analytics Architect at Kapacity A/S, where he have been working with enterprise customers on solutions with SSAS Tabular, SQL Server and in general Azure Data Platform services for the last years. During the past years, he concentrated on working with architecturing, devOps, Automation, testing and simplifying development processes for the Azure Data Platform.
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.
Oliver Engels
Twitter: - @oengels
Contact: http://www.ssis-components.net
Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.
Anders Dissing
my bio
Wolfgang Strasser
Twitter: - wstrasser
LinkedIn: Wolfgang Strasser
Contact: http://workingondata.wordpress.com/
Wolfgang Strasser creates solutions based on the Microsoft Data Platform tools in his day-to-day job as Business Intelligence consultant. Either using SQL Server Database Engine, SSIS, reporting with SSAS and SSRS, implementing Power BI solutions or cloud tools for data analysis - the data-tools-landscape is broadening every day! Based on his professional careers as a software developer he likes to work on structured development processes. Wolfgang shares his knowledge with the community at many national and international events. For his community work, Wolfgang has been awarded with the Microsoft MVP Award for Data Platform in October 2015
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.
André Kamman
Twitter: - @andrekamman
Contact: http://andrekamman.com
André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.
Sponsors
The following is a list of sponsors that helped fund the event: