SQLSaturday 546

Oporto, Portugal

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. 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, and most costs are covered by donations and sponsorships. At some events you will have the option to pay for lunch at the time of registration. Please register soon as seating is limited, and let friends and colleagues know about the event.

More Information

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.

Objectives

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

Abstract

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.

Objectives

(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

Contact

Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us


Back to Top