SQL Server Blog

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

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.

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.

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

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.

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…

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.

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.

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.

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.

SQL Server Policy-Based Management allows for DBA's to manage their SQL Server environment with enforcing standard policies. This post gives a general overview of how this is accomplished.

Central Management Servers were introduced in SQL Server 2008 to provide a central location to manage SQL Server environments. This blog takes you through configuring your Central Management Server environment in SQL Server 2012.