Eitan Blumin

Information & Communications Technology

Microsoft Data Platform Azure Data Platform Microsoft (Azure) Data Platform SQL Server Microsoft SQL Server Azure SQL Server

Rishon LeẔiyyon, Central District, Israel

Eitan Blumin

The fastest DBA alive

Eitan Blumin is a Microsoft Data Platform MVP with decades of experience in all fields relating to Microsoft SQL Server databases and the Microsoft Data Platform.

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.

Eitan Blumin

ה-DBA הכי מהיר במערב

איתן בלומין הוא MVP בתחום ה-Microsoft Data Platform, בעל עשורים של ניסיון מקצועי באמתחתו בכל מה שקשור לבסיסי נתונים של SQL Server בפרט, וב-Microsoft Data Platform בכלל.

איתן עובד כיועץ בכיר, ארכיטקט פתרונות, וראש צוות DBA בחברת Madeira Data Solutions, חברת הייעוץ המובילה בישראל בתחום ה-Microsoft Data Platform.
חוץ מעבודת הייעוץ היום-יומים שלו, איתן גם פועל כשדרן בפודקסט הפופולרי "רדיו SQL Server" לצידו של גיא גלנצר, כותב מאמרים מקצועיים עבור קהילת ה-SQL Server בעולם, מעביר הרצאות וקורסים מקצועיים בתחום, ומתפקד כמקור ידע מרכזי עבור צוות היועצים בחברת מדירה.


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.

When I heard the call for Microsoft Data Platform speakers, I knew I had to step up. But with time, I realized that I'm the only one fast enough to deliver the right sessions that you really need.

I am... The Flash I mean Eitan Blumin.

Current sessions

Performance Monitoring with Azure SQL Analytics EN HE

Do you have Azure SQL Databases or Managed Instances? Are you looking for database performance monitoring solutions without going broke or implementing your own? Look no further than to the Azure SQL Analytics solution. Join Eitan to see how to get started and see a live demo.


Dynamic Search Queries in T-SQL - The Ninja way EN

What is the solution for implementing truly dynamic search queries? Not just a stored procedure with optional parameters, but something even more dynamic than that? Let the end-user choose the exact fields and, more importantly, the operator types to use on them, in order to get the results that they need. And how do you achieve this level of dynamic interactivity without risking SQL injection? This presentation will answer these questions and give you a solution involving some advanced T-SQL martial arts!

More info here:
https://eitanblumin.com/portfolio/advanced-dynamic-search-queries/


Development Lifecycle Basics for DBAs EN

What is source control? What is version history? What are unit tests? What do CI and CD even mean, and what the heck is an Artifact?? In this new era of Agile development, DevOps, DataOps and other weird buzzwords, we the DBAs gotta learn to keep up. It's time to add our monstrous database into the continuous integration pipeline. But first, we need to know what we're going into and need to familiarize ourselves with the terms and methodologies of the world of software development lifecycles.

More info:
https://eitanblumin.com/portfolio/ci-cd-ssdt-development-lifecycle-basics-dbas/


SSDT Methodologies for SQL Server DevOps EN HE

In this session, we will cover the concepts and methodologies in SSDT that allow DBAs to implement a continuous database development lifecycle.

SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD - SSDT has it all - and it's completely free!

More info here:
https://eitanblumin.com/portfolio/ci-cd-ssdt-methodologies-for-db-devops/


How to HADR Your SQL Jobs EN HE

You have a couple or more SQL Servers with some sort of High Availability solution between them (AlwaysOn Availability Groups, Database Mirroring, etc.). You also have a bunch of scheduled jobs which you need to be run on the Primary server.

But wait…. How would you make these jobs run only on the Primary server? After all, if they try to run on the Secondary, they might fail (whether because the database is inaccessible or because it’s read-only). Additionally, you would need to consider a failover where the Primary and Secondary servers would switch roles.

This means that you would have to create these jobs on both servers, and then implement some sort of mechanism that would detect, for each job, whether the instance it’s being executed at is currently the Primary.

There are a few ways to go about doing this. During this session we will cover possible solutions, downfalls, tricks, and much more.


How to HADR Your SQL Jobs EN HE

You have a couple or more SQL Servers with some sort of High Availability solution between them (AlwaysOn Availability Groups, Database Mirroring, etc.). You also have a bunch of scheduled jobs which you need to be run on the Primary server.

But wait…. How would you make these jobs run only on the Primary server? After all, if they try to run on the Secondary, they might fail (whether because the database is inaccessible or because it’s read-only). Additionally, you would need to consider a failover where the Primary and Secondary servers would switch roles.

This means that you would have to create these jobs on both servers, and then implement some sort of mechanism that would detect, for each job, whether the instance it’s being executed at is currently the Primary.

There are a few ways to go about doing this. During this session we will cover possible solutions, downfalls, tricks, and much more.


SSDT Methodologies for SQL Server DevOps EN HE

In this session, we will cover the concepts and methodologies in SSDT that allow DBAs to implement a continuous database development lifecycle.

SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD - SSDT has it all - and it's completely free!

More info here:
https://eitanblumin.com/portfolio/ci-cd-ssdt-methodologies-for-db-devops/


Performance Monitoring with Azure SQL Analytics EN HE

Do you have Azure SQL Databases or Managed Instances? Are you looking for database performance monitoring solutions without going broke or implementing your own? Look no further than to the Azure SQL Analytics solution. Join Eitan to see how to get started and see a live demo.


SSDT Tools and Features for SQL Server DevOps EN HE

Meet SSDT (SQL Server Data Tools), that comes with the SQL Database Project as an effective tool for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD: SSDT comes with an answer for all.

In this session, the 3rd of a multi-part series, we will cover the rich tools, features, and concepts in SSDT that allow DBAs to implement a continuous database development lifecycle. We will also learn about solutions to common fears and objections coming from naysayers, common problems while starting with SSDT for the first time, and various problematic edge cases and how to solve them.

SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD - SSDT has it all - and it's completely free!

More details here:
https://eitanblumin.com/portfolio/ci-cd-ssdt-tools-and-features-for-db-devops/


SSDT Tools and Features for SQL Server DevOps EN HE

Meet SSDT (SQL Server Data Tools), that comes with the SQL Database Project as an effective tool for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD: SSDT comes with an answer for all.

In this session, the 3rd of a multi-part series, we will cover the rich tools, features, and concepts in SSDT that allow DBAs to implement a continuous database development lifecycle. We will also learn about solutions to common fears and objections coming from naysayers, common problems while starting with SSDT for the first time, and various problematic edge cases and how to solve them.

SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD - SSDT has it all - and it's completely free!

More details here:
https://eitanblumin.com/portfolio/ci-cd-ssdt-tools-and-features-for-db-devops/


How to Save Money on Your SQL Server Hardware EN HE

Having a production machine with SQL Server in your organization is no cheap feat. Significant costs could accumulate due to expensive hardware and licensing.

How could we find whether our SQL Server machine is wasting your money? What are common pitfalls? How to detect them and how to remedy them?

Learn all this and more in this session.


How to Save Money on Your SQL Server Hardware EN HE

Having a production machine with SQL Server in your organization is no cheap feat. Significant costs could accumulate due to expensive hardware and licensing.

How could we find whether our SQL Server machine is wasting your money? What are common pitfalls? How to detect them and how to remedy them?

Learn all this and more in this session.