The premise of this webcast is based on my conversations with customers who wanted to implement SQL Server 2012 Availability Groups. There have been a lot of confusion about the terminologies, technologies and implementation ever since Availability Groups was introduced in SQL Server 2012. This webcast seeks to explain the underlying fundamentals behind Availability Groups. You […]
PostAlways On Readable Secondaries: That Extra 14-bytes In Your Record You Didn’t Know About
– “Progress comes at a price.” Edwin Sarmiento- I’ve responded to customers’ inquiries about the benefits of implementing SQL Server 2012 Always On Availability Groups since Microsoft released a public CTP of “Denali.” I’ve delivered presentations, written articles, prepared proof-of-concept designs and even recorded a video on this topic. While it may be a new […]
PostAre you switching to BULK_LOGGED recovery model? Know your risks.
For years I have been led to believe that using the bulk-logged recovery model for SQL Server databases was a safe place to be in (that was entirely my fault, not MSDN’s nor TechNet’s.) I took it upon myself the definition of this recovery model – MINIMAL log space is used by bulk operations. My […]
PostDeploying a SQL Server 2012 Multi-Subnet Cluster
I’ve been wanting to write a series of articles on deploying a SQL Server 2012 on a multi-subnet cluster for quite some time now. This was driven by the fact that my series of articles on SQL Server 2008 Failover Clustering had been in the Top 10 Tips for more than 2 years since being […]
PostSQL Server 2012 High Availability Webcast Resources Now Available
There have been requests from attendees of last week’s webcast to make the resources available for download. If you’ve attended or viewed (thru MSSQLTips.com’s recording) my webcast on SQL Server 2012 High Availability with AlwaysOn, you can download the resources – Windows-based client application together with the Visual Studio 2010 project files, batch files to […]
PostWatch Out for SQL Server 2012 AlwaysOn Webcast
My friends at MSSQLTips.com asked me to do a webcast on SQL Server 2012 AlwaysOn Availability Groups. You’ve probably noticed that I have not been writing anything about SQL Server 2012 (formerly “Denali”) from both the articles that I’ve been writing and the previous blog posts as compared to when SQL Server 2008 was being […]
PostDisaster Recovery Is More Than Just Technology Part 2: The Alphabet Soup
In my previous blog post, I talked about high availablity and disaster recovery (HADR) and how it is more than just the underlying technology that keeps the entire strategy intact. In this blog post, I’ll describe a few acronyms – sometimes called buzzwords – that are commonly referred to in HADR projects and implementations (I […]
