Michael K. Campbell

President, OverAchiever Productions

Michael K. Campbell is a contributing editor for SQL Server Pro and Dev Pro and is an ASPInsider. Michael is the president of OverAchiever Productions, a consultancy dedicated to technical evangelism, mentoring, and quality solutions. He specializes in SQL Server, ASP.NET, and related technologies. Michael has been a professional developer, web master, and production DBA for several well-known companies. He enjoys learning, problem-solving, teaching, and creating free videos for www.sqlservervideos.com.

Posts in Practical SQL Server view all

Young man working at a computer

AlwaysOn Availability Groups and SQL Server Jobs, Part 12: Issues with Enabling and Disabling Batch Jobs

An in-depth look at some of the concerns involved with enabling/disabling entire SQL Server jobs based upon whether they should be run, or not—and....More
Fort in the road

AlwaysOn Availability Groups and SQL Server Jobs, Part 11: A Fork in the Road

A quick overview of the pros and cons of dynamic detection at job execution time or the option of dynamically enabling/disabling jobs....More
business people around a table and laptop

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that....More
Man holding a piece of paper with the word GOTCHA

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting....More
iceberg

AlwaysOn Availability Groups and SQL Server Jobs, Part 8: Dynamic Detection Gotcha #1

Learn about why the option of dynamically detecting whether or not to run a SQL Server Job at execution time is quite a bit more problematic than you....More
detetecitve dressed in black looking at data

AlwaysOn Availability Groups and SQL Server Jobs, Part 7: Detecting Primary Replica Ownership

In my mind, there are two logical ways that you might want to have your code check to see if the Primary Replica of a given AG database is currently....More
Two women looking a man's computer monitor

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Exclamation marke on yellow road sign

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a....More
synchronize key on computer keyboard

AlwaysOn Availability Groups and SQL Server Jobs, Part 4: Synchronizing Server-Level Details

When setting up HA or HA+DR solutions with SQL Server AlwaysOn Availability Groups, it's critical to remember that the basic unit of failover in....More

AlwaysOn Availability Groups and SQL Server Jobs, Part 3: Defining Batch Jobs

I commonly find that many organizations will set up regular tasks to go out and delete abandoned carts—or shopping carts that haven’t been touched in....More
What's Practical SQL Server?

Practical advice, insight, and help for core SQL Server considerations.

Sponsored Introduction Continue on to (or wait seconds) ×