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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×