Most Recent Blog Posts

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....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups2

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular....More
Sep 01, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')        ....More
Aug 27, 2015

A Replacement for Maintenance Plan Backups1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part....More
Aug 19, 2015

Looking forward to Containers1

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things....More
Jul 28, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs....More
Jul 06, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations....More
Jul 01, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL....More
Jun 10, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 26: Using Master Servers for Job Administration

When I initially decided to write about AlwaysOn Availability Groups and SQL Server Jobs, I knew I’d have a bunch of different posts on a....More
May 28, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 25: Final Remarks on Backups

In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage....More
May 18, 2015

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,....More
May 13, 2015

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....More
Apr 28, 2015

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....More
Mar 17, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 21: Assigning Backup Preferences

An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences. It’s also something you can easily configure once....More
Mar 12, 2015

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....More
Contributors

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...
What's Practical SQL Server?

Practical advice, insight, and help for core SQL Server considerations.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×