SQLSaturday 546

Oporto, Portugal

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Oct 01 2016 at ISEP, Rua Dr. António Bernardino de Almeida, 431, Porto, Porto, 4249-015 Porto, Portugal

Register Now

Welcome to SQLSaturday

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.

And like the two past events all the sessions will be in English, and we will have national and international speakers.

Besides free event, we are bringing you two magnificent paid workshops:

SQL Server Professional Configuration & Optimisation Workshop

 The DBA tasks have become increasingly important, in terms of installation configuration and maintenance, in order to mitigate performance issues and availability of our DBs to our customers. Today a DBA should be more than one operator and must join the "skills" of a analyst and (problem solver) troubleshooting.


Key objectives are:
(a) Sharing the SQL Server Installation & Configuration Best Practices from over 25 years of combined Database Experiences
(b) Introduction to the RapidConfig Script that allows you to configure your instances 
(c) Easy Performance Optimisation Technics guide

Contents/Topics covered in the workshop:
- Analysis of the infrastructure in the terms of the Hardware ( DiskSPD, CPU-Z .... )
- Installation of SQL Server Engine/SSIS/SSRS/SSAS
- Services Configuration according to our professional experiences
- Monitoring Tools Configuration
- Performance Tools Load Testing ( HammerDB )
- Processes and queries monitoring
- Execution Plans analysis
- Trace vs Extended Events
- PAL & PerfM 

This is a incredible workshop guided by Niko Neugebauer and André Batista.

Implementing Modern BI Solutions


This main objective of this workshop, is to share real world experience implementing a BI solution, starting from the basic concepts until real problems that is not written and explained in the books. The tools used in this workshop are SQL Server (SSIS, SSAS and SSRS), Excel and Power BI in the latest versions. At the end, the beginner attendees should be prepared to create a BI solution from the scratch, and more advanced attendees should be prepared to improve existent BI solutions.


(a) Know how to implement a BI solution
(b) Understand the best practices to follow on the key steps
(c) Know tips & tricks from real world scenarios experience

This is a workshop that will cover the main BI tools in SQL Server 2016 guided by Pedro Perfeito.

Event Location

Event news

No Event News entered. Please come back later and check again


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids