9 SQL Server ES Meeting: Power BI, Reporting Services, and Performance Tuning - 15 / 09 / 2018

Views: 142
Reading Time: <1 minute

Guys,
All beauty with you?

The 9th Meeting of the Local Group SQL Server ES is coming and it's very cool! This time we will have as speakers Fabrício Lima - MVP and me, Dirceu Resende.

This is a great opportunity to learn more about Power BI and Reporting Services, two competing Microsoft BI solutions, because they both do the same thing. Is it really that? In this talk, I will introduce both of these tools and demonstrate the strengths and weaknesses of each of them, helping you to define which one to use in your business and which scenarios.

Additionally, MVP Fabrício Lima will show us how to improve 7 real queries from a client in a Tuning consultancy. Let's discuss together the walkthrough that he followed and improve the query only with the creation of indexes, since it is a third party application and we cannot change the queries. This database had 800 GB of compressed data (more than 2 TB if it had no compression).

It will be an event with lots of content, networking and learning for everyone.

Make your registration free clicking this link here.

Event Details

Date: 15/09/2018 (Saturday)
Open Hours: 08: 30h at 11: 30h
Venue: Catholic University Center of Vitoria - Former Salesian Catholic College (link here)
Address: Victoria Avenue, 950, Fort St. John, Victoria, ES (view location)

The Salesian College, through Prof. Marcelo Albuquerque, embraced the community giving us full support. Remember that this event is open to the entire technical and academic community of Espírito Santo.

Event Schedule

ScheduleFitness centreDescriptionSpeaker
08:30-09:00Event Opening
09:00-10:10Power BI x Reporting Services: Who is better?In this talk, I will introduce Power BI (Reporting Services) and Reporting Services tools and demonstrate the strengths and weaknesses of each, helping you define which you should use in your business and which scenarios.Dirceu Resende
10:10-10:20Coffee Break and Networking
10:20-11:20Step by Step How I Tuned in 7 Real Queries from a ClientIn this talk I will show how I improved 7 real queries from a client in a Tuning consultancy. Let's discuss together the walkthrough that I followed and improve the query only with the creation of indexes, since it is a third party application and we cannot change the queries. This database had 800 GB of compressed data (more than 2 TB if it had no compression).Fabrício Lima
11:20-11:30Closure

See you there !!!