SQLSaturday #369 - Lisbon 2015

Event Date: 05/16/2015 00:00:00

Event Location:

Microsoft Portugal
Rua do Fogo de Santelmo, Lote 2.07.02
lisbon, Lisbon, Portugal

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: Tools and Tips: From accidental to efficient Data Warehouse developer

Abstract: You have probably heard about the Accidental DBA, but what about the Accidental Data Warehouse developer? We stumbled into the world of data warehousing, learned dimensional modeling and work with T-SQL and SSIS daily. We’re masters of googling solutions to our problems and make sure our complex ETL processes run without errors. We deliver data to business users… but we don’t deliver data as fast as we want.

You might not be able to rewrite your entire data warehouse or change your team’s processes over night, but there are many things you can do to increase your own productivity and become a more efficient data warehouse developer.

In this session I will show you some of what I’ve learned and discovered that has made me burst out “Oh wow! Why did I not know this yesterday!?” including query improvements, free tools and scripts, SSMS features and even a couple of things I used to think were only useful for those scary DBAs.

Speaker(s):

Cathrine Wilhelmsen

Track and Room: Analytics NonRelational - Analytics NonRelational

Title: Analizing Text with SQL Server 2014 and R

Abstract: Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. Free statistical package / language R is also useful for the text mining tasks. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with the tools mentioned.

Speaker(s):

Dejan Sarka

Track and Room: Business Intelligence - Business Intelligence

Title: Azure Big Data Solution – automation of deployment

Abstract: By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask. Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts This session will show you how : • Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account. • Create a storage account and container for the HDInsight Cluster. • Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly. • The HDInsight cluster is provisioned and configured for access to the sample data. • A partitioned Hive table is created over top of the sample data • Exploration of the result • And how to automate these task either in Powershell or SSIS.

Speaker(s):

Kenneth Nielsen

Track and Room: Hands-On Labs - Hands-On Lab

Title: Triple Trouble - Running a SQL Failover Cluster on a Cluster from a Cluster

Abstract: SQL Server Failover Clustering has traditionally been deployed on physical architecture for a very long time, and is considered by many to be the optimal architectural deployment even today.

Experienced High Availability implementors and pioneers will remember the Microsoft Cluster Hardware Compatibility List with terror and early Virtualization adopters will recoil in disgust at their memories of poorly performing SQL Server VM deployments and will never want to go back there again. Times are changing and with the introduction of Microsoft’s Scalable Shared File Server and improvements to Hyper-V Clustering, High Availability will never be the same again.

In this session we will investigate whether times have really changed for the better and discuss how to implement, administrate and benefits of running a Cluster on a Cluster from a Cluster!

Speaker(s):

Mark Broadbent

Track and Room: Hands-On Labs - Hands-On Lab

Title: Introduction to Microsoft Azure DocumentDB

Abstract: Microsoft Azure DocumentDB service (now in preview) is a NoSQL document database service designed for scalable and high performance modern applications. DocumentDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. DocumentDB is truly schema-free. It allows you to store and query any JSON document, regardless of schema. In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using DocumentDb (using REST API or programming libraries for several popular language) • Basics of DocumentDB Queries

Speaker(s):

Mihail Mateev

Track and Room: Analytics NonRelational - Analytics NonRelational

Title: SQL Server 2014 and Ascending Key Problem in Large Tables

Abstract: The SQL Server Query Optimizer relies on distribution statistics to create the query execution plan. But statistics are almost always out-of-date. For columns with ascending keys the most recent rows don’t exist for statistics objects. And common queries are looking for those rows. This can lead to poorly-performing plans, especially for large tables, where for instance a query that returns a few recent orders for a customer takes several seconds, with a few million logical reads. In this session we’ll show how to identify columns with ascending keys and also query patterns where this problem occurs. Of course we’ll see how to get well performing plans with the queries in SQL Server 2012. According to documentation about new features in SQL Server 2014 the problem seems to be solved in the latest SQL Server version. But is this really so? What is different in SQL Server 2014? Does the problem still occur? As you guess, all those questions will be addressed and answered in this session

Speaker(s):

Miloš Radivojević

Track and Room: F1 - The Performance - F1 - The Performance

Title: Advanced Execution Plan Analysis

Abstract: If you have been working with SQL Server for a while now, you probably already know the basics of reading execution plans. You know what most of the common operators do, at least in outline, and you know some of the things to look out for and correct. Even so, you still encounter plans from time to time that contain mysterious elements, or which just do not make complete sense to you.

There is always more to know about query plans and the execution engine, but this session will help take your query analysis skills on to the next level. We will look at some of the less well-known operators and plan properties, then explore advanced plan sub-tree shapes and the T-SQL constructions they are most often associated with. Becoming familiar with these details will enable you to write T-SQL that targets a more optimal execution plan.

Speaker(s):

Paul White

Track and Room: F1 - The Performance - F1 - The Performance

Title: From Francesinha to Bacalhau: Real-World Database Optimization

Abstract: Do you understand your database’s secret sauce? Does your database deployment favor complexity over simplicity? Which strategy is best?

In this session we will discuss how to take a poorly performing database and substantially improve it’s transactional throughput using lessons learnt from real-world customer deployments and common mistakes found in the field. This session will delve into Indexing does and don’t, transactional consistency and concurrency problems (with resolutions) and SQL Server and database configuration best practices.

Should you prefer Francesinha to Bacalhau? Let’s find out…

Speaker(s):

Mark Broadbent

Track and Room: F1 - The Performance - F1 - The Performance

Title: Exploring the SQL Server Source Code

Abstract: SQL Server is (sadly) not an open source product, so we cannot simply download the source code from microsoft.com to see exactly how it works internally. However, Microsoft do helpfully provide public debugging symbols for every released version (including service packs and cumulative updates).

The public symbols only list module and method names, not every line of code, but the exposed names are sufficiently descriptive that the patient symbols-equipped explorer can gain some useful insights to the way SQL Server works at a very low level of detail.

This demo-heavy session will use the WinDbg debugger from the Debugging Tools for Windows to explore how the SQL Server Query Processor interacts with the Storage Engine to run execution plans. You will see how execution plans run left to right, row-by-row, and see a number of interesting internal details of the complex implementation that lies behind the apparent simplicity of graphical execution plans.

Speaker(s):

Paul White

Track and Room: F1 - The Performance - F1 - The Performance

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

Tillmann Eitelberg

Track and Room: Business Intelligence - Business Intelligence

Title: SQL vNext Business Intelligence

Abstract: Take a snapshot on what is coming to the next version of SQLServer Business Intelligence. In this hour session discover the major enhancements and new capabilities that are already disclosed regarding tools like SQLServer Analysis Services, Integration Services, Reporting Services, Data Warehouse and some recent surprises like DataZen.

Speaker(s):

Bruno Basto

Track and Room: SQL Server 2016 - SQL Server 2016

Title: Drinking from the Azure Data Streams

Abstract: Deriving value from your data can be hard even when the data is stood still. Trying to get insight from your data when it is constantly changing and moving is even more challenging. Being able to derive business value from your data as soon as the data is produced can offer real actionable insight. Imagine being able to action telemetry data coming from machines in your factory or being able to post trades by looking at real time market positions.

This session is going to look at a couple of ways to do real time analysis on your streaming data. We will capture the data, perform analysis on the data and also look at visualizing the data.

Speaker(s):

Allan Mitchell

Track and Room: Agile Cloud - Agile Cloud

Title: AlwaysOn Availability Groups - From Standard to Complex Implementations

Abstract: The main goal of this session is to talk about some of architectures that I’ve been working on and how complex they could be, based on the different requirements that each solution needs.

Speaker(s):

Luís Canastreiro

Track and Room: DBA - DBA

Title: Resource Governor for SQL Server 2014 in Action!

Abstract: Resource Governor enables you to specify limits on the amount of CPU, memory and physical IO (new in SQL Server 2014) that incoming application requests can use. In this session I’ll present Resource Governor and I’ll perform a full demonstration to show how you can use and benefit from this great feature!

Speaker(s):

Etienne Lopes

Track and Room: DBA - DBA

Title: The Amazing Power BI vNext - All about the new version of Power BI!

Abstract: Join us for an exciting session test driving all the new “Power BI-vNext” features. Want to build amazing web based, mobile enabled fully interactive, beautiful dashboards? Query your data get instant insights using QA natural language? Connect to cloud or on-premises data sources? Push your data using the new Power BI APIs to enable real-time Analytics? Learn about the new Power BI Designer tool features use cases? All of these and much more will be covered while also exploring new opportunities most common Power BI integration scenarios for enterprise hybrid setups.

Speaker(s):

Rui Quintino

Track and Room: SQL Server 2016 - SQL Server 2016

Title: Power View – Real World Scenarios

Abstract: On this session you will learn how to create powerfull power view interative reports. You’ll see real world example that use Power View as an amazing way to explore and visualize information.

Speaker(s):

Pedro Perfeito

Track and Room: Business Intelligence - Business Intelligence

Title: Azure Data Factory - The New SSIS?

Abstract: For a long time people have been asking where is SSIS for the cloud. Truth is it was never going to happen. Azure Data Factory has been designed from the ground up. It is designed for moving data at scale and with agility. Come to this session to learn about this new service and how it come provide value to your business processes

Speaker(s):

Allan Mitchell

Track and Room: Agile Cloud - Agile Cloud

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; Always Encrypted.

Speaker(s):

Ivan Campos

Track and Room: SQL Server 2016 - SQL Server 2016

Title: In-Memory OLTP: Three key points to monitor.

Abstract: We hear a lot about in-memory OLTP and its benefits, how to migrate and reach out the best performance. Now it’s time to keep it up and running! As other components on SQL Server, the in-memory OLTP also needs a proper monitoring. We have a range of options to detect possible problems on both memory and disk level. This session will explore few possible scenarios that we need to look into, as well as how to perform the monitoring in the best way.

Speaker(s):

Murilo Miranda

Track and Room: Hands-On Labs - Hands-On Lab

Title: Data Intelligence: Stories of useful data

Abstract: The era of Data Intelligence: from Amazon famous basket analysis to Netflix “House of Cards” series, advanced healthcare analytics or even the quantified self, this session will focus on stories of useful data. All around the world, companies and individuals are using data to drive business decisions and operations, improve customer satisfaction, boost innovation, maximize learning or even predict the future. We will look into these “data stories” and explore common patterns for useful data, including big data, data visualization, data mining and…yes… statistics. :)

Speaker(s):

Rui Quintino

Track and Room: Agile Cloud - Agile Cloud

Title: In-memory OLTP: The faster is now simpler in SQL Server 2016

Abstract: After its debut, in SQL Server 2014, the in-memory OLTP technology, also known as Hekaton, brought a new option to improve that very critical database, something that we were always waiting for. However, some limitations were disencouraging its implementation. Your problems are over! Join this session and discover what SQL Server 2016 is bringing to us, in order to make “The Faster” more “Simpler”.

Speaker(s):

Murilo Miranda

Track and Room: Other - SQL Server 2016

Title: My first data science experiment using Azure Machine Learning

Abstract: You have invested tons into your datawarehouse, only to build static reports in SSRS. That’s sad! After all, a good star schema is the perfect foundation to easy Machine Learning. So let’s do what the analysts say and leverage all that potential synergies, directly into the Cloud! ;) Well, at least, let’s talk about Machine Learning, in words understandable by BI professionals, and check out what Azure ML is all about.

Speaker(s):

Florian Eiden

Track and Room: Analytics NonRelational - Analytics NonRelational

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: DBA - DBA

Title: Agile BI

Abstract: Agile methodologies are widely used in the dev world and are becoming increasingly adopted in the database world. But what about BI? Covering the technology and process sides of enabling agile BI, this session is designed to give you practical tips to get things moving more quickly for you.

Speaker(s):

Stephanie Locke

Track and Room: Agile Cloud - Agile Cloud

Title: Data Management Gateway Deep Dive

Abstract: Deep dive into the DMG and the hybrid architecture involved by Power BI. How does it work ? Security, Firewall, Certificates, Multiple gateways, Admin delegation, Scale out, Disaster Recovery…. All that topics will be covered during that technical session.

Speaker(s):

Jean-Pierre Riehl

Track and Room: Agile Cloud - Agile Cloud

Title: Making customer segmentation using SQL Server SSAS

Abstract: This session will show in practice how to make customer segmentation using SQL Server Analysis services. By using algorithms for segmentation available in Analysis services, we will create segments and statistically test segments (clusters).

Goal of this session is to show how to deploy customer segmentation using data mining in SSAS and what are the practical needs for people working with BI and in Marketing.

Speaker(s):

Tomaž Kaštrun

Track and Room: Analytics NonRelational - Analytics NonRelational

Title: Lightning Talks

Abstract: Vitor Tomaz Vitor Pombeiro Nuno Rafael Gomes Nuno Cegonho Fabiano

Speaker(s):

Global Community

Track and Room: DBA - DBA

Title: Columnstore in SQL Server 2016

Abstract: Operational Analytics In-Memory Analytics are the 2 new amazing options that Microsoft is offering in the upcoming SQL Server 2016. Build up Columnstore Analytics over your existing OLTP Clustered Table with a new updatable Nonclustered Columnstore Index, or use the In-Memory Updatable Nonclustered Columnstore Index over the InMemory OLTP Tables. Discover what features of manageability and monitoring are being added to the SQL Server 2016. This session will be delivering an overview of what is new and how it is going to change the landscape of OLTP OLAP.

Speaker(s):

Niko Neugebauer

Track and Room: SQL Server 2016 - SQL Server 2016

Title: DAX as BI enabler - Excel and SQL options

Abstract: DAX is a powerful tool to get insights form data real quickly. This session describes the scope of Data Analysis Expressions and how to get real value from BI with simple and corporate tools.

Speaker(s):

Bruno Basto

Track and Room: Business Intelligence - Business Intelligence

Title: Python and R for SQL Server and Business Intelligence: Be a data analysis Rock Star!

Abstract: When it comes to analyzing data, Hadoop or the R statistical language come readily to mind. Python is yet another one of your secret power tool for SQL Server, data analysis and business intelligence. In this session, we will look at both Python and R and how they can be used in the Microsoft SQL Server, with a focus on the Business Intelligence stack.

Come to this session to see examples of data analysis using both R and Python, and learn how to use these open source power tools to rock your data world in SQL Server.

Speaker(s):

Jen Stirrup

Track and Room: Analytics NonRelational - Analytics NonRelational

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: Hands-On Labs - Hands-On Lab

Title: SSIS with BIML: Real Life Use Cases

Abstract: We will see how we can use the game changing potential of BIML technology in our SSIS projects with a step-by-step approach that will allow us to adopt BIML in a flexible way. This session will be focused on demos based on real world use cases so everyone can leave the session and start using it right way!

Speaker(s):

João Lopes

Track and Room: Business Intelligence - Business Intelligence

Title: Using Delayed transaction durability in SQL Server 2014

Abstract: One new feature that is present in SQL Server 21014, is called Delayed transaction durability, this feature can be very convenient when our biggest problem is IO, in this session we will see some cases where we can have a high efficiency in the use of this feature, let’s talk about how to enable this feature, how and when to use and when to not use at all, and also we will see how it interacts with the in-memory OLTP technology

Speaker(s):

Ivan Campos

Track and Room: DBA - DBA

Title: Analysis Services: Choosing between Multidimensional and Tabular

Abstract: Since SQL Server 2012, Analysis Services has two different modeling approaches for data analysis: Multidimensional and Tabular. Despite having the same purpose and very similar features between them, you can actually get a lot of benefits by choosing the model that best fits your project requirements. To help you on this big decision, we will compare their features, modeling experience, server requirements, processing and querying performance, and so on, by using a real scenario.

Speaker(s):

Helena Cabral

Track and Room: Analytics NonRelational - Analytics NonRelational

Title: Fraud Detection – Notes From the Field

Abstract: One of the most popular uses of Data Mining is fraud detection. Card issuers, banks, insurances and other financial institutes are always interested to detect frauds in advance, before customers do. In this session, we are going to discuss how to implement a fraud detection solution. You will learn how to prepare data, which algorithms to use, and how to measure results. The session is based on real-life successful projects.

Speaker(s):

Dejan Sarka

Track and Room: Business Intelligence - Business Intelligence

Title: PowerBI for Developers

Abstract: Are you a developer? Want to learn what the next version of PowerBI has for you? Then come to my session …

Speaker(s):

Rui Romano

Track and Room: Hands-On Labs - Hands-On Lab

Title: Query Optimizer internals

Abstract: The query optimizer is at the heart of SQLServer. Without it SQLServer would be a vastly inferior product, queries would have to be manually tuned at each and every turn, and generally speaking, the optimizer protects us from the complexities and mechanics involved.

Much of the optimizer’s internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags to gain further knowledge and insight into how your queries and data are processed to create a plan.

This session will be a deep dive into the optimizers’ internals and not for the feint of heart.

Speaker(s):

Dave Ballantyne

Track and Room: F1 - The Performance - F1 - The Performance

Title: Improved Online Operations in SQL Server 2014

Abstract: Join me on this session to listen about the improvements in SQL Server 2014 on operations that have become possible to be made online, such as “rebuild” a single partition on partitioned objects and priority management on “locks” in DDL operations, for example on “switch partition” operations, reducing the operating time of such maintenance and causing the least possible impact on the normal functioning of our database.

Speaker(s):

Andre Batista

Track and Room: DBA - DBA

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: F1 - The Performance - F1 - The Performance

Title: Query Store So Much More in SQL Server 2016

Abstract: .

Speaker(s):

Andre Batista

Track and Room: SQL Server 2016 - SQL Server 2016

Title: DBA Guide to Extended Events

Abstract: Extended Events is the profiler tool replacement, it is the premium tool for capturing diagnostic information for SQL Server, with advanced capabilities unlike we’ve had available before, using new features can take time to learn

This session is focused to make you Effective with Extended Events, find out how to be up and running with using EE in just minutes not hours or days, join us to take a look what EE can do and discover what’s happening inside your SQL Servers in ways no possible before

Speaker(s):

Neil Hambly

Track and Room: Hands-On Labs - Hands-On Lab

Speakers

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

Mark Broadbent

Twitter: - retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.

Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012

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/

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.

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.

Paul White

Twitter: - @SQL_Kiwi

Contact: http://sqlblog.com/blogs/paul_white/default.aspx

Paul White is an independent SQL Server technical consultant, specializing in performance tuning. He lives in Paraparaumu, New Zealand, and has worked with SQL Server since version 6. Paul writes a highly-regarded SQL Server technical blog and has been a SQL Server MVP since 2011.

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.

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.

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.

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.

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.

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.

Dejan Sarka

Twitter: - DejanSarka

Contact: http://blogs.solidq.com/dsarka/Home.aspx

Global Community

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

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.

Jean-Pierre Riehl

Twitter: - djeepy1

LinkedIn: Jean-Pierre Riehl

Contact: http://blog.djeepy1.net

Architect, Consultant, Trainer and also Manager, Jean-Pierre leads the Data BI Practice at AZEO, a French Microsoft “pure-player” partner. Jean-Pierre is MVP Data Platform since 2008 and speaks at many events in France and in Europe. JP leads the local community (GUSS) and organize events in France since 2011 : MS Cloud Summit, Les Journées SQL Server, SQLSaturday, etc. JP is passionate by data concerns in business like Data Governance, Data Quality or Data Vizualisation and since 2010, he’s specialized in Self-Service BI. His favorite topic is Power BI and business usages and technical architectures that go with.

Mark Broadbent

Twitter: - retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

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.

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.

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.

Helena Cabral

Twitter: - @helenamcabral

LinkedIn: Helena Cabral

Contact: http://blog.bi4all.pt/

Helena Cabral is a BI Senior Consultant at bi4all with over 10 years of experience. Her main activities are related to designing, implementing and maintaining BI solutions based on Microsoft BI-stack for Banking, Insurances and Public Administration areas. Prior to working in BI, she had worked in database modeling and design, application development and data integration services development with several technologies.

Luís Canastreiro

Contact: http://blogs.msdn.com/blogdoezequiel

I’m actually a Senior SQL PFE working in the EMEA region, based in Lisbon (Portugal). I’m working with TIER 1 customers doing SQLRaaS and Performance/Design reviews. Nowadays, I’m the Local SQL PFE Tech lead in terms of the Portuguese SQL PFE team. So, I have the responsibility to manage the list of activities and trainings that must be developed and delivered by the local PFEs here in Portugal and I’m also starting to develop some IP related with SQL for the PFE community.

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.

Florian Eiden

Twitter: - @fleid_bi

LinkedIn: Florian Eiden

Contact: http://fleid.fr

Data Platform Solution Architect for Microsoft in Western Canada

Andre Batista

Twitter: - @klunkySQL

LinkedIn: Andre Batista

Contact: http://klunkysql.info/

Bruno Basto

Bruno Basto, senior consultant #160;and senior trainer #160;at Rumos. SQL certified since 6.5 version (1998). Work with MSFT tools and infrastructure since 1992 in the financial, banking and insurance areas. Responsible for several training projects for software solutions with MSFT infrastructure. Speaker at several MSFT and SQLPass events.

Bruno Basto

Murilo Miranda

Twitter: - murilocmiranda

LinkedIn: Murilo Miranda

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

Tillmann Eitelberg

Twitter: - @_Tillmann

LinkedIn: Tillmann Eitelberg

Contact: http://www.ssis-components.net

Tillmann Eitelberg is CEO and co-founder of oh22information services GmbH, which specializes in data integration and data management. Tillmann is an active blogger at www.ssis-components.net, writing regularly about data quality topics and his passion: spatial data. In addition, he has published several SSIS components on Codeplex and GitHub. Tillmann is a Data Platform MVP, a board member of PASS Germany e.V., a PASS CL for the Cologne/Bonn region, and a PASS RM.

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.

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

Allan Mitchell

Twitter: - @allanSQLIS

Contact: https://onlysearch.wordpress.com/

Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.

Tomaž Kaštrun

Twitter: - @tomaz_tsql

LinkedIn: Tomaž Kaštrun

Contact: http://www.tomaztsql.wordpress.com

Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.

Ivan Campos

Twitter: - WizardDBA

LinkedIn: Ivan Campos

Contact: http://wizarddba.com/

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.

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.

Paul White

Twitter: - @SQL_Kiwi

Contact: http://sqlblog.com/blogs/paul_white/default.aspx

Allan Mitchell

Twitter: - @allanSQLIS

Contact: https://onlysearch.wordpress.com/

Rui Romano

Twitter: - @RuiRomano

LinkedIn: Rui Romano

Contact: http://ruiromanoblog.wordpress.com/

Rui Romano lives in Portugal and he leads the Business Intelligence team at DevScope.

He has been Developing amp; Architecting software solutions since 2003 always focused in the Business Intelligence area.

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.

SQLSaturday #369 - Lisbon 2015

Sessions

Title: Tools and Tips: From accidental to efficient Data Warehouse developer

Title: Analizing Text with SQL Server 2014 and R

Title: Azure Big Data Solution – automation of deployment

Title: Triple Trouble - Running a SQL Failover Cluster on a Cluster from a Cluster

Title: Introduction to Microsoft Azure DocumentDB

Title: SQL Server 2014 and Ascending Key Problem in Large Tables

Title: Advanced Execution Plan Analysis

Title: From Francesinha to Bacalhau: Real-World Database Optimization

Title: Exploring the SQL Server Source Code

Title: From MDS to SSRS - a short walkthrough

Title: SQL vNext Business Intelligence

Title: Drinking from the Azure Data Streams

Title: AlwaysOn Availability Groups - From Standard to Complex Implementations

Title: Resource Governor for SQL Server 2014 in Action!

Title: The Amazing Power BI vNext - All about the new version of Power BI!

Title: Power View – Real World Scenarios

Title: Azure Data Factory - The New SSIS?

Title: Hiding your data with SQL Server 2016

Title: In-Memory OLTP: Three key points to monitor.

Title: Data Intelligence: Stories of useful data

Title: In-memory OLTP: The faster is now simpler in SQL Server 2016

Title: My first data science experiment using Azure Machine Learning

Title: INSERT / UPDATE / DELETE - deep dive

Title: Agile BI

Title: Data Management Gateway Deep Dive

Title: Making customer segmentation using SQL Server SSAS

Title: Lightning Talks

Title: Columnstore in SQL Server 2016

Title: DAX as BI enabler - Excel and SQL options

Title: Python and R for SQL Server and Business Intelligence: Be a data analysis Rock Star!

Title: PowerQuery and M

Title: SSIS with BIML: Real Life Use Cases

Title: Using Delayed transaction durability in SQL Server 2014

Title: Analysis Services: Choosing between Multidimensional and Tabular

Title: Fraud Detection – Notes From the Field

Title: PowerBI for Developers

Title: Query Optimizer internals

Title: Improved Online Operations in SQL Server 2014

Title: SQL Server Batch Mode and CPU Architectures

Title: Query Store So Much More in SQL Server 2016

Title: DBA Guide to Extended Events

Speakers

Sponsors