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 by Michael K. Campbell

AlwaysOn Availability Groups and SQL Server Jobs, Part 16: Job Synchronization Checkup Logic

With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability....More
Abstract illustration of linked SQL Servers

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on....More
SQL Server Availability Groups screenshot

AlwaysOn Availability Groups and SQL Server Jobs, Part 14: Establishing Synchronization Checks

When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a....More
Woman sitting on her desk in office

AlwaysOn Availability Groups and SQL Server Jobs, Part 13: Creating and Populating a Batch Job State Table

Get a detailed look at some simple mechanisms that can be used to track the state of SQL Server Agent Jobs being used as Batch Jobs against SQL....More
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

Sponsored Introduction Continue on to (or wait seconds) ×