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.