SQLSaturday #341 - Porto 2014

Event Date: 10/18/2014 00:00:00

Event Location:

  • Rua Dr. António Bernardino de Almeida, 431
  • Oporto, , 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: Generate SSIS packages automatically with Biml and BimlScript

Abstract: SSIS is a powerful tool for extracting, transforming and loading data, but creating the actual SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over again. There are no easy ways to handle metadata and schema changes, and if there are new requirements you might have to go through all the packages one more time. It’s time to bring the Don’t Repeat Yourself principle to SSIS development. In this session I will use the free BIDS Helper add-in to show you the basics of Biml and BimlScript, how to generate SSIS packages automatically from databases, how easy those packages can be changed, and how to move common code to separate files that can be included where needed. See why they say Biml allows you to complete in a day what once took more than a week! This session is intended for SSIS developers who are not yet familiar with Biml.


  • Cathrine Wilhelmsen

Track and Room: Business Intelligence - N/A

Title: Deadlocks. Everything that developer needs to know

Abstract: It’s no secret that a deadlock - it’s not very good. This is an exceptional situation, when two concurrent queries request same resources, but in a different order. Classic deadlock can occur when two concurrent transactions modifying data from the two tables in a different order. Unfortunatelly in real life deadlocks can be more complex and unobvious. One of the rules, which I always keep in mind, sounds: “ You can not design a database, in which the occurrence of deadlock is impossible”. So we should deal with them. The algorythm is following: catch, analyze, fix. The most challenging and interesting here is the analysis part. Once you understand why it was occured, you can fix it. In this session we will focus on the analysis of complex,


  • Denis Reznik

Track and Room: Administration/Development - N/A

Title: Optimizing implementation techniques

Abstract: This session describes some performance boosters as well as performance killers and some techniques that can lead T-SQL queries, functions and stored procedures to take a few seconds instead of lots of minutes to execute. For instance: - What is best, CTE’s or Temporary Tables? When? - When joining more than two tables (or intermediate result sets), should we still care about the join order? - Did you ever expect to see an Index Seek in your execution plan but what you find is an Index Scan, although you took care of parameter sniffing and your statistics are updated? - Do you care about what isolation level you use? Using real life based demonstrations, this session will provide answers to these and other questions.


  • Etienne Lopes

Track and Room: Administration/Development - N/A

Title: Enter the Dragon: Running SQL 2014 on Windows Server Core

Abstract: In 1982 the Dragon32 entered the home computer market but unfortunately there was one small problem …lower-case letters were almost impossible to access. Two years later Dragon was no more. In 2008 Microsoft released ServerCore providing a fast and streamlined (but reduced functionality) edition of Windows with minimal GUI support and with Windows 2012/R2 Server Core is “by default”. Ever since SQL 2012, installation onto Server Core became a “supported” option and meant the single biggest administrative shift for a DBA since the release of SQL 2005 …or did it? In this exciting session we will discuss administration, configuration and installation of both SQL 2014 and ServerCore in both standalone and advanced AlwaysOn configurations but will the lack of GUI support send Server Core in the same direction as the Dragon32 or spell a bright new beginning for Server based computing and SQL Server? Join me, and this time, listen to the Dragon roar!


  • Mark Broadbent

Track and Room: Administration/Development - N/A

Title: Web Analytics with Microsoft BI

Abstract: Google Analytics is the most popular web analytics system. Almost every webpage, whether it’s a private blog or large e-commerce site, uses Google Analytics. This session will cover essential information about Google Analytics and its API guidelines, competitors, and most important, how you can use the data from such offerings together with your ERP, CRM, and other OLTP systems.

You will see how to load Google Analytics data using SQL Server Integration Services, for example, and merge that data with your local data. In addition, we will walk through a demonstration of important web analytics KPIs and how you can analyze them using Microsoft Business Intelligence tools.


  • Tillmann Eitelberg

Track and Room: Business Intelligence - N/A

Title: A Tale of four wizards

Abstract: Once upon a time there were four wizards…Two were good and two were evils. Their campground was Excel, Excel Services, SharePoint and the Microsoft BI stack. Their weapon of predilection all started with “Power”. Come and here a tale of good vs evil fought with data mash up, Power View, Power Query, Power Map, Power Pivot and Power BI and see who gets to win the battle and run with the “Power”….


  • Regis Baccaro

Track and Room: Business Intelligence - N/A

Title: 10 tips everyone should know about powershell

Abstract: If you are not using powershell once in a while, then you really need to attend this session. We still find many people compiling small Console apps, or building expensive configuration UIs, but what we need in operations is a good script. Let’s learn why scripts are safer, easier to maintain and debug in production. Because the language and the runtime platform are also huge in terms of programming styles and wrappers (COM, WMI, Registry, XMLDOM, DOS, DotNet), there are always many ways to do it. In this session we will dig into some of the tips that can make our scripts much easier to use, learn and maintain.


  • José António Silva

Track and Room: Development - N/A

Title: Introduction to Microsoft Azure BizTalk Services

Abstract: In this session we’ll look at the existent functionalities in the new integration services in the cloud: Microsoft Azure BizTalk Services: EAI (Enterprise Application Integration) and EDI (Electronic Data Interchange), how to manage the exchange of EDI messages and trading partners through BizTalk Services Portal; Support Flat files, schemas and transformations (maps). And at the challenges in moving from BizTalk Server to BizTalk Services.


  • Sandro Pereira

Track and Room: Development - N/A

Title: SSISDB Catalog – Don’t be afraid

Abstract: On this session you will learn how to get useful audit and logging information about your SSIS/ETL project. You’ll learn how to progressively forget old SSIS frameworks or at least, how to integrate old SSIS framework with SSISDB catalog easily


  • Pedro Perfeito

Track and Room: Administration/Development - N/A

Title: SQL Server 2014 - Novidades no Query Optimizer

Abstract: O SQL Server 2014 traz várias melhorias com objetivo de melhorar performance de nossas consultas e criar melhores planos de execução. Nesta sessão veremos as novidades (novo cardinality estimator) em relação ao otimizador de consultas do SQL 2014.


  • Fabiano Amorim

Track and Room: Administration/Development - N/A

Title: Build mobile applications with Xamarin Forms

Abstract: Xamarin.Forms is a cross platform library that allows you to build native user interfaces for IOS, Android and Windows Phone with C# and XAML!!!


  • Rui Marinho

Track and Room: Development - N/A

Title: Because the world is not just relational - Intro to RavenDB

Abstract: RavenDb is a .NET document database with an HTTP REST API, Lucene based indexes, ACID read/writes and BASE queries that’s been picking up steam in the .NET space. In this session we’ll see the very basics of using RavenDB from a web application, including reads, writes and simple queries. We’ll see how RavenDB uses LINQ and Lucene to create indexes similar to materialized views to provide fast query-time responses, and what are the main differences in modeling data and entities from the perspective of a developer used to relational databases.


  • Bruno Lopes

Track and Room: Development - N/A

Title: Azure Machine Learning: 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.


  • Ruben Pertusa Lopez

Track and Room: Business Intelligence - N/A

Title: Introduction to Microsoft Azure SQL Databases

Abstract: In this session will introduce you to Azure SQL Databases, a highly available and scalable database service in the cloud. You will learn how to create a database and see demonstrations of the basic concepts for managing and developing with SQL Databases on Windows Azure. We’ll discuss how SQL Database helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA’s alike can focus on the aspects of their job they really care about.


  • Vitor Faria Tomaz

Track and Room: Development - N/A

Title: Modern Business Intelligence Architecture

Abstract: Interested in look at other BI architectures ? We will look at how we can move from the standard approach (with Stating, Data Warehouse, Data Marts, Reports) so we can give an answer to some trends (Big Data, Self Service, InMemory, Cloud)


  • João Lopes

Track and Room: Business Intelligence - N/A

Title: In-Memory OLTP for DBAs

Abstract: New capability on SQL Server world, the In-Memory OLTP (aka Hekaton) is one of the most exciting features of the SQL Server 2014 and promises a great improvement - looking for the performance point of view. On this session we will introduce this feature and discuss few topics as its architecture, high-availability, migration and other interesting topics for DBAs who want to better understand this new “monster”.


  • Murilo Miranda

Track and Room: Administration/Development - N/A

Title: Building abstract layers for data protection and business logic

Abstract: Many developers are working with direct access to the data layer of a database (tables) by ORM or .NET, Access, … This access methode maybe a good choice for small applications which use a dedicated database where no security or business requirement is needed.

This session demonstrates the protection of data by using schemata for data protection and implementation of business logic for multiple applications. I will demonstrate the usage of schemata in an application life cycle to reuse codes for reporting in the same way as for the web application or the fat client application.


  • Uwe Ricken

Track and Room: Development - N/A

Title: ETL Patterns with Clustered Columnstore Indexes

Abstract: Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance. Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!


  • Niko Neugebauer

Track and Room: Business Intelligence - N/A


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

José António Silva

Contact: http://www.devscope.net

Software Architect and Mentor in a wide variety of technologies. Particularly versed with Software as a Service (SaaS) in all aspects of the Strategy, Design, Deployment and Operation of these multi-tenant solutions. Always interested in Agile methodologies and Data Visualization and anything than can make tedious and repetitive work disappear from our lives. Interests: SaaS, SOA/ESB, Automation/Powershell, Business Intelligence, DataViz and BigData

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

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

Sandro Pereira

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

LinkedIn: Sandro Pereira

Contact: http://sandroaspbiztalkblog.wordpress.com/

Sandro Pereira lives in Portugal and he currently works as a BizTalk consultant at DevScope and he has been awarded the Microsoft Most Valuable Professional (MVP) since January 2011 for his contributions to the world-wide BizTalk Server community. His main focus is on Integration Technologies where is been using .NET, BizTalk and SOAP/XML/XSLT since 2002 and Microsoft Azure, in particular Microsoft Azure BizTalk Services.

Bruno Lopes

Contact: http://www.brunomlopes.com

Bruno Lopes is a software developer by trade and passion, and currently works on his startup weListen, co-founded with colleagues from college, mostly on the core product InnovationCast. He is also one of the organizers of NetPonto, a portuguese .Net user group where he usually presents on topics like RavenDB, IoC, PowerShell and was awarded the MVP title for ASP.NET/IIS in 2013.

Vitor Faria Tomaz

Twitter: - vitortomaz

LinkedIn: Vitor Faria Tomaz

Vitor Faria Tomaz is an Embedded Escalation Engineer (EEE) at Microsoft, with special focus on Azure SQL Database (single/pools/Managed Instance).

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.

Regis Baccaro

Twitter: - @regbac

LinkedIn: Regis Baccaro

Contact: http://theblobfarm.wordpress.com

Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.

Denis Reznik

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

LinkedIn: Denis Reznik

Contact: http://reznik.uneta.com.ua

Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.

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.

Rui Marinho

Contact: http://ruimarinho.net/

Software developer at DevScope

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/

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.

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.

Fabiano Amorim

Twitter: - mcflyamorim

LinkedIn: Fabiano Amorim

Contact: http:\blogfabiano.com

Fabiano Amorim is a Data Platform MVP that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.

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.


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

Back to the SQLSaturday Event List

Back to the home page