Microsoft Data Platform Azure Data Platform Microsoft (Azure) Data Platform SQL Server Microsoft SQL Server Azure SQL Server
Rishon LeẔiyyon, Central District, Israel
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.
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.
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.