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
Mar 14, 2015
Commentary

For Data Quality, Intelligent Rules Add Value to the Golden Record 4

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Mar 12, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 20: Avoiding Backup Fragmentation

On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....More
Mar 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 19: Availability Group Database Backups

One of the biggest strengths of AlwaysOn Availability Groups is that they allow DBAs to address both high availability and disaster recovery concerns from a single set of tooling or interfaces. But, this doesn’t mean that you won’t still need 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) ×