Michael K. Campbell

Michael K.
Campbell

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.

Articles
ComponentOne LiveLinq
LiveLinq can help organizations improve LINQ performance, bolster scalability, and increase data-binding capabilities for rich applications.
SQL Server Comparison and Synchronization Tools 1
Red Gate Software’s SQL Compare 8.1 and SQL Data Compare 8.1, The Australian Software Company’s SQL Delta 5.0, and ApexSQL Comparison Studio 2008 provide differencing and synchronization of SQL Server objects, code, and data.
Review: SQL defrag manager 2.5 4
Use this product to quickly analyze indexes and automate index defragmentation.
Review: Toad for SQL Server
Here's an option if you're not satisfied with SQL Server Management Studio. With more features and smoother performance, it's a solid choice.
Maximize Storage Performance 5
If SQL Server’s performance is suffering, you may be considering new equipment. These techniques can improve performance without that expense.
Using SQL Server 2008 FILESTREAM Storage
Store BLOB data as files managed by the OS and reap the performance benefits now—with this walk-through of how to set up and configure SQL Server 2008’s FILESTREAM storage feature.
Miner3D 7.1
Deriving useful business intelligence from multidimensional data hasn't been easy—until now.
SQL Data Generator
For generating sample and testing data for SQL server databases, this product will win you over as quickly as it produces data.
SQL Compare 6.2
See why the author gives a thumbs-up to the new version.
blue hanging files labels secrets
Performance Secrets for SQL Server Developers 11
Avoid 10 common developer pitfalls with a little preparation.
Spotlight on SQL Server 5.7
Spotlight on SQL Server lets you see real-time SQL Server activity, making it easy for you to monitor the performance of your databases.
Hit Software's DBMoto 5.0
Check out DBMoto 5.0 if you're looking for a replication solution that's highly scalable and had been designed to help you move and copy data between heterogeneous database platforms.
When SQL Server Tool Vendors Compete, DBAs Win
Two data recovery solutions—Lumigent Technologies' Log Explorer and Red Gate Software's SQL Log Rescue—help you to isolate user errors, undo mistakes, and replay subsequent transactions after user accidents, but one costs nearly ten times more.
Shrink-Wrapped DBAs 1
Check out this comparative review of two hefty database-adminstration products, in which we examine how well Embarcadero Technologies' DBArtisan and Quest Software's Quest Central for SQL Server provide value to both experienced and less-skilled DBAs.
BMC’s SmartDBA
We weren't able to include SmartDBA in our comparative review. Here's how to find information about the product.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Jul 28, 2015
blog

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 – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More
Jul 6, 2015
blog

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 – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More
Jul 1, 2015
blog

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 Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×