SQLSaturday #925 - Porto, Portugal 2019
Event Date: 11/23/2019 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.
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: dbatools and Power BI walked into a bar
Abstract: Going into a new shop and don’t know the environments can be intimidating. The current DBA team/client just throws a list of instances where you should have access and want you to do magic!
Fortunately, we can leverage the dbatools PowerShell module to get a whole bunch of information that will give us a state of the art and help to answer some questions. What resources (CPU/Memory) are allocated? Which version and edition is installed? What is the size evolution of my database, filegroup or table? Do you know how many records the biggest table is growing by every day? What will a forecast tell you about your database/file group/table size in 2 months? will you need more space?
I will show how you can save the information gathered by dbatools on a central database. On top of that, how can you leverage from a couple of Power BI dashboards that I have created. This dashboard will help you answer these and other questions faster than you thought it would be possible.
Speaker(s):
- Cláudio Silva
Track and Room: Enterprise Database Administration Deployment - Auditorium 1
Title: SQL Server Kubernetes
Abstract: Running SQL Server in containers has huge benefits for Data Platform professionals but there are challenges to running SQL Server in stand alone containers. Orchestrators provide a platform and the tools to overcome these challenges.
This session will provide an overview of running SQL Server in Kubernetes, which is the leading orchestrator.
Topics covered will be: - An overview of Kubernetes. Definition of pods and services. Deploying SQL Server containers to Kubernetes. Persisting data for SQL Server in Kubernetes. An introduction to Helm Chaos engineering for SQL Server in Kubernetes using Space Invaders!
This session is aimed at SQL Server DBAs and Developers who want to learn the what, the why, and the how to run SQL Server in Kubernetes.
Speaker(s):
- Andrew Pruski
Track and Room: Cloud Application Development Deployment DevOps - Auditorium 1
Title: “DAX” the way to do it
Abstract: Love it or hate it, you just can’t ignore DAX. In this session I’ll show you it’s true power and how by knowing it you can even completely rethink your data modelling!
Many times data models are configured in a way that the formulas which are applied to it are simple and fast to calculate. But with the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at the same time. And by knowing DAX, you can also plan your models in a better way just by leaving it up to DAX.
In this session you will learn:
- Handling different granularities
- Handling multiple factuals in the same model
- Calculations with disconnected tables
- Advanced Time intelligence
- Multiple formulas and tricks
Speaker(s):
- Pedro Reis
Track and Room: Advanced Analysis Techniques - Aditorium 2
Title: Continuous Intelligence… What’s This All About?
Abstract: Continuous Intelligence combines the terms of Continuous Integration and Business Intelligence and aims at defining and implementing processes to keep your implementation and deployment processes for your BI applications flexible and as seamless as possible. Even in the near past, support for CI processes of BI projects was almost not there. But, the last few years brought some changes to the perception of this topic and shifted the mindset. Let’s look at advantages and challenges for CI in BI and at possibilities to implement such a process for Analysis Services.
Speaker(s):
- Gabi Münster
Track and Room: BI Platform Architecture, Development, Administration, Information Delivery - Aditorium 2
Title: Azure Database Migration Service
Abstract: The Azure Database Migration Service is a fully managed service designed to enable seamless migrations from multiple database sources to Azure Data platforms with minimal downtime. At this session, we discuss the several scenarios available with this tool and see some hands-on demos.
Speaker(s):
- Pedro Sousa
Track and Room: Enterprise Database Administration Deployment - Auditorium 1
Title: SQL Server 2019 what’s new for the DBA’s
Abstract: Version after version Microsoft continues to improve a little bit DBA’s life, let’s see what news we have in this new version (2019) to help us in our daily tasks. Join me in this session and let’s see what is Scalar UDF inlining, Table variable deferred compilation, resumable online index creation, Memory-optimized tempdb, accelerated database recovery etc
Speaker(s):
- Ivan Campos
Track and Room: Enterprise Database Administration Deployment - Auditorium 1
Title: Batch Execution Mode on Rowstore Indexes
Abstract: With the upcoming appearance of the SQL Server 2019, Microsoft is bringing the super-fast Batch Execution Mode to the processing of the big amount of data even for the traditional Rowstore Indexes on SQL Server 2019 and Azure SQL DB.
Learn with me how and when it will function, and which challenges we shall meet on the path of making our workloads work blazingly faster, while also learning which cases one should be very careful about their application and usage.
Speaker(s):
- Niko Neugebauer
Track and Room: Enterprise Database Administration Deployment - Auditorium 1
Title: PowerBI: From Zero to Hero
Abstract: Starting from the very beginning, in this session we will cross together the main features Power BI has to offer, starting with the powerful self-service ETL using M language when needed, modeling our tables and finally using powerful features to create a great data visualization, allowing you to better understand all the power and flexibility of this tool and how it will fit into your solution
Speaker(s):
- Dennes Torres
Track and Room: Analytics and Visualization - Aditorium 2
Title: Analysis Services - And the journey goes on…
Abstract: Throughout the past few months some very promising announcements have been made regarding the future of Analysis Services. Let’s start with a recap of the journey so far and look into the future based on those announcements: Which new features are to come? Which modes are affected by changes? What does this mean in regards to strategic positioning?
Speaker(s):
- Gabi Münster
Track and Room: BI Platform Architecture, Development, Administration, Information Delivery - Aditorium 2
Title: Feel at Home in Power BI Online
Abstract: This session is all about demystifying what you can and can’t do in powerbi.com, my goal is to give you an overview of all the features you have available on powerbi.com from content organization to real-time analysis.
A lot of best practices and tips to be shared though the session.
Speaker(s):
- Rui Romano
Track and Room: BI Platform Architecture, Development, Administration, Information Delivery - Aditorium 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.
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.
Gabi Münster
Twitter: - @SQLMissSunshine
LinkedIn: Gabi Münster
Gabi Münster is working as a Business Intelligence consultant and team lead and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, and Master Data Services, as well as project management into the community as a regional PASS Local Group lead. She is also passionate about motivating other women to start a technical career and therefore initiates and supports “Women in Technology” events. Apart from SQLSaturdays, she also spoke at SQLBits, SQL Nexus, Tuga IT, and 2015’s and 2017’s PASS Summit. In October 2017 Gabi received her first Data Platform MVP award.
Gabi Münster
Twitter: - @SQLMissSunshine
LinkedIn: Gabi Münster
Gabi Münster is working as a Business Intelligence consultant and team lead and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, and Master Data Services, as well as project management into the community as a regional PASS Local Group lead. She is also passionate about motivating other women to start a technical career and therefore initiates and supports “Women in Technology” events. Apart from SQLSaturdays, she also spoke at SQLBits, SQL Nexus, Tuga IT, and 2015’s and 2017’s PASS Summit. In October 2017 Gabi received her first Data Platform MVP award.
Pedro Reis
LinkedIn: Pedro Reis
Contact: https://www.aboutpowerbi.com
Pedro is a Microsoft BI Stack Professional and enthusiast. Co-Founder and Leader of the Power BI Portugal Meetup group and the Porto Power BI User Group. Speaker at events like Power Platform World Tour, SQLSaturday, Porto Data and meetups. Key areas of expertise and passion: Power BI, SSAS, Excel and DAX.
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.
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.
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/
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.
Andrew Pruski
Twitter: - https://twitter.com/DBAFromTheCold
LinkedIn: Andrew Pruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year’s experience. Originally from Wales but now living in Ireland
Dennes Torres
Twitter: - Dennes
LinkedIn: Dennes Torres
Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/
Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.
Sponsors
The following is a list of sponsors that helped fund the event: