Event Location:
ISEP
Rua Dr. António Bernardino de Almeida, 431
Porto, Porto, Portugal
Abstract:
Your tabular model is done, approved and ready to be used by the user. By means of using Excel the user gets very excited about the use of tabular Models. For a while the user uses Excel as a self-service business intelligence tool. Then all of a sudden the user starts asking if they can use the program to extract more and other information from the tabular model by the use of Excel. Now it is up to you to familiarize the user with all the possibilities of working with the tabular model by means of Excel. Given the small amount of documented knowledge about the use of tabular models by means of Excel, I will show you how to get the best of your tabular models by using Excel as a self-service business intelligence and data science tool. Filters, named sets, and calculations in the pivot table: I will explain it all!
Speaker(s): Sander van der hoeff,
Abstract:
Road to database automation addresses the challenges of database inclusion in the Application Lifecycle Management (ALM). The set of processes that enables this inclusion is designated as Database Lifecycle Management. DLM is composed by 3 main parts: data management and migration, data monitoring and data recovery. In this presentation I will discuss the DLM general concepts, with special emphasis on data management and migration, and present some strategies and tools (source control tools as Mercurial and Git and database migrations management tools as Flyway) that can be used to overcome the database source control phase. Using automation as key factor to achieve database source control, database continuous integration and database continuous delivery. This session will not only unlock continuous integration and delivery phases but also enable agile practices that allows to mitigate/manage the gap between application and database development.
Speaker(s): Eduardo Piairo,
Abstract:
One of the most complex areas of SQL Server is the Query Optimizer. It is the component responsible for turning the logical actions (that are derived from your SQL statements) into physical actions that fetch and process the required data to form your results. Not only does it have to guarantee the correct results (no mean feat when you start to think about it) but it has to do this in a performant way and the route it takes to do this (the output of the optimization process ) is described within the execution plan. This session will be an introduction to the Optimizer and Execution Plans and take you on a journey to a wider view of the Query Engine. Once you understand what physical actions are being taken on your logical requests (i.e. your TSQL Statements) then you will be better placed make changes to influence those actions with an end result of a better performing database system.
Speaker(s): Dave Ballantyne,
Abstract:
Hadoop is the most widely talked data platform in the recent years. Hiding under the term "Big Data", one of the most disruptive data technology has arrived to the mass market in the recent years, allowing everyone to setup a data solution for everyone. The initial releases of Hadoop have had huge deficiencies in the terms of work, performance and organisation, but the Hadoop 2.0 has brought the needed changes in the underlying architecture and its steadily becoming more and more interesting as a multi-purpose data platform. Let us review what Hadoop, Spark, Hive, Pig, Tez, Ambari and others are and how can we get started with this data platform. Let us connect each of the pieces with the corresponding element in the current Microsoft Data Platform offerings to understand how can we be more effective in learning and understanding Hadoop.
Speaker(s): Niko Neugebauer,
Abstract:
Your cold data growth is getting out of control, storage consumption is increasing faster than your budget, your end-users won't (or can't) tell you what can delete or truncate, but they demand their cold or archived data always be online and available. Now you have tables so big that you dread re-indexing, and you have to look for ever more creative solutions to manage this data, while still remaining compliant. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. Come find out how you can move your data securely and transparently, free up disc space and reduce your enterprise storage consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Server Stretch database will simplify your journey to the Cloud!
Speaker(s): Scott Klein,
Abstract:
Do you plan to start monitoring your SQL Server instances soon and asking yourself what should you measure? Are you questioning if your existing monitoring data can detect and alert if a performance problem occurs? Is the data you collected from monitoring enough to pinpoint the cause of your next performance problem? I have worked with SQL Server as a developer in the Redmond team for more than 12 years and during this time I've investigated countless performance problems. In time I developed a strategy on how to use the performance monitoring data to analyze problems and identify the root cause. This session is going to to show you how I monitor SQL Server, what data do I look for, and how I interpret the collected data to analyze performance issues. Going beside the obvious CPU, Memory and IO counters, I will show you how to identify typical performance issues from monitoring data, all without overwhelming the captured data volume.
Speaker(s): Remus Rusanu,
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 and Always Encrypted.
Speaker(s): Ivan Campos,
Abstract:
Polybase is one of the new features that got released on the new SQL Server 2016 version. It's a pretty useful technology if you want to access and join both relational and non-relational data, all from within SQL Server. We can run this queries against external data like Hadoop or Azure blob storage with the advantage of the query computation be optimized and managed on our Hadoop cluster. Attend my session if you want to learn how to take advantage of this technology and where we can use it in real life scenarios. I will also cover installation, configuration and troubleshooting.
Speaker(s): Andre Batista,
Abstract:
OnPrem or on Azure: how can Docker Containers and SQL Server coexist in developing Enterprise grade solutions. Building some sample scenarios using the power of the new Windows 2016 containers and Azure Container Services.
Speaker(s): Pedro Sousa,
Abstract:
The hype is over and scalable systems like Hadoop and Spark are a reality for an ever growing number of companies. Now's the time to use its capabilities for empowering your Data Science Analytics teams, delivering data products and interactive visualizations. In this session we will talk about a data-driven vision supported by Azure's cloud features, with emphasis on Jupyter Notebooks.
Speaker(s): Filipe Coelho,
Abstract:
In this session we will talk about the Real-Time analytics possibilities with SQL Server 2016. This will be a deep-dive on how this works, and will give you an explanation on the new Columnstore features. We will also talk about the difference between hot warm data.
Speaker(s): Stijn Wynants,
Abstract:
If you are considering to implement an SQL Server AlwaysOn availability group and want to anticipate either some configuration or future operational traps, this session is for you! We will talk about a range of common and uncommon issues you may face concerning your availability group infrastructures. Then we will explain how to resolve them on the basis of real customer cases.
Speaker(s): David Barbarin,
Abstract:
As organizations see the benefits of the cloud, you may find yourself involved in migration projects which target the move from on-premises SQL Server to the cloud. Are you ready for this? In this session, we will compare and contrast different migration strategies. We will cover different ways to migrate your SQL Server database from on-premises to Azure, and how to detect and solve potential migration blockers and issues.
Speaker(s): Murilo Miranda,
Abstract:
Do you know you can now use R powerful language thousands of advanced analytics machine learning packages right in SQL Server 2016? Power BI? or in AzureML? AzureML Jupyter notebooks? or even Visual Studio? Are you a BI Developer? DBA? BI Analyst or a data/analytics lover? Come along, join us in this session as we explore this powerful, sometimes even strange!... language , showing main differences from the typical SQL/BI development. This is a beginner level session to help you with R first steps challenges.
Speaker(s): Rui Quintino,
Abstract:
The new release of SQL Server Analysis Services 2016 brings a lot of new features which developers were asking for ages. In this session I will cover the most important improvements, especially in terms of development, maintenance and performance. There is a lot to cover so better be prepared for an intense session!
Speaker(s): Gerhard Brueckl,
Abstract:
SSMS is one of the main tools that help every person, DBA and/or developers, doing their work everyday. I will show to you features that you do not even knew that exist and how they can improve your productivity. Come take a look to SSMS 2016 and understand how it will help you even if you don't have SQL Server 2016 instances. After this session I hope you have learnt at least one or two features of SSMS.
Speaker(s): Cláudio Silva,
Abstract:
Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare? In this session we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Speaker(s): Mark Broadbent,
Abstract:
Sim existem imensos frameworks SSIS, mas no mundo real temos todos tend#234;ncia a consolidar o conjunto de boas pr#225;ticas que vamos usando nos projectos, que obtivemos via a experi#234;ncia acumulada e o que foi partilhado pela comunidade ... por isso nada como pensarmos um pouco sobre o que um framework de integra#231;#227;o moderno dever#225; ter certo ?
Speaker(s): João Lopes,
Abstract:
This session will cover how implement a high performance queue via the LMax queuing pattern with both the legacy row store engine and the in-memory OLTP engine. With the aim of squeezing every last ounce of performance out of the database engine, this session will cover database engine internals at a deep level and make use of stack traces and windows performance tool kit. The session will also cover spin locking and principles which will before other types of exacting OLTP workloads.
Speaker(s): Christopher Adkin,
Abstract:
This is one of the existing functionalities of the Windows Server 2016. How does it works ? Come and find out in this session.
Speaker(s): Ricardo Cabral,
Abstract:
In this session, I'll show you how to get the most interesting features and tips from the main Microsoft data visualization tools like SSRS, Excel and Power BI. I'll show you what you cannot see in the books and help you create Help full reports with real works examples.
Speaker(s): Pedro Perfeito,
Abstract:
The Cloud has earned its place in many companies topology. This session focusses on performing SQL Server backups directly pushing that backup files to Azure Blob storage and highlights considerations with regards to security and testing these backup files for recoverability, and cloud costs involved.
Speaker(s): Johan Bijnens,
Abstract:
Do you know what SQL Data Warehouse is? Will it be the right choice for my solution? How does it work? Is it easy to migrate my solution to it? This and many more questions will not be answered in this session but you will leave with the information to answer yourself those questions and many more.
Speaker(s): Vitor Pombeiro,
Abstract:
Troubleshooting performance issues is one of the most formidable tasks for a DBA to perform, as well as one of the most defying... The new Query Store feature in SQL Server 2016 is a major enhancement, simplifying both the identification of performance issues and it's resolution. Throughout a set of 13 demonstrations I'll explain what Query Store is, how you can take advantage of it and also some alerts you should be aware of. If you're a performance troubleshooter I'm sure you'll like this session!
Speaker(s): Etienne Lopes,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
LinkedIn: https://pt.linkedin.com/in/claudioessilva
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.
LinkedIn: http://pt.linkedin.com/in/murilomiranda/
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.
LinkedIn: http://fr.linkedin.com/in/mikedavem/en
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).
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
LinkedIn: http://www.linkedin.com/profile/view?id=9488495amp;trk=tab_pro
Johan Bijnens is a database firefighter, involved with SQLserver since 2000, who works at Aperam Genk as member of the Industrial IT support department. Involved in designing architectural solutions based on the Microsoft SQL Server Platform. Performing operational performance and troubleshooting support in co-operation with the dev teams.
LinkedIn: https://pt.linkedin.com/in/jesuspiairo
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.
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
LinkedIn: https://www.linkedin.com/in/wollatondba
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.
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/
LinkedIn: https://www.linkedin.com/in/vitorpombeiro
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.
LinkedIn: https://pt.linkedin.com/in/pmsousa
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.
LinkedIn: http://pt.linkedin.com/pub/andre-batista/9/111/790/
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.
LinkedIn: http://www.linkedin.com/in/retracement
Contact: http://tenbulls.co.uk
Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK's SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.
LinkedIn: https://pt.linkedin.com/in/fcoelhophd
Filipe Coelho has a PhD in Data Science from FEUP and is a Microsoft Azure Cloud professional. Previously he was Lead Data Scientist at SAPO Labs - Portugal Telecom and Big Data Engineer at Farfetch. He is currently designing Big Data platforms for exploring patterns and developing Machine Learning data products.
LinkedIn: https://www.linkedin.com/in/joaolopes
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.
LinkedIn: https://www.linkedin.com/in/stijn-wynants-ba528660?trk=hp-identity-name
Contact: http://swyssql.wordpress.com
Stijn is a Microsoft Premier Field Engineer on Data AI and a DataMinds core member. He is also one of the organizers of the local user group sessions the yearly event called DataMinds Connect (SQL Server Days). He is a speaker at various international events (SQLSaturday,PASS Summit,Difinity,...). He spends his days tuning SQL Servers solving problems with the full data platform. His focus is primarily on sql server core, but has also done various BI ETL projects. He gets his kicks out of Columnstore indexes tuning queries but shivers at the sight of an SSAS cube. When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine local beers or enjoying time with his wife and his dog.
LinkedIn: https://pt.linkedin.com/in/rquintino
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.
LinkedIn: https://pt.linkedin.com/in/rrcabral
Contact: http://blog.en.rramoscabral.com
Ricardo Cabral is a Technical Engineer and also Microsoft Certified Trainer (MCT). In his free time, he is actively participating, volunteering and/or speaking portuguese community meetings (Azure PT, Arduino Day, Cloud Pro PT, IT Pro Portugal, Netponto, O365PT, PowerShell Portugal, PTJUG, SQLPort, SQLSaturday, Tuga IT, etc.). He is one of the co-founders of IT Pro Portugal and PowerShell Portugal user group. Ricardo is interested in technology with over 14 years of experience in IT management, development and projects. He is an authentic self-taught man. Ricardo holds a Degree in Computer Engineering from Universidade Autónoma de Lisboa.
LinkedIn: http://pt.linkedin.com/in/webcaravela/
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.
LinkedIn: http://at.linkedin.com/in/gbrueckl/
Contact: http://blog.gbrueckl.at
Gerhard has been working with Microsoft BI tools since 2006 mainly focusing on Microsoft SQL Server and its components. As a consultant and architect he designed various enterprise BI solutions primary in the German-speaking areas. His personal interest has always been on analytical databases and their capabilities. In 2012 he achieved the SSAS Maestro certification. He is also very active in the community, has its own blog and speaks at conferences all over the world on a regular basis.
LinkedIn: http://nl.linkedin.com/in/shoeff
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
LinkedIn: https://linkedin.com/in/remusrusanu
Contact: http://rusanu.com
Remus Rusanu is a former SQL Server team member. For 12 years he worked on such features as Service Broker, Columnstore Indexes, Query Store and many more. In April 2016 he left Microsoft to found DBHistory.com, a simplified SQL Server monitoring and auditing product.
LinkedIn: https://pt.linkedin.com/in/idcampos
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.
The following is a list of sponsors that helped fund the event.
Rumos - Formação e Comunicação, S. A.