SQLSaturday #546 - Oporto 2016

Event Date: 10/01/2016 00:00:00

Event Location:

  • ISEP
  • Rua Dr. António Bernardino de Almeida, 431
  • Porto, Porto, Portugal

PDF of Schedule

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).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Unlock the Power of Pivot Tables

Abstract: Your tabular model is done, approved and ready to be used by the user. By means of using Excel the user gets very excited about the use of tabular Models. For a while the user uses Excel as a self-service business intelligence tool. Then all of a sudden the user starts asking if they can use the program to extract more and other information from the tabular model by the use of Excel. Now it is up to you to familiarize the user with all the possibilities of working with the tabular model by means of Excel.

Given the small amount of documented knowledge about the use of tabular models by means of Excel, I will show you how to get the best of your tabular models by using Excel as a self-service business intelligence and data science tool. Filters, named sets, and calculations in the pivot table: I will explain it all!


  • Sander van der hoeff

Track and Room: BI Information Delivery - Auditorium-2

Title: Road to database automation: Database source control

Abstract: Road to database automation addresses the challenges of database inclusion in the Application Lifecycle Management (ALM). The set of processes that enables this inclusion is designated as Database Lifecycle Management. DLM is composed by 3 main parts: data management and migration, data monitoring and data recovery. In this presentation I will discuss the DLM general concepts, with special emphasis on data management and migration, and present some strategies and tools (source control tools as Mercurial and Git and database migrations management tools as Flyway) that can be used to overcome the database source control phase. Using automation as key factor to achieve database source control, database continuous integration and database continuous delivery. This session will not only unlock continuous integration and delivery phases but also enable agile practices that allows to mitigate/manage the gap between application and database development.


  • Eduardo Piairo

Track and Room: Application Database Development - Auditorium-1

Title: An Introduction to Execution Plans and The Query Optimizer

Abstract: One of the most complex areas of SQL Server is the Query Optimizer. It is the component responsible for turning the logical actions (that are derived from your SQL statements) into physical actions that fetch and process the required data to form your results. Not only does it have to guarantee the correct results (no mean feat when you start to think about it) but it has to do this in a performant way and the route it takes to do this (the output of the optimization process ) is described within the execution plan.

This session will be an introduction to the Optimizer and Execution Plans and take you on a journey to a wider view of the Query Engine. Once you understand what physical actions are being taken on your logical requests (i.e. your TSQL Statements) then you will be better placed make changes to influence those actions with an end result of a better performing database system.


  • Dave Ballantyne

Track and Room: Application Database Development - Auditorium-1

Title: Hadoop’s Architecture it’s relation to Microsoft Data Platform

Abstract: Hadoop is the most widely talked data platform in the recent years. Hiding under the term “Big Data”, one of the most disruptive data technology has arrived to the mass market in the recent years, allowing everyone to setup a data solution for everyone. The initial releases of Hadoop have had huge deficiencies in the terms of work, performance and organisation, but the Hadoop 2.0 has brought the needed changes in the underlying architecture and its steadily becoming more and more interesting as a multi-purpose data platform.

Let us review what Hadoop, Spark, Hive, Pig, Tez, Ambari and others are and how can we get started with this data platform. Let us connect each of the pieces with the corresponding element in the current Microsoft Data Platform offerings to understand how can we be more effective in learning and understanding Hadoop.


  • Niko Neugebauer

Track and Room: Strategy and Architecture - Auditorium-3

Title: Fun with SQL Server 2016 Stretch Database, Temporal, and Always Encrypted

Abstract: Your cold data growth is getting out of control, storage consumption is increasing faster than your budget, your end-users won’t (or can’t) tell you what can delete or truncate, but they demand their cold or archived data always be online and available. Now you have tables so big that you dread re-indexing, and you have to look for ever more creative solutions to manage this data, while still remaining compliant. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. Come find out how you can move your data securely and transparently, free up disc space and reduce your enterprise storage consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Server Stretch database will simplify your journey to the Cloud!


  • Scott Klein

Track and Room: Application Database Development - Auditorium-Magno

Title: How to monitor efficiently your SQL Server instances

Abstract: Do you plan to start monitoring your SQL Server instances soon and asking yourself what should you measure? Are you questioning if your existing monitoring data can detect and alert if a performance problem occurs? Is the data you collected from monitoring enough to pinpoint the cause of your next performance problem?

I have worked with SQL Server as a developer in the Redmond team for more than 12 years and during this time I’ve investigated countless performance problems. In time I developed a strategy on how to use the performance monitoring data to analyze problems and identify the root cause. This session is going to to show you how I monitor SQL Server, what data do I look for, and how I interpret the collected data to analyze performance issues. Going beside the obvious CPU, Memory and IO counters, I will show you how to identify typical performance issues from monitoring data, all without overwhelming the captured data volume.


  • Remus Rusanu

Track and Room: Enterprise Database Administration Deployment - Auditorium-Magno

Title: Hiding your data with SQL Server 2016

Abstract: Lately Microsoft has been announcing a series of new features in this huge product that is SQL Server, in this session I will talk about the new developments that were made for security purposes, such as Dynamic Data Masking; Row-level security and Always Encrypted.


  • Ivan Campos

Track and Room: Enterprise Database Administration Deployment - Auditorium-1

Title: Polybase in SQL Server 2016: Let’s query Big Data with T-SQL !

Abstract: Polybase is one of the new features that got released on the new SQL Server 2016 version. It’s a pretty useful technology if you want to access and join both relational and non-relational data, all from within SQL Server. We can run this queries against external data like Hadoop or Azure blob storage with the advantage of the query computation be optimized and managed on our Hadoop cluster. Attend my session if you want to learn how to take advantage of this technology and where we can use it in real life scenarios. I will also cover installation, configuration and troubleshooting.


  • Andre Batista

Track and Room: Application Database Development - Auditorium-3

Title: Docker Containers and SQL Server coexistence

Abstract: OnPrem or on Azure: how can Docker Containers and SQL Server coexist in developing Enterprise grade solutions. Building some sample scenarios using the power of the new Windows 2016 containers and Azure Container Services.


  • Pedro Sousa

Track and Room: Enterprise Database Administration Deployment - Auditorium-3

Title: Notebooks, notebooks everywhere!

Abstract: The hype is over and scalable systems like Hadoop and Spark are a reality for an ever growing number of companies. Now’s the time to use its capabilities for empowering your Data Science Analytics teams, delivering data products and interactive visualizations. In this session we will talk about a data-driven vision supported by Azure’s cloud features, with emphasis on Jupyter Notebooks.


  • Filipe Coelho

Track and Room: Analytics and Visualization - Auditorium-2

Title: Real-Time Analytics: OLAP OLTP in the mix!

Abstract: In this session we will talk about the Real-Time analytics possibilities with SQL Server 2016. This will be a deep-dive on how this works, and will give you an explanation on the new Columnstore features. We will also talk about the difference between hot warm data.


  • Stijn Wynants

Track and Room: BI Platform Architecture, Development Administration - Auditorium-1

Title: Troubleshooting scenarios with SQL Server availability groups

Abstract: If you are considering to implement an SQL Server AlwaysOn availability group and want to anticipate either some configuration or future operational traps, this session is for you!

We will talk about a range of common and uncommon issues you may face concerning your availability group infrastructures. Then we will explain how to resolve them on the basis of real customer cases.


  • David Barbarin

Track and Room: Enterprise Database Administration Deployment - Auditorium-Magno

Title: Azure SQL Database - Migrating from On-Premise to Azure

Abstract: As organizations see the benefits of the cloud, you may find yourself involved in migration projects which target the move from on-premises SQL Server to the cloud. Are you ready for this?

In this session, we will compare and contrast different migration strategies. We will cover different ways to migrate your SQL Server database from on-premises to Azure, and how to detect and solve potential migration blockers and issues.


  • Murilo Miranda

Track and Room: Cloud Application Development Deployment - Auditorium-3

Title: First steps with R in the Microsoft Data Platform

Abstract: Do you know you can now use R powerful language thousands of advanced analytics machine learning packages right in SQL Server 2016? Power BI? or in AzureML? AzureML Jupyter notebooks? or even Visual Studio?

Are you a BI Developer? DBA? BI Analyst or a data/analytics lover? Come along, join us in this session as we explore this powerful, sometimes even strange!… language , showing main differences from the typical SQL/BI development. This is a beginner level session to help you with R first steps challenges.


  • Rui Quintino

Track and Room: Advanced Analysis Techniques - Auditorium-2

Title: What’s New in Analysis Services 2016

Abstract: The new release of SQL Server Analysis Services 2016 brings a lot of new features which developers were asking for ages. In this session I will cover the most important improvements, especially in terms of development, maintenance and performance. There is a lot to cover so better be prepared for an intense session!


  • Gerhard Brueckl

Track and Room: BI Platform Architecture, Development Administration - Auditorium-2

Title: Squeezing SQL Server Management Studio

Abstract: SSMS is one of the main tools that help every person, DBA and/or developers, doing their work everyday. I will show to you features that you do not even knew that exist and how they can improve your productivity. Come take a look to SSMS 2016 and understand how it will help you even if you don’t have SQL Server 2016 instances. After this session I hope you have learnt at least one or two features of SSMS.


  • Cláudio Silva

Track and Room: Enterprise Database Administration Deployment - Auditorium-1

Title: Lockless in Seattle: In-Memory OLTP Transaction Processing

Abstract: Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare?

In this session we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.


  • Mark Broadbent

Track and Room: Enterprise Database Administration Deployment - Auditorium-Magno

Title: Integration Services Architecture - (SSIS) Modern Framework

Abstract: Sim existem imensos frameworks SSIS, mas no mundo real temos todos tend#234;ncia a consolidar o conjunto de boas pr#225;ticas que vamos usando nos projectos, que obtivemos via a experi#234;ncia acumulada e o que foi partilhado pela comunidade … por isso nada como pensarmos um pouco sobre o que um framework de integra#231;#227;o moderno dever#225; ter certo ?


  • João Lopes

Track and Room: BI Platform Architecture, Development Administration - Auditorium-2

Title: Super Scaling the LMax Queuing Pattern With SQL Server

Abstract: This session will cover how implement a high performance queue via the LMax queuing pattern with both the legacy row store engine and the in-memory OLTP engine. With the aim of squeezing every last ounce of performance out of the database engine, this session will cover database engine internals at a deep level and make use of stack traces and windows performance tool kit. The session will also cover spin locking and principles which will before other types of exacting OLTP workloads.


  • Christopher Adkin

Track and Room: Enterprise Database Administration Deployment - Auditorium-Magno

Title: What is Windows Nano Servers ?

Abstract: This is one of the existing functionalities of the Windows Server 2016. How does it works ? Come and find out in this session.


  • Ricardo Cabral

Track and Room: Application Database Development - Auditorium-3

Title: Data Visualization through Microsoft platform

Abstract: In this session, I’ll show you how to get the most interesting features and tips from the main Microsoft data visualization tools like SSRS, Excel and Power BI. I’ll show you what you cannot see in the books and help you create Help full reports with real works examples.


  • Pedro Perfeito

Track and Room: BI Information Delivery - Auditorium-2

Title: Moving your SQL Server backups to Azure Blob storage

Abstract: The Cloud has earned its place in many companies topology. This session focusses on performing SQL Server backups directly pushing that backup files to Azure Blob storage and highlights considerations with regards to security and testing these backup files for recoverability, and cloud costs involved.


  • Johan Bijnens

Track and Room: Enterprise Database Administration Deployment - Auditorium-Magno

Title: What is SQL Data Warehouse? Is it for me?

Abstract: Do you know what SQL Data Warehouse is? Will it be the right choice for my solution? How does it work? Is it easy to migrate my solution to it? This and many more questions will not be answered in this session but you will leave with the information to answer yourself those questions and many more.


  • Vitor Pombeiro

Track and Room: Strategy and Architecture - Auditorium-1

Title: Query Store in SQL Server 2016

Abstract: Troubleshooting performance issues is one of the most formidable tasks for a DBA to perform, as well as one of the most defying… The new Query Store feature in SQL Server 2016 is a major enhancement, simplifying both the identification of performance issues and it’s resolution. Throughout a set of 13 demonstrations I’ll explain what Query Store is, how you can take advantage of it and also some alerts you should be aware of. If you’re a performance troubleshooter I’m sure you’ll like this session!


  • Etienne Lopes

Track and Room: Enterprise Database Administration Deployment - Auditorium-Magno


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

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.

Cláudio Silva

Twitter: - https://twitter.com/claudioessilva

LinkedIn: Cláudio Silva

Contact: http://claudioessilva.eu

Cláudio works as SQL Server DBA and he is an former PowerShell MVP who loves to automate any process that needs to be done more than a couple of times. He is an active member on the PowerShell and SQL communities. He contributes to dbatools project (https://dbatools.io) and is always available to help. You can find him on slack and twitter platforms. He also helps on some Portuguese in-person events such as SQLSaturday Lisbon and TugaIT. He is also a regular speaker on these and other events.

Murilo Miranda

Twitter: - murilocmiranda

LinkedIn: Murilo Miranda

Murilo Miranda is a blogger, speaker and SQL Server MVP from Portugal. Nowadays he#39;s a Cloud Operations Engineer at DataStax. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.

David Barbarin

Twitter: - mikedavem

LinkedIn: David Barbarin

Contact: http://www.dbi-services.com/index.php/blog/dbi-bloggers/blogger/listings/dab

David Barbarin is Consultant at dbi services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies and associated topics such as installation, migration, security audits, troubleshooting of performance issues, or high availability architectures etc. David Barbarin is SQL Server MVP (since 2010), Microsoft Certified Master (MCM) for SQL Server, and Microsoft Certified Trainer (MCT).

Dave Ballantyne

Twitter: - @davebally

Dave has been working in the IT field for over 20 years, the past 15 of which has been specialising within SQLServer environment. Tuning and optimizing SQLServer processes is his particular talent but no newbie either when it comes to database development and design. Dave regularly contributes to online forums and is a regular speaker at UK events such as SQL Bits and user groups. He also is founder of the SQL Lunch UK user group

Johan Bijnens

Twitter: - @alzdba

LinkedIn: Johan Bijnens

Johan Bijnens is a database firefighter, involved with SQLserver since 2000, who works at Aperam Genk as member of the Industrial IT support department. Involved in designing architectural solutions based on the Microsoft SQL Server Platform. Performing operational performance and troubleshooting support in co-operation with the dev teams.

Eduardo Piairo

Twitter: - @EdPiairo

LinkedIn: Eduardo Piairo

Contact: http://www.eduardopiairo.com/

Deployment pipeline craftsman always ready to learn new ways to implement Source Control, Continuous Integration and Continuous Delivery for databases, applications and infrastructure.

Database administrator with special interest in database changes and data modeling.

Operations engineer, DevOps Agent with automation, collaboration and communication as priorities.

Pedro Perfeito

Contact: http://www.culto-de-bi.pt

Pedro was born in 1977 in Portugal and currently works as BI Senior Consultant and Invited Lecture in several BI master degrees. He’s also founder and owner of a BI company named “Culto de BI”. He received in 2010, 2011 and 2012 the Microsoft MVP award for all the dedication and contribution helping theoretical and practical issues in the various BI communities. He#39;s also co-author and editor of several books from Packtpub and Syncfusion

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.

Etienne Lopes

Contact: https://sqland.wordpress.com

Etienne Lopes currently works as a SQL Server DBA at Celfinet. Working with SQL Server since 1997, member of sqlport community (www.sqlport.com), regular speaker since 2012 at SQL Server events such as: SQLSaturday and 24 Hours of Pass. Blog: http://sqland.wordpress.com/

Vitor Pombeiro

Twitter: - @creative_byte

LinkedIn: Vitor Pombeiro

Azure SQL DB Support Engineer at Microsoft. Working with SQL Server since version 7.0 and before that with SQL Anywhere. Working in the clouds with SQL Server and Azure SQL DB, DW, MySQL and PostgreSQL.

Pedro Sousa

Twitter: - psousa75

LinkedIn: Pedro Sousa

Contact: http://www.devscope.net

Pedro Sousa lives in Porto, Portugal and he currently works as a Senior IT Operations Analyst at Basecone. Started working with SQL Server at version 6.5 and although DBA is not his primary role, always had a particular interest for it. Nowadays one of his main focus is Microsoft Azure and integration with on-premises networks, working from the copper wire to the Cloud.

Andre Batista

Twitter: - @klunkySQL

LinkedIn: Andre Batista

Contact: http://klunkysql.info/

Andre Batista, with academic path in the course of Electronics, Telecommunications and Computers ( ISEL - Lisbon ) is currently in Crossjoin Solutions working as SQL Server DBA, performing functions on the client PT (Portugal Telecom). He is interested in all areas related to SQL Server and particularly in architecture, implementation, maintenance and performance. He is a member of the Portuguese SQL Server User Group, SQLPort (http://www.sqlport.com) and also one of the founders of TUGA.

Mark Broadbent

Twitter: - @retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK’s SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.

Filipe Coelho

Twitter: - @DataPlumbR

LinkedIn: Filipe Coelho

Filipe Coelho has a PhD in Data Science from FEUP and is a Microsoft Azure Cloud professional. Previously he was Lead Data Scientist at SAPO Labs - Portugal Telecom and Big Data Engineer at Farfetch. He is currently designing Big Data platforms for exploring patterns and developing Machine Learning data products.

João Lopes

Twitter: - https://twitter.com/SQLSniper

LinkedIn: João Lopes

Jo#227;o Lopes is a SQL Server MCP working as BI Consultant with over 10 years of experience, currently a member of the consulting team at BI4ALL delivering data solutions to global clients using Microsoft BI tools.

Stijn Wynants

Twitter: - SQLStijn

LinkedIn: Stijn Wynants

Contact: http://swyssql.wordpress.com

Stijn is a Microsoft Premier Field Engineer on Data AI and a DataMinds core member. He is also one of the organizers of the local user group sessions the yearly event called DataMinds Connect (SQL Server Days). He is a speaker at various international events (SQLSaturday,PASS Summit,Difinity,…). He spends his days tuning SQL Servers solving problems with the full data platform. His focus is primarily on sql server core, but has also done various BI ETL projects. He gets his kicks out of Columnstore indexes tuning queries but shivers at the sight of an SSAS cube.

When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine local beers or enjoying time with his wife and his dog.

Rui Quintino

Twitter: - rquintino

LinkedIn: Rui Quintino

Contact: http://rquintino.wordpress.com

Senior Architect amp; Data Fellow at DevScope. Rui works with Microsoft data related technologies since 1998 and currently leads Data Research amp; Advanced Analytics team at DevScope.

Beyond data techonologies, Rui also has strong background in web, mobile amp; security and he likes to mix all of these to get the most out of Microsoft#39;s Data Platform and make the world a better place through the use of data.

Despite his assumed introversion he loves to learn amp; share his findings with developers, data lovers and microsoft platform communities on local amp; online events.

Ricardo Cabral

Twitter: - rramoscabral

LinkedIn: Ricardo Cabral

Contact: http://blog.en.rramoscabral.com

Ricardo Cabral is a Technical Engineer and also Microsoft Certified Trainer (MCT).

In his free time, he is actively participating, volunteering and/or speaking portuguese community meetings (Azure PT, Arduino Day, Cloud Pro PT, IT Pro Portugal, Netponto, O365PT, PowerShell Portugal, PTJUG, SQLPort, SQLSaturday, Tuga IT, etc.). He is one of the co-founders of IT Pro Portugal and PowerShell Portugal user group.

Ricardo is interested in technology with over 14 years of experience in IT management, development and projects. He is an authentic self-taught man.

Ricardo holds a Degree in Computer Engineering from Universidade Autónoma de Lisboa.

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

Gerhard Brueckl

Twitter: - gbrueckl

LinkedIn: Gerhard Brueckl

Contact: http://blog.gbrueckl.at

Gerhard has been working with Microsoft BI tools since 2006 mainly focusing on Microsoft SQL Server and its components. As a consultant and architect he designed various enterprise BI solutions primary in the German-speaking areas. His personal interest has always been on analytical databases and their capabilities. In 2012 he achieved the SSAS Maestro certification. He is also very active in the community, has its own blog and speaks at conferences all over the world on a regular basis.

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

Remus Rusanu

Twitter: - rusanu

LinkedIn: Remus Rusanu

Contact: http://rusanu.com

Remus Rusanu is a former SQL Server team member. For 12 years he worked on such features as Service Broker, Columnstore Indexes, Query Store and many more. In April 2016 he left Microsoft to found DBHistory.com, a simplified SQL Server monitoring and auditing product.

Ivan Campos

Twitter: - WizardDBA

LinkedIn: Ivan Campos

Contact: http://wizarddba.com/

Ivan Campos is currently a database administrator in 3C Payment a fin-tech in Luxembourg. (3CPayment.com). He is Microsoft Most Valuable Professional, active speaker at local community meetings in Portugal and outside Portugal. He is the leader and one of the founders of the community based in the north of Portugal Porto.Data (www.portodata.net) and the organizer of SQLSaturday in Porto Portugal.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page