Is Failure an Option?Commented on: 4 years ago
(October 12, 2010)
Kalen D - my SQL Swami. On target indeed.
Could Piracy Limit Sources of SQL Server Help?Commented on: 5 years ago
(March 16, 2010)
Yeah, I agree with Marcos. If I hadn't stolen my car I wouldn't be driving today. If I hadn't metaphorically broken into Kalen's home and robbed her I wouldn't have landed a good job and have a...
Temporal HistogramsCommented on: 7 years ago
(May 3, 2008)
Quite useful, although I'd love to see a generic solution that would work on SQL8 as well. I realize that SQL10 is here, nevertheless SQL9, but I'd like to point out that many, many companies still...
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