Read Only Routing Configuration UI
One of the big downsides to using the SQL Server 2012’s AlwaysOn Availability Group feature is that there is no UI to help you configure read only routing. Thankfully there is a fix for this. Denny Cherry & Associates Consulting is happy to announce the first of or AlwaysOn Tools which is the Read Only […]
SQL Server 2014 Standard Edition High Availability
With all the announcements about SQL Server 2014 this last week there have been a lot of questions about what’s going to happen for SQL Server 2014 and the non-shared storage High Availability options as we are now one step closer to database mirroring being removed from the product. You’ll see several blog posts coming […]
High Availability in SQL Server Standard Edition (or Semi-Lack Thereof)
SQ Server 2012 brought about some major changes to the various High Availability schemes supported by the product. The most major of these is the introduction of AlwaysOn Availability Groups. As described early in that MSDN article, these can be over-simplified summed up as “enterprise-level database mirroring.” This is not quite the same thing as […]