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