Click here to monitor SSC

Author Profile

Warwick Rudd

Warwick Rudd is a Microsoft Certified Master – SQL Server 2008, Certified Trainer and is currently 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. You can find Warwick online with his blog (http://www.sqlmastersconsulting.com.au/blog) or online at @Warwick_Rudd on Twitter. When not playing with the SQL Stack, Warwick likes to get away to the cold and spend time snowboarding.

AlwaysOn Availability Groups - What Not to do when Adding Databases

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...

Expanding AlwaysOn Availability Groups with Replication Subscribers

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...

Expanding AlwaysOn Availability Groups with Replication Publishers

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...

Encrypting Your SQL Server 2012 AlwaysOn Availability Databases

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 2012 AlwaysOn

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...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.