About

My name is Eitan Blumin, and I’m the fastest DBA alive. To the outside world, I am an ordinary SQL Server DBA. But secretly, with the help of my friends at Madeira Data Solutions, I fight performance, availability, and security problems no other person can solve, and find other DBAs like me.
I am… ~~The Flash I mean~~ Eitan Blumin.

Eitan Blumin is a SQL Server expert with decades of experience in all fields relating to Microsoft SQL Server databases and the Microsoft Data Platform, including but not limited to: Database design, development, administration, performance tuning, security and encryption, high availability and disaster recovery, ETL, reporting, migrations and upgrades, change automation, and more.

Eitan Blumin is currently working as a Senior SQL Server Consultant, Solutions Architect, and DBA Team Leader at Madeira Data Solutions, the leading Microsoft Data Platform consulting company in Israel. Other than his day-to-day consultant work, he also co-hosts the popular “SQL Server Radio” podcast with Guy Glantser, writes professional materials for the SQL Server community, delivers professional presentations and courses, and serves as a pivotal source of expert knowledge for the Madeira team.

Certifications

Since September 1, 2020, Eitan is a Microsoft Data Platform MVP.

Since December 1, 2020, Eitan is a Microsoft Certified Azure Data Engineer Associate.

Oמ March 25th, 2021, Eitan has also passed the Azure Data Fundamentals certification:

Eitan is also a Microsoft certified professional with MCSE and MCSA certifications.

You can view all of Eitan’s Microsoft certifications here

SQL Server Radio Podcast

Starting early 2020, Eitan started co-hosting the SQL Server Radio podcast.

Latest Blog Posts

The Simplest Alternative to sp_MSforeachdb2021-08-05
Which drawbacks are there to using the built-in sp_MSforeachdb stored procedure? What other alternatives are out there? Is there a simpler solution? Find out all this and more in this short post.
Finding a use for Extended Properties in SQL Server2021-07-27
“Extended properties allow you to add custom properties to database objects”, so says the official Microsoft documentation. However, very few DBAs make use of them, if at all. This is actually a good thing, because indeed the scenarios in which this feature could be useful are relatively few and rare. On the other hand, I […]
The Asynchronous Ledger Trick for Fast SQL Server Insert, Update and Delete Processes2021-07-14
Do you find yourself facing performance problems and long lock chains caused by very frequent INSERT, UPDATE, or DELETE statements being executed on a table? Check out this neat trick that could help you out and make all the difference in the world.
Even more fun with DATETIME arithmetics!2021-06-17
In one of my previous posts, Fun with DATETIME Arithmetics, I introduced a way to use “math” to manipulate datetime values for effectively generating, calculating, and displaying intervals (i.e. difference between two datetime values). These mostly work with the addition and subtraction operators (+, -). In one of the paragraphs, I mentioned multiplication and division, […]
One handy Powershell script template to rule them all2021-06-08
If you know me, you already know that I’m a huge fan of automation. Therefore, it’s natural to assume that I would dabble in Powershell at least once or twice or a few dozen, as a method to implement useful automations. After all, automation is pretty much the whole essence of Powershell in the first […]
T-SQL Tuesday 138 – sp_help_revlogin is dead, long live sp_help_revlogin22021-05-11
This month’s #tsql2sday is hosted by @AndyLeonard, who asks us to write about “software changes”. Well, I think it’s time to be changing sp_help_revlogin. What do you think?