Powerbi

Presenting at SQL Saturday

I’ll be presenting my session on “How to use PowerBi as a Free monitoring tool” this Saturday in Parma.

Read More

Slides and materials for my session "How to use PowerBI as a Monitoring Tool" @ GroupBy.org

Good news everybody! As you may know if you follow me on Linkedin , I’ve been selected as one of the GroupBy Speakers for the last GroupBy session for 2019!

Read More

A PowerBI Report for SQL Server Agent Jobs

As my “community service” this month, I’ve worked on this neat (I hope!

Read More

Job Performance Analysis PowerBi Report coming soon

It will be part of the FirstResponderKit tool, free for all

Read More

Test: confronting various methods of bulk loading data from a table to another, what's the fastest?

 Most of the support request I get involved with can be summarized with the following keywords: “slow” + “datawarehouse” + “ETL” + “Save us” What about thinking about ETL performance before it goes bad?

Read More

Creating a Perfmon and Filestats reports in PowerBI [Part 1]

If you work for a big company, you may have a bunch of instances/databases under your control, you ran whatever monitoring tool has been provided and everybody is happy; But if your’re like me and you’re working for a big number of customers, each one with a different version of SQL and own configuration/security policies, with no monitoring tool directly available, and have to answer the question “what happened to the instance the other night” you may be a little bit overwhelmed.

Read More