Latest Topics

Management Studio – Faster with multiple select

Management Studio – Faster with multiple select

In SQL Server Management Studio (SSMS for close friends) but also in a multitude of text editors (such as Notepad++ for example), you can make multiple selections. I thought it was something everyone knew, but I realize that I often look like a magician every time I...

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!

      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...

Power Saturday – Paris

Join us in ParisYou can register on http://powersaturday.com   L'agenda du #PowerSaturday est (presque) finalisé. #Data #PowerBI #O365 #SharePoint #PowerPlatform Vous pouvez vous inscrire à l'événement : https://t.co/1A9wg84DcL@ClubPowerBI @GUSS_FRANCE...

Previous Topics

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 :)...

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.

SSIS – Export SSIS Catalog Environments

SSIS – Export SSIS Catalog Environments

You need to: Export your SSIS Environments (Variables) Replicate it on your new server Assign these variables to your new project SSIS Catalog is not complex, but we don't really want to spend our time to copy manually our configuration from one server to another one....

Stay Up to Date With The Latest News & Updates

Hey you, lazy snail!!

I’m Arnaud Gastelblum, one of the other snails in the world. I’m a proud father of 2 children, and also a big fan of running. Data and the Microsoft ecosystem drive my work life but not only.

If you want to discuss SQL Server, Power BI, Azure, running or whatever, you are welcome!

Arnaud

Join The Newsletter

Follow Me

I would really enjoy talking to you! LinkedIn and Twitter are definitely a good place for exchange!