Eitan Blumin is a SQL Server Generalist consultant with decades of experience in all fields relating to Microsoft SQL Server databases (since the year 2005), including but not limited to: Database design, management, TSQL programming, performance tuning, replication, backup management, security management, high availability and disaster recovery, SSIS, SSRS, encryption, migrations and more.
Eitan Blumin is currently working as a Senior SQL Server Consultant and Team Leader at Madeira Data Solutions. 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.
Eitan is also a Microsoft certified professional with MCSE and MCSA certificates. You can view all of Eitan’s Microsoft certificates here.
SQL Server Radio Podcast
Starting early 2020, Eitan has also started co-hosting the SQL Server Radio podcast.
Latest Blog Posts
- Control SQL Jobs based on HADR Role – Taking it to the Next LevelIn one of my previous blog posts, Automatically Enable or Disable Jobs based on HADR Role, I provided a solution for managing scheduled jobs correctly in combination with Availability Groups and Database Mirroring. In this blog post, I’m going to build upon my previous solution and improve it even further – taking it to the next level of automation!
- #tsql2sday 126 – Responding to COVID-19This month’s #tsql2sday is hosted by the legendary Glenn Berry, and asks us about what we’ve been doing as a response to COVID-19. We at Madeira Data Solutions did quite a lot to chip in during these difficult times. Hopefully, it’s enough to make some kind of difference.
- The new “metadata-only column changes” feature in SQL Server 2016 is useless!You might have seen the blog post by Paul White: New Metadata-Only Column Changes in SQL Server 2016. It talks about how, when a table is compressed, you can change (i.e. increase) a column’s data type without having to create a new table and migrate the data into it, and without having to refactor all of the underlying data. But, not everything is rainbows and unicorns…
- Webinar – Development Lifecycle Basics for DBAs at the Data WeekenderThe #DataWeekender is a free online conference scheduled for May 2nd, organized by the SQL Server community’s finest, as an online replacement for all the SQL Saturdays and other SQL Server conferences that were being canceled en masse due to the COVID-19 situation. I am also a speaker in the event, and I’ll be presenting my Development Lifecycle Basics for DBAs webinar!
- T-SQL Tuesday 125 – Getting started with database unit testingThis month’s #tsql2sday is hosted by Hamish Watson and this time touches on the extremely important topic of database unit testing. Its high importance and value should be a no-brainer. But it can be a very difficult topic, and the hardest thing about it, in my opinion, is knowing where to start. Hopefully, with this blog post, I can help you out with that.
- Troubleshooting Long-Running SHRINK OperationsEver wondered what makes your SHRINK go so damn slow? It’s more common than you think, and not impossible to solve!
- May 2020 (3)
- April 2020 (3)
- March 2020 (3)
- February 2020 (2)
- January 2020 (2)
- December 2019 (4)
- November 2019 (1)
- October 2019 (1)
- September 2019 (3)
- May 2019 (3)
- April 2019 (1)
- January 2019 (2)
- November 2018 (6)
- October 2018 (14)
You can also find Eitan Blumin in these networks: