Michael K. Campbell

Michael K.

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.

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
Nov 3, 2015

Climb the Steps Toward Data Quality Success

Melissa Data's Data Quality Analyst Joseph Vertido explains how Gartner defines the critical data quality steps to prevent bad data from entering your systems in the first place, and then keep it clean over time....More
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 protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....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) ×