SQL Server Blog

AlwaysOn Availability Groups: What not to do when adding databases

April 6th, 2014

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 database can you reasonable add? it depends on the resources available and the workload, but you can come up with a reasonable estimate as Warwick explains

Read More

SQLSaturday #296–Melbourne

February 26th, 2014

SQLSaturday is coming to Australia again in 2014. This time it kicks off with SQLSaturday #296 in Melbourne on Saturday 5th April. If you are in the Melbourne area and would like some free SQL Server training from some MVP’s, MCM’s and speakers who are well regarded in the SQL Server community then register now.

Read More

My Journey to becoming a Microsoft Certified Solutions Master

October 4th, 2013

In this post I am going to take you through my journey to becoming a Microsoft Certified Solutions Master.

Read More

Expanding AlwaysOn Availability Groups with Replication Subscribers

January 31st, 2013

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

Expanding AlwaysOn Availability Groups with Replication Publishers

January 30th, 2013

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

SQL Server 2012 : Availability Groups Creation Error

July 19th, 2012

SQL Server 2012 AlwaysOn Availability Groups can be pretty easy to create and configure but unless you have designed your environment you may hit the following error when trying to create the Availability Group with the Wizard. To find out more read on ……

Read More

SQL Server 2012 Database Mirroring

July 13th, 2012

Database Mirroring was first introduced in SQL Server 2005. This technology is still available as a viable option to meet your High Availability or Disaster Recovery requirements.

Read More

Encrypting your SQL Server 2012 AlwaysOn Availability database

July 6th, 2012

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

Performance Analysis of Logs (PAL)

June 7th, 2012

Performance Analysis of Logs V2.3 is a tool available for download from codeplex that can help you easily analyse performance logs from your environment.

Read More

SQL Server in the Cloud

June 2nd, 2012

Amazon RDS is providing you an offer, allowing you to have a look at and test out SQL Server in the Cloud for free for 12 months.

Read More

SQL Server 2012 : AlwaysOn demonstration

May 18th, 2012

SQL Server 2012 AlwaysOn provides you the ability to control your SQL Server environment with more control to meet your High Availability and Disaster Recovery requirements. These 2 videos take you through setting up your environment as well as monitoring your environment.

Read More

SQL Server 2012 : Performance Dashboard Reports

May 12th, 2012

SQL Server 2012, has a feature pack which is a collection of stand-alone packages which provide additional value to your instance of SQL Server 2012. We are having a look at the Performance Dashboard Reports package.

Read More
Blog

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.

Search
0

Your Cart