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

T-SQL Tuesday #150 – My First Tech Job2022-05-08
This month’s #tsqltuesday is hosted by Kenneth Fisher (b|t), who wants us to share stories about our first tech job (or first job ever if it makes for a good story). My first job ever was delivering a magazine door-to-door in one neighborhood. It doesn’t actually make for a good story as it’s pretty bland […]
Monitoring Heartbeats in SQL Sentry2022-04-18
SQL Sentry uses a service to monitor targets. But what if this monitoring service is down? Who will alert about the alerter not alerting? Who is watching the watchers? Who is monitoring the monitor?
I got the Power: Remote Execution using Powershell and SQL Server2022-03-29
As part of my journey to get better at Powershell, I gave myself a task: Create a project utilizing Powershell at its core, to solve a complicated problem as elegantly as possible. A complicated problem indeed presented itself: How to remotely control multiple computers without having to log into them? Make them perform any task that could possibly be needed? Control them from one central location? And make the solution as easily scalable as possible? I present to you, the Framework for Remote Execution using Powershell and SQL Server!
Filtered Indexes with TRY_CONVERT, ISNUMERIC, and other complex expressions2022-03-10
Who doesn’t like Filtered Indexes, am I right? They’re pretty great, honestly. If… of course… you’re able to actually create them and utilize them in your specific use cases. That… unfortunately, could often become a complicated, if near impossible, task. So, what if our use case is not trivial enough to allow for filtered indexes?
Detect Weak Passwords in SQL Server2022-02-01
This is a T-SQL script that I’m cross-publishing with the official Madeira Data Solutions blog. This script generates various permutations and variations of common and weak passwords and uses the PWDCOMPARE function to check whether there are any enabled SQL logins that have these passwords.
Detect Low PAGE Compression Success Rates in all Databases2022-01-17
Thanks to Paul Randal and his recently published blog post: “The Curious Case of… tracking page compression success rates“, I finally discovered what was the purpose of the column page_compression_success_count from the system function sys.dm_db_index_operational_stats, and how to use it.