Incremental Index Maintenance with T-SQLCommented on: 3 years ago
(February 28, 2012)
Nice work.... You must have been reading my mind, we currently are pledged by Index Fragmentation a crossed all DBs... This is why every DBA needs to have SQL Server Pro (www.sqlmag.com) as your home...
Visual Studio LightSwitch’s True Target AudienceCommented on: 3 years ago
(August 4, 2011)
Although your users or your thoughts of users are as stated, that they know nothing about what applications are or what goes into making themlet alone knowing how to build one themselves, is simply...
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