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

in Practical SQL Server 07/08/2014 (All day)

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and....More
Red restore key on computer keyboard
in Practical SQL Server 06/24/2014 - 12:53pm

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery....More
Young man smiling while working on computer
in Practical SQL Server 06/19/2014 - 6:01am

Stored Procedures: Still Relevant

Even if SQL Server database developers are totally committed to using ORMs, it's still worthwhile to assume that once you start storing lots of data....More
egg carton with missing brown egg
in Practical SQL Server 06/11/2014 - 1:04pm

Missing Indexes Correlated Against Execution Costs and Counts

Here's a query that every DBA should have in their toolbox....More
RoboCopy New Job Step screen shot
in Practical SQL Server 06/03/2014 - 3:05pm

Off-Box Copies of SQL Server Backups with RoboCopy

Check out what could be called a poor man's approach to getting copies of your SQL Server backups off-box and to a secondary or tertiary location....More
Time to start sign with clock and clouds in background
in Practical SQL Server 05/20/2014 - 1:16pm

SQL Server DBA Tip: One Time Schedules

Creating and using one time schedules represent a great way to verify if a job will work or not—without having to wait hours or days to see if you....More
New SQL Server Agent Job Step computer screen shot
in Practical SQL Server 05/13/2014 - 6:46pm

SQL Server DBA Tip: Credentials and Proxies

In situations where elevated permissions are needed to execute particular SQL Server jobs, or more importantly, steps within given jobs, a more....More
SQL Server Agent job graph
in Practical SQL Server 05/07/2014 - 6:05am

Finding SQL Server Agent Jobs Running at a Particular Time

I’m guessing I’m not the first person to come up with the need to try and correlate a problem or issue on a server against whether or not a SQL....More
Man with mustache at computer
in Practical SQL Server 04/23/2014 - 5:00am

SQL Server Management Studio 2014: Notes from the Field

SQL Server Management Studio is a complex application that does a ton of wonderful things and, with SSMS 2014, there are still a couple of quirks or....More
computer keyboard with blue save money key
in Practical SQL Server 04/15/2014 - 2:10pm

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches....More
What's Practical SQL Server?

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

Sponsored Introduction Continue on to (or wait seconds) ×