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

Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular....More
Sep 01, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')        ....More
Aug 27, 2015

A Replacement for Maintenance Plan Backups

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part....More
Aug 19, 2015

Looking forward to Containers

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things....More
Jul 28, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs....More
Jul 06, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations....More
Jul 01, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL....More
Jun 10, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 26: Using Master Servers for Job Administration

When I initially decided to write about AlwaysOn Availability Groups and SQL Server Jobs, I knew I’d have a bunch of different posts on a....More
May 28, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 25: Final Remarks on Backups

In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage....More
What's Practical SQL Server?

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

Sponsored Introduction Continue on to (or wait seconds) ×