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

Feb 11, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular....More
Jan 22, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked....More
Dec 02, 2014

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
Nov 18, 2014

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
Nov 11, 2014

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
Nov 04, 2014

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
Oct 30, 2014

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
Oct 22, 2014

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
Oct 09, 2014

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
Oct 07, 2014

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

Sponsored Introduction Continue on to (or wait seconds) ×