By Michael K. Campbell, 05/25/2012
In part 9 of this series on SQL Server database corruption I defined a list of key things to do when responding to database corruption. And in that list of options and operations ...
By Michael K. Campbell, 05/23/2012
Michael K. Campbell explains why he's tired of hearing about sexism in the IT industry.
By Michael K. Campbell, 05/23/2012
Ensuring a proper understanding of core concepts and avoiding common pitfalls are the keys to protecting against SQL injection.
By Michael K. Campbell, 05/18/2012
In my previous post in my ongoing series on SQL Server database corruption I covered a list of best practices for responding to database corruption when it happens. In that post I ...
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 ...