SQL Server 2012

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

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

SQL Server 2012 : Policy-Based Management

April 17th, 2012

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.

Read More

SQL Server 2012 : Central Management Servers

April 16th, 2012

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.

Read More

SQL Server 2012 : Management Data Warehouse

April 15th, 2012

Management Data Warehouse provides you the ability to capture information about your SQL Server environment to be used for capacity planning activities or to help troubleshoot issues that may be happening in your SQL Server environment. In this Blog i take you through setting up Management Data Warehouse in SQL Server 21012.

Read More

A new look at Microsoft SQL Server Certifications

April 14th, 2012

Microsoft learning have revamped the certifications associated with Microsoft SQL Server. To find out more about these changes read more in this blog post.

Read More

Pass SQLSaturday #137

April 11th, 2012

The schedule for SQLSaturday #137 in Canberra has been released. To help you arrange your day to see the sessions you are most interested in.

Read More

SQL Server 2012 : General Availability

April 3rd, 2012

SQL Server 2012 is finally here and available for you to download and implement in your environments.

Read More

SQL Server 2012: Books Online

April 2nd, 2012

With the release of SQL Server 2012, a new help system is available. You will be using BOL which shipped with the product software. This has now changed and you need to configure how you access BOL after your installation. In this post I take you through the steps to configure your BOL access for your SQL Server 2012 Instance.

Read More

SQL Server 2012 : Prerequisites

March 31st, 2012

SQL Server 2012 is due to be released on April 1 2012. One of the big components of the new version is SQL Server AlwaysOn. This technology provides a new granular approach to meeting your High Availability and Disaster Recovery Requirements in this ever increasingly complex world of data. This is the third of a 3 part blog series that I take you through SQL Server 2012 AlwaysOn.

Read More

SQL Server 2012 AlwaysOn : Availability Groups

March 31st, 2012

SQL Server 2012 is due to be released on April 1 2012. One of the big components of the new version is SQL Server AlwaysOn. This technology provides a new granular approach to meeting your High Availability and Disaster Recovery requirements in this ever increasingly complex world of data. This is the second of a 3 part blog series that I take you through SQL Server 2012 AlwaysOn.

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