top of page
My Session in SQLBits 2023
Today I had the honor to present my session in SQLBits 2023. I promised to make all the session materials available for download...
Guy Glantser
Mar 17, 20231 min read
The Pitfalls of Using System-Named Constraints in SQL Server
This article was published by Aaron Bertrand a few years ago, talking about system-named constraints in SQL Server. The article mostly...
Eitan Blumin
Mar 14, 20236 min read
Azure data factory - clear out the garbage
On Azure data factory with GIT, sometimes old versions are left on live mode, here is how to delete them.
Chen Hirsh
Feb 28, 20231 min read
The downfall of Big A** Numbers
A few days ago, I had a conversation with a colleague about Data Visualization. I explained that in data visualization, it is the...
Rita Fainshtein
Feb 27, 20232 min read
Data Factory - Move files to time folder structure
Use Azure data factory to sort files to time hierarchy partitions.
Chen Hirsh
Feb 26, 20233 min read
Drop All Redundant Indexes In Every Database All At Once
Redundant indexes in SQL Server are a phenomenon that is more common than I'd like to admit. I see it in quite a lot of shops. Meaning,...
Eitan Blumin
Feb 23, 20238 min read
The wind of change - change data capture in data factory
Using Change data capture new (preview) feature in Azure data factory
Chen Hirsh
Feb 10, 20233 min read
Graph from the "don't try this at home" drawer or a story about ...
Graph from the "don't try this at home" drawer or a story about how the user sometimes doesn't know what he needs. Several years ago, I...
Rita Fainshtein
Feb 1, 20232 min read
Working with templates in Azure data factory
Pipeline templates in Azure data factory can save you time when creating a complex pipeline, and enable you to use code already developed by
Chen Hirsh
Jan 28, 20231 min read
A picture in PowerBI is worth a thousand words
There are 2 ways to integrate images into PowerBI, each with Pros and Cons.
Chen Hirsh
Jan 24, 20231 min read
bottom of page