SQLSaturday #685 - Porto 2017

Event Date: 10/28/2017 00:00:00

Event Location:

ISEP
Rua Dr. António Bernardino de Almeida, 431
Porto, Porto, 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: SSIS Package generation with BIML

Abstract: Ever ended up with a source system where an old datatype was replaced with a new one so you had to rebuild all your SSIS packages? Entered a project with SSIS packages which needed a complete rebuild to perform but you didn’t have the time for a rebuild of your whole project? Client specifications changed (again) and you had to start all over again building all your packages?

We did it all and rebuild 100+ SSIS packages within a day using biml for generating SSIS packages. And with a generator at hand, we were able to absorb a new version of a source system including analysis of the changes made in the source in only two days. And the best of all, BIML is part of BIDSHelper and free to use! Don’ t just believe what I say, In my session I will demonstrate where to start. I will show you around in BIML. After the quick basics of BIML I will show you how you can parameterize the BIML script in order to multiply the template to multiple packages over and over again.

Speaker(s):

Sander van der hoeff

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

Title: Database Continuous Delivery on the Microsoft Platform

Abstract: A look at the state of the art in database continuous delivery using SQL Server Data Tools (SSDT), Visual Studio Team Services(VSTS), and VSTS Release Management.

The features provided by platforms such as TFS and VSTS have been widely adopted by application developers in support of modern software development practices such as continuous delivery.

In the world of database development, adoption has been much slower, due to a number of organisational and technical considerations.

This session will discuss some of the challenges associated with database continuous delivery, and the ways in which Visual Studio, SQL Server Data Tools and Visual Studio Team Services can help to improve delivery of SQL Server databases.

Speaker(s):

Gavin Campbell

Track and Room: Cloud Application Development Deployment - Auditorium 3

Title: SQL Server and Continuous Integration

Abstract: It’s understandable that developers love to work in separate code branches, but this can create painful complications if not managed.

Do you dread large merge conflicts when integrating code? Continuous Integration is method of working where we merge and fully test our code multiple times a day. This is only possible with a high level of automation.

I’ll be discussing the tools I use to achieve this automation when developing SQL Server databases.

Finding automating the deployment of database changes hard? ReadyRoll is a tool that allows you to test deployments during development.

How do you know your database change won’t affect something you haven’t thought of? tSQLt and Pester unit tests can put your mind at rest.

Having trouble keeping your test environments in sync with production? Docker enables us to fix this with infrastructure as code

You will see how a CI approach to database development can increase team efficiency and reduce the time to go from an ide

Speaker(s):

James Anderson

Track and Room: Cloud Application Development Deployment - Auditorium 3

Title: Deep dive into Query Store on SQL Server 2016

Abstract: Query Store is a new feature that got released on SQL Server 2016 version and is being improved over the last cumulative updates and on SQL Server 2017 vNext CTP’s versions. It’s a very useful and interesting feature that allow DBA’s ( and non-DBA’s :) ) to easily identify performance issues on queries and also allow us to fix it in a fast and simple way. Just the ability to compare a previous execution plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. I want with this session to give you the insight and knowledge to get started using this new and wonderful feature that will change the way how you do performance tuning.

Speaker(s):

Andre Batista

Track and Room: Enterprise Database Administration Deployment - Auditorium 1

Title: Patterns for building hybrid scenarios with SQL Server and Azure

Abstract: SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don’t have to exclude each other but instead you can have the best of both worlds.

For example, by taking advantage of services like Azure Blob Storage or Azure VMs we can increase the availability of our services or distribute data in smart ways that benefit our performance and decrease cost. In this demo-heavy session, you will learn the strongest use cases for hybrid scenarios between on-premises and the cloud, and open a new horizon of what you can do with your SQL Server infrastructure. SQL Server and Azure are built for each other.

New hybrid scenarios between on-premise SQL Server and Azure mean they don’t have to exclude each other but instead you can have the best of both worlds.

Speaker(s):

Murilo Miranda

Track and Room: Enterprise Database Administration Deployment - Auditorium 1

Title: Discover the new graph features of SQL Server 2017

Abstract: In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.

Speaker(s):

Rudi Bruchez

Track and Room: Enterprise Database Administration Deployment - Auditorium 1

Title: Development Methodology for BI teams

Abstract: BI teams usually not only deliver features , but also do the ad hoc reports, users support etc This way BI is not a canonical development team and no pure development methodology works “out of the box” . In my talk I would like to share my experience choosing and adjusting one.

Speaker(s):

Maryna Popova

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

Abstract: DevScope Sponsor Session

Speaker(s):

Ivan Campos

Track and Room: Information Delivery - Auditorium 2

Title: Setting a WordPress website using Azure Web Apps and Azure Database for MySQL

Abstract: This session is about how to set up a WordPress website hosted in Azure using Azure Web Apps and Azure Database for MySQL. As a plus, during the session I will share some tricks about how to build a process/pipeline to deploy changes in the website.

Speaker(s):

Eduardo Piairo

Track and Room: Cloud Application Development Deployment - Auditorium 3

Title: “Start Small and Grow Big” with Power BI and Azure AS

Abstract: In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then (if needed) evolve it into a fully scalable Azure BI solution.

Speaker(s):

Rui Romano

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

Title: What you want to know about Azure Database for MySQL and PostgreSQL?

Abstract: In this session we will learn: What is “Azure Database for MySQL” and “Azure Database for PostgreSQL”, how can we configure them, what to take attention to and what to expect from these new services. What is the difference from these new services and the MySQL and PostgreSQL that we use on our computers or servers. How to take the best advantage of using this databases as PaaS And much more…

Speaker(s):

Vitor Pombeiro

Track and Room: Cloud Application Development Deployment - Auditorium 3

Title: Pattern analysis with SQL Server DM Excel DM AzureML R PowerBI

Abstract: We have an enormous set of tools for analysis and pattern matching in the data ecosystem. Among the most used, we can find solutions that come from the academic world such as R, others integrated as part of productivity solutions such as SQL Server Analysis Services or Excel, as well as cloud based hosted solutions such as Azure Machine Learning and Power BI. In this session, we will use the mentioned tools to analyze a common data set, discovering the compositions, segmentation and patterns present in the data sample.

Speaker(s):

Ana Maria Bisbé York

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

Title: Azure SQL Database - Lessons learned from the trenches

Abstract: In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.

Speaker(s):

Roberto Cavalcanti

Track and Room: Cloud Application Development Deployment - Auditorium 3

Title: Modeling scenarios in DAX, the awesome language of Power BI

Abstract: The right tabular modeling is the cornerstone that allow us to build the best dashboards, control panels and analytical models. In this session we will analyze some scenarios of data modeling by using DAX and Power BI. These scenarios, which come from real projects, can also be adapted to tabular models with SQL Server Analysis Services in SQL Server Data Tools and Power Pivot in Excel.

Speaker(s):

Ana Maria Bisbé York

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

Abstract: Natixis Sponsor Session

Speaker(s):

Ivan Campos

Track and Room: Information Delivery - Auditorium 1

Title: SQL Server on Linux and high availability

Abstract: Open source is part of the Microsoft strategy. Indeed, you may run SQL Server either on a physical or a virtual machine, and recently on the top of Windows or Linux operation system as well.

At the same time, maintaining business continuity service remains a major challenge for customers because it is synonymous with economic competitivity. Fortunately, high availability features for Linux will also be shipped with SQL Server 2017 to address this daily concern.

This session will be delivering an overview of what is new and how it is going to change the landscape of your mission-critical scenarios.

Speaker(s):

David Barbarin

Track and Room: Enterprise Database Administration Deployment - Auditorium 1

Title: Hiding data with SQL Server 2016/2017

Abstract: Security is unquestionably a major priority for Microsoft. Join me in this session and see what security features Microsoft has released since SQL Server 2016. In this session you will see how Dynamic Data Masking and Row-Level Security works in on-perm and Azure environments and how to use Always Encrypted.

Speaker(s):

Ivan Campos

Track and Room: Enterprise Database Administration Deployment - Auditorium 1

Title: Yet Another Session about Docker and Containers

Abstract: Following the trends of hot-topic Docker and Containers. We will talk about the newest developments in Docker World and Microsoft’s container adoption.

Speaker(s):

Pedro Sousa

Track and Room: Cloud Application Development Deployment - Auditorium 3

Title: Taking Security to another level: SQL Server Audit

Abstract: Your company implements data access rules and policies to meet compliance with established security standards… How can you ensure and prove at any time that they’re being properly followed, without killing your database servers performance while capturing evidence?

In this Session I’ll talk about SQL Server Audit and demonstrate how easy it is to implement in such a way that suits most companies needs, whithout afecting Server performance. Also some news in SQL Server 2017 regarding this subject!

Speaker(s):

Etienne Lopes

Track and Room: Enterprise Database Administration Deployment - Auditorium 1

Title: R Server on Spark - Go big or go home

Abstract: The publication of R Server by Microsoft aims to improve the weaknesses of the R language and its processes of performance, development and operationalization. When we need to analyze very diverse or really large amounts of data, traditional servers may fall short, and this is where R Server over Spark comes to the rescue. How is it implemented in the Microsoft ecosystem? In what scenarios does it help us? How do we configure it? In this session we will answer all these questions and more, with our eyes always on the clouds and thinking big.

Speaker(s):

Pau Sempere

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

Speakers

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

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

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

Roberto Cavalcanti

Twitter: - rocavalc

LinkedIn: Roberto Cavalcanti

Roberto Cavalcanti is an Azure Cloud Solution Architect with the Customer Architecture and Engineering team at Microsoft. He is a database specialist with 20+ years of experience. He focuses on helping customers to be successful in Microsoft’s Azure cloud and on improving Microsoft Azure products. Roberto has written many articles about SQL Server/Azure SQL DB for MSDN/TechNet, SQL Magazine, and has been a speaker in events such as TechReady, Microsoft Insights/TechEd, SQLSaturday. He has delivered Azure training in multiple countries in the Americas, and in Europe. Roberto is based on the Microsoft Las Colinas, Texas, USA office.

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

Ivan Campos

Twitter: - WizardDBA

LinkedIn: Ivan Campos

Contact: http://wizarddba.com/

Pau Sempere

Contact: http://www.solidq.com

Pau Sempere S#225;nchez is a Computer Science graduate, working at SolidQ as Data Platform Architect and is member of PASS Spanish Group. He#39;s worked in BI and database projects for top companies in the world, in diverse areas as communications, insurance, retail, transport, banking and automotive. He has been presenting in many Microsoft and community events such as SQLSaturday Madrid and Barcelona, the 12 hours of SQL Server, SolidQ Summit or TechNet Webcasts, and teaching in the SolidQ Master for 6 years in a row

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/

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

Gavin Campbell

LinkedIn: Gavin Campbell

Contact: http://arapaima.uk

Gavin Campbell is a recovering Business Intelligence developer specialised in improving working practices in database delivery through the use of tools such as SQL Server Data Tools, tSQLt, Visual Studio Team Services, Git and Jenkins, on platforms such as AWS and Microsoft Azure, and methodologies such as Continuous Delivery and Agile.

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.

Ana Maria Bisbé York

Twitter: - @ambynet

LinkedIn: Ana Maria Bisbé York

Contact: http://amby.net/

Partner Microsoft en Power BI. Influencer en Pragmatic Works. Lic. en Cibernetica Economica con Master en Ciencias Economicas, Moscu; 1988. Master en Gestion del Conocimiento y Business Intelligence con tecnologia Microsoft(MS), y Master en Tecnologias de Desarrollo de MS. Colaboro activamente en grupos de usuarios de MS Visual FoxPro. Mantiene un blog personal. Actualmente es Consultora Business Intelligence con tecnologia MS, trabajando tanto en formacion como en proyectos. Ha sido ponente en eventos SQLSaturday, dentro y fuera de Espania, 24H SQL, IT Woman y Encuentros en Microsoft Espania.

Maryna Popova

I am a Big Data Engineer in a BI team. I have around 4 years of professional expertise in the Information Technologies industry, mainly all around data Engineering and Data Warehousing. I am working on my 3rd BI Project now. All of them are in different business areas and are using different technologies. What is common between them is the willingness to find the most proper development methodology as it is not a canonical development team and no development methodology works “out of the box” . In my talk I would like to share my experience in this area.

Rudi Bruchez

Twitter: - nepasderanger

LinkedIn: Rudi Bruchez

Contact: http://www.babaluga.com/

(same as before)

Ana Maria Bisbé York

Twitter: - @ambynet

LinkedIn: Ana Maria Bisbé York

Contact: http://amby.net/

James Anderson

Twitter: - @DatabaseAvenger

LinkedIn: James Anderson

Contact: http://TheDatabaseAvenger.com

James Anderson is a freelance SQL Server guy in Southampton, UK. He has been working with databases since 2008. The first and worst RDBMS he worked with was Paradox. He quickly moved to using T-SQL in SQL Server 2005 and has worked on every version of the product since. His work ranges from stand-alone systems for simple websites to multi terabyte HA environments that support thousands of sites across Europe. Each have their own challenges.

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.

Ana Maria Bisbé York

Twitter: - @ambynet

LinkedIn: Ana Maria Bisbé York

Contact: http://amby.net/

Ivan Campos

Twitter: - WizardDBA

LinkedIn: Ivan Campos

Contact: http://wizarddba.com/

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.

SQLSaturday #685 - Porto 2017

Sessions

Title: SSIS Package generation with BIML

Title: Database Continuous Delivery on the Microsoft Platform

Title: SQL Server and Continuous Integration

Title: Deep dive into Query Store on SQL Server 2016

Title: Patterns for building hybrid scenarios with SQL Server and Azure

Title: Discover the new graph features of SQL Server 2017

Title: Development Methodology for BI teams

Title: DevScope Sponsor Session

Title: Setting a WordPress website using Azure Web Apps and Azure Database for MySQL

Title: “Start Small and Grow Big” with Power BI and Azure AS

Title: What you want to know about Azure Database for MySQL and PostgreSQL?

Title: Pattern analysis with SQL Server DM Excel DM AzureML R PowerBI

Title: Azure SQL Database - Lessons learned from the trenches

Title: Modeling scenarios in DAX, the awesome language of Power BI

Title: Natixis Sponsor Session

Title: SQL Server on Linux and high availability

Title: Hiding data with SQL Server 2016/2017

Title: Yet Another Session about Docker and Containers

Title: Taking Security to another level: SQL Server Audit

Title: R Server on Spark - Go big or go home

Speakers

Sponsors