Warwick Rudd is a Microsoft Certified Master – SQL 2008, MVP, MCT and the Principal Consultant at SQL Masters Consulting (http://www.sqlmastersconsulting.com.au). Warwick is a frequent speaker at local SQL Server User Groups and SQL Saturday events in Australia and New Zealand. You can find Warwick online with his blog (http://www.sqlmastersconsulting.com.au/blog) or on Twitter (@Warwick_Rudd). When he is not playing with the SQL Server Stack, he likes to get away to the cold and spend time snowboarding.
SQL Server's AlwaysOn Availability Groups provide a very resilient way of providing High-availability for SQL Server databases, but there are inevitable limits to their capacity. How many databases can you reasonably add? It depends on the resources available and the workload, but you can come up with a reasonable estimate as Warwick Rudd explains… Read more
High Availability (HA) and Disaster Recovery (DR) can be provided for subscription databases from an AlwaysOn Avaliability Group, but the secondary replicas will need to be manually configured to create the new subscriptions… Read more
SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has been around in SQL Server for quite some time and allows you to scale out your environment. Warwick Rudd explains how to join these technologies together
… Read more
It is likely that you'll want to add a database with TDS Encryption to your AlwaysOn Availability Group. If you do so you'll find that you can't use the SSMS wizard to do so. So, how do you achieve it? Read on...… Read more
SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It makes use of existing SQL Server features, particularly Failover Clustering, and provides new capabilities such as availability groups. Warwick Rudd explains the basics and shows you how to implement it.… Read more