Shilpa Shah is a Sr. Data Architect at Ovation Research Group where she is responsible for designing, building, and maintaining project databases in SQL Server and developing applications using SQL Server and ASP.NET.
Microsoft Visual SourceSafe is a great tool to use to centrally manage file version control. It also helps to simplify common tasks such as code reviews, project management, source-code change auditing, and backups.
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
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