By Michael K. Campbell, 05/03/2012
Microsoft's Entity Framework and ORMs can provide developers with several different benefits. Learn how to leverage the benefits of an ORM correctly with Michael K. Campbell's ...
By Michael K. Campbell, 04/26/2012
In both of the sessions that I covered in SQL Server Pro’s eLearning Event entitled Practical SQL Server Improvements for Businesses, I made mention of additional context, ...
By Michael K. Campbell, 04/26/2012
Michael K. Campbell believes that Microsoft should change its public relations strategies for its products and platforms so that customers don't have to assume the worst.
By Michael K. Campbell, 04/21/2012
Discover insights, techniques, and resources for troubleshooting performance, connectivity, and other types of problems commonly encountered in SQL Server environments.
By Michael K. Campbell, 04/17/2012
In my recent SQL Server Pro Webcast (sponsored by Red Gate), I blurred through a number of details regarding how to Avoid 5 Common SQL Server Backup Mistakes. The event is/was ...
By Michael K. Campbell, 04/14/2012
In a previous post we looked at the importance of backups when it comes to dealing with logical (human or application caused) or physical (IO subsystem caused) corruption. In this ...
By Michael K. Campbell, 04/05/2012
Michael K. Campbell shares his thoughts on why Microsoft should change its Visual Studio strategy.
By Michael K. Campbell, 03/29/2012
In Part VII of this series on SQL Server Database corruption we touched upon how backups can be used as an additional means of early detection for corruption – by making sure to ...
By Michael K. Campbell, 03/22/2012
Michael K. Campbell discusses what Microsoft should do to make Windows 8 a powerful consumer device.
By Michael K. Campbell, 03/16/2012
In previous posts we looked at how to enable regular checks for corruption and how to set up alerts for IO subsystem problems when they occur. But, as covered previously, one of ...
By Michael K. Campbell, 03/07/2012
Previously we looked at how to set up alerts for cases where SQL Server encounters issues with the storage subsystem. Setting those up is a key component to staying alerted to ...
By Michael K. Campbell, 03/01/2012
Michael K. Campbell outlines the difference between snapshot, merge, and transactional replication to help you decide which solution is the best for achieving high availability ...
By Michael K. Campbell, 02/24/2012
Continuing on from our last post where we looked at setting up CHECKSUM verification as one means of helping more readily detect corruption early-on, we’ll now take a look at how ...
By Michael K. Campbell, 02/23/2012
In part three of this article series, Michael K. Campbell takes a look at database mirroring as a solution for achieving high availability. In addition, he'll discuss SQL Server ...
By Michael K. Campbell, 02/21/2012
In previous posts within this series, we’ve already looked at how you can’t really prevent corruption. Instead, in order to be able to better deal with corruption, you need to be ...
By Michael K. Campbell, 02/09/2012
In previous posts we touched upon an overview of what causes corruption and looked at ways to simulate corruption. In this post we’ll talk about more about corruption – in terms ...
By Michael K. Campbell, 02/02/2012
In part two of this article series on high availability, Michael K. Campbell outlines the benefits and negative implications of log shipping as a means for achieving high ...
By Michael K. Campbell, 01/30/2012
In my last post I provided an overview of what SQL Server database corruption is – and how it’s almost always caused by problems at the IO subsystem (or disk) level. However, ...
By Michael K. Campbell, 01/27/2012
When it all comes down to it there are really only two main things that DBAs need to worry about: making data available to the proper people, and making sure it’s inaccessible to ...
By Michael K. Campbell, 01/26/2012
In part 1 of this multi-part series, Michael K. Campbell provides an overview of high availability, and outlines clustering as a solution for achieving high availability with SQL ...