SQLSaturday #485 - Lisbon 2016

Event Date: 02/20/2016 00:00:00

Event Location:

  • Microsoft PT
  • Rua do Fogo de Santelmo, Lote 2.07.02
  • lisbon, Lisbon, 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).


Sessions

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


Title: Security enhancements in SQL Server 2016

Abstract: There are several pretty cool enhancements regarding security in SQL Server 2016.

This session will cover some of them in the following (new) topics:

  • Always Encrypted: Worried about having your sensitive data stored in a cloud managed database? This feature can help you, allowing to ensure that your cloud provider can’t look at your sensitive data, since it remains encrypted for him, but not for you :-)

  • Dynamic Data Masking: By using this feature you can control how does your confidential data appear to those that shouldn’t have entire access to it. For instance they should only be able to see the first 3 digits of a phone number…

  • Row Level Security: Row-Level Security enables us to control access to rows in a database table based on the characteristics of the user executing a query.

Join me in a set of full demonstrations for all these features!

Speaker(s):

  • Etienne Lopes

Track and Room: CORE Track                                Room Azure B - CORE Track


Title: Introdu#231;#227;o ao In-Memory OLTP (hekaton) com SQL Server 2016

Abstract: Quando temos necessidade de efetuar transa#231;#245;es #224; velocidade da luz, esta vai ser sem d#250;vida a tecnologia que vai pensar usar. Tecnologia nascida na vers#227;o anterior (SQL Server 2014) e melhorada na vers#227;o 2016, In -Memory OLTP #233; sem d#250;vida uma grande aposta por parte da Microsoft para solucionar este tipo de exig#234;ncias do atual mercado das TI. Nesta sess#227;o vou explicar de uma forma clara o que consiste este novo componente do SGBD da Microsoft como come#231;ar a utilizar, limita#231;#245;es e alguns truques para resolver algumas das limita#231;#245;es.

Speaker(s):

  • Ivan Campos

Track and Room: CORE Track                                Room Azure B - CORE Track


Title: Query Store no SQL Server 2016

Abstract: O Query Store #233; uma nova funcionalidade que ser#225; lan#231;ada com o SQL Server 2016 que permitir#225; armazenar o hist#243;rico de planos de execu#231;#227;o de cada consulta juntamente com os contadores de desempenho. Ser#225; poss#237;vel de uma maneira mais f#225;cil corrigir alguns problemas de desempenho sobre as altera#231;#245;es que ocorrem nos planos de execu#231;#227;o. Junta-te a mim nesta sess#227;o, para obter mais informa#231;#227;o e falar sobre esta nova funcionalidade, que vai mudar a maneira de podermos corrigir e solucionar problemas de desempenho.

Speaker(s):

  • Andre Batista

Track and Room: CORE Track                                Room Azure B - CORE Track


Title: Getting Started with U-SQL Azure Data Lake Analytics

Abstract: Born out of the internal Big Data language called SCOPE, U-SQL is the language of the new generation that combines the powers of SQL and the extensibility of the C#. Capable of working with Azure Data Lake Storage, Azure Blob Storage, Azure SQL DB Azure SQL DW and Azure VMs with SQL Server, U-SQL is the language of choice if you are looking for querying and combining data from variety of data sources.

Let us discover what is exactly U-SQL Azure Data Lake Analytics are and how they can be of big help for your projects.

Speaker(s):

  • Niko Neugebauer

Track and Room: CORE Track                                Room Azure B - CORE Track


Title: Power BI For Real World Business Scenarios

Abstract: Depois de ter partilhado as vantagens e desvantagens do Power View no passado m#234;s de maio de 2015 no SQLSaturdays, desta vez proponho a apresentar dois casos reais na #225;rea de jogo e retalho para avaliarem se de facto o Power BI #233; agora funcional e ultrapassa todas as limita#231;#245;es do Power View. Estar#225; o Power BI preparado para casos reais? Venha descobrir…

Speaker(s):

  • Pedro Perfeito

Track and Room: BI Track                                 Room Azure A - BI Track


Title: Azure VM’s with SQL Server - Notes from the field

Abstract: Vamos apresentar algumas das boas praticas e a nossa experiencia com m#225;quinas virtuais Azure com SQL Server

Speaker(s):

  • Pedro Simoes

Track and Room: CORE Track                                Room Azure B - CORE Track


Title: What’s New in Reporting Services 2016

Abstract: Find out what Reporting Services may improve even more your Reporting skills. How to pin items to Power BI, new HTML 5 Renderind, PowerPoint Export Rendering, the custom Parameters Pane, are only some of the new cool stuff that you could find in the new version of Reporting Services. This and a lot more is waiting for you… Come and see for yourself.

Speaker(s):

  • Artur Santos

Track and Room: BI Track                                 Room Azure A - BI Track


Title: Power BI for Developers

Abstract: Are you a developer? Want to learn what PowerBI has for you? Then come to my session where you will learn how to enhance your applications with PowerBI experiences…

In this talk I will show you an overview of the developer ecosystem in Power BI and share my experiences in the creation of Power BI Office Apps (Power BI Tiles and Send to PowerBI) and the community PowerShell module PowerBIPS.

Speaker(s):

  • Rui Romano

Track and Room: BI Track                                 Room Azure A - BI Track


Title: What’s new in SSIS2016

Abstract: SSISDB catalog #183; Deployment #183; Debugging #183; Azure #183; Etc.

Speaker(s):

  • Quilson Antunes

Track and Room: BI Track                                 Room Azure A - BI Track


Title: Availability Groups 2016: Quais s#227;o as novidades?

Abstract: O SQL Server 2016 est#225; proximo de ser lan#231;ado, e muitas novidades est#227;o a caminho. O Availability Groups nao #233; exce#231;#227;o! Saiba nesta sess#227;o tudo sobre a solucao numero 1 de HADR do SQL Server.

Speaker(s):

  • Murilo Miranda

Track and Room: CORE Track                                Room Azure B - CORE Track


Title: How to use R in SQL Server 2016

Abstract: R represents the primary analysis language for the majority of data scientists and statisticians. SQL Server 2016 will allow you to run R scripts. In this session we will demonstrate how to run R analytics in the database so any user can explore the data, build predictive models and embed the R code into Transact-SQL stored procedures.

Speaker(s):

  • Bruno Ferreira

Track and Room: BI Track                                 Room Azure A - BI Track


Speakers

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

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.

Bruno Ferreira

Twitter: - @Mairos_B

LinkedIn: Bruno Ferreira

Bruno Ferreira lives in Porto, Portugal and currently works in Data Research and Machine Learning at DevScope. His main focus areas are Machine Learning, Azure ML Studio, R and Power BI.

André Melancia

Twitter: - AndyPT

LinkedIn: André Melancia

Contact: http://Andy.PT

Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.

19+ years’ fun developing information and multimedia systems, DBA, project and IT management.

Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.

Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.

Go to http://Andy.PT and you’ll know the same as the NSA…

Quilson Antunes

LinkedIn: Quilson Antunes

Quilson Antunes #233; DBA na hmR - Health Market Research, licenciado em Inform#225;tica de Gest#227;o pelo SLA Campus Lisboa - Laureate International Universities. No decurso do seu percurso profissional adquiriu experi#234;ncia na coordena#231;#227;o de recursos e compet#234;ncias em infra-estrutura e desenvolvimento de processos ETL. Cumulativamente possui s#243;lidos conhecimentos em administra#231;#227;o, desenho e desenvolvimento de bases de dados em SQL server desde a vers#227;o 7

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.

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.

Artur Santos

LinkedIn: Artur Santos

Over 15 years of experience with SQL Server, since 6.5. Author of several Workshops on SQL Server and SharePoint. Passioned with technology, and also as speaker in several events.

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.

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.

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.

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.

Tiago Costa

Twitter: - tiagocostapt

LinkedIn: Tiago Costa

Contact: http://www.tiagocosta.eu/

Tiago Costa is an IT Consultant in Microsoft Technologies. For the past years he has been architecting and developing solutions for clients using Azure, Office 365, SharePoint, .Net and SQL Server. He has a strong real world experience and regularly teaches Azure, Office 365, SharePoint, .Net and SQL Server classes across Europe and other worldwide locations. Tiago detains several Microsoft Certifications and he is also MCT – Microsoft Certified Trainer. In 2013 he was nominated MCT Regional Lead by Microsoft Corp and has been renewed every year including in Jan, 2017 for a more 2 years term (2017 - 2018). In 2016 he has been awarded with the Microsoft MVP Award in Office Server and Services for his community efforts.

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.

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

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.

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.

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/

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.

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.

Pedro Simoes

Twitter: - @pedro_mg_simoes

LinkedIn: Pedro Simoes

Contact: http://pedromsimoes.wordpress.com

Works in Glintt - Global Intelligent Technologies (http://www.glintt.com) as a systems administrator and DBA in some specific situations; has about 20 years experience and has some certifications which can highlight the following: MCP, MCSA 2003 MCDBA, MCSE 2003, MCTS, MCITP (Windows 2008 + SQL2008). It is one of the oldest and most active members of the Portuguese community SQLPORT.com

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

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page