Latest Topics
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 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 ShortcutDear BI Developer, I’m pretty sure you would be happy to improve your productivity. If not, you should at least read this article...
My discoveries: Useful links and articles regarding Microsoft Data Plaform
My discoveriesI always wanted to start a blog post with my discoveries on the internet. It’s often the case, and I hope you use it a lot, we are...
L’agenda est en cours de construction pour le club Power BI de Lille...
N’hésitez pas à faire signe ! https://t.co/5bZtxHmloC
L'été approche, mais la nouvelle saison du #ClubPowerBI se prépare ! Nous avons toujours besoin de nouveaux contributeurs désireux de partager leur expérience sur l'outil. Que ce soit sur Paris, Lille, Aix, Lyon Marseille ou Nantes, n'hésitez plus !
When you find a customer, client or team member suggesting that you use an Analysis Services model (MD or Tabular) as the data source for bulk ETL (#PowerBI #dataflows or otherwise) you should always be skeptical, and always know what you're getting into.
https://t.co/gD8W4xy3Kg
Enjoyed the #PowerBIdays in Kontich yesterday! Learned a lot from speakers @JanMulkens @DataSharona @elsdestickere @Laura_GB @IdaBergum @thesqlgrrrl @LazySna1l @KristofferWest
Previous Topics
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 :)...
How to create a database in Azure
Look how it's easy to create a database in Azure! 3 Clicks, 5 minutes and you get a database
Power BI – PowerApps – Microsoft Flow: Do more with your data
Example in this tutorial: Analyse and pick up one of your clients, send him by mail to your account manager and ask them to take contact. (Power BI can do the job!)
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.
Docker: SQL Server 2019 Container
Azure Storage Explorer: Manage your Blob files
Azure File Storage – Share Drive
Azure Blob Storage and Power BI – Quick Tips
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....
Update Power BI Desktop : More information with less visuals ? Let’s use the Tooltip !
*This post is an update to the video about the Tooltip* It can be sometimes very difficult to put all the information we need in only one report page. Maybe I could remove this visual to add this one instead? But then, I won't have the figures for this year. Maybe...
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!
