Latest Topics
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
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...
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...
Previous Topics
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 searching for information on a search engine. 2 months later (sometime less), we face the same issue! Excepted if you are...
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....
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!
