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.

Microsoft Certified: Azure Data Engineer Associate

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

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 Job
    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 Sentry
    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 Server
    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 expressions
    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 Server
    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 Databases
    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.

Archive

You can also find Eitan Blumin in these networks:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.