Logical Puzzle - 21 Dec 2004Commented on: 10 years ago
(January 3, 2005)
Both are correct. The powder is the easiest way to work it out. The halves theory is the easiest way to physically achieve the proper result. Honestly, I came up w/ the powder theory also but I'm...
All About RAISERRORCommented on: 10 years ago
(October 15, 2004)
The information is good but with most db developers, Query Anaylyzer is the tool of choice over osql. I've found that the utility of the RAISERROR command is when it's used with the WITH LOG option...
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