Blog

I needed a place to express myself, share my discoveries and reach more people. Here you are!

SSIS – Create Environment from Packages variables

SSIS – Create Environment from Packages variables

I created this script to automate some "not funny" tasks with our SSIS Catalog. If you have several SSIS projects configured in project mode (with a project.params file), when deploy them on your servers you unfortunately have to manually create the different...

Pie Chart is bad!

Pie Chart is bad!

      During my presentation at Power Saturday in Paris, I wanted to demonstrate to an already very optimistic public that Power BI is a great tool and that modeling is a must-have for their reports. (Data Modelling is not the subject here) Power BI a super tool? Yes,...

SSMS – Query Shortcuts : Feel like a superman developer

SSMS – Query Shortcuts : Feel like a superman developer

SSMS Query ShortcutDear BI Developer, I’m pretty sure you would be happy to improve your productivity. If not, you should at least read this article to look like a superman (superwoman) developer.When I start a new mission, the first thing I do is to set up SSMS (SQL...

SSIS – Log Execution time

SSIS – Log Execution time

This query helps you to have a better view of your SSIS Packages executions. When you run a "master job / package", you don't clearly see the execution time for your child packages in SSISDB Reports. With this query, now it's possible 🙂 USE SSISDB GO SELECT...

PowerBI – Bookmarks

PowerBI – Bookmarks

Bookmarks are not perfect, I can easily confirm you. But with them, you can build beautiful and rich reports. In this example, I will show you how your users can switch from one visual to another one.

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.