SQL Server Blog

Performance Eye for the SQL Guy – Part 2

May 20th, 2014

With the release of SQL Server 2014, there are few features which can help improve with the performance of your SQL Server environments. Over this 5 part series I will take you through a high level overview of these features. Part 2 of this series are are looking at Resource Governor for I/O.

Read More

Performance Eye for the SQL Guy – Part 1

May 20th, 2014

With the release of SQL Server 2014, there are few features which can help improve with the performance of your SQL Server environments. Over this 5 part series I will take you through a high level overview of these features. Part 1 of this series are are looking at Buffer Pool Extension.

Read More

SQLSaturday #316–Christchurch

May 20th, 2014

SQLSaturday #316 has been finalized and is happening in Christchurch on June 14 2014. If you have not registered already there is still time for you to register for this day of free SQL Server training. I am lucky enough to be joining a fellow MCM – Brent McCracken to present in Christchurch.

Read More

T-SQL Tuesday #54–Interviews and hiring

May 12th, 2014

T-SQL Tuesday article discussing Interviews and Hiring. Have a look at at some insights I have gained over my years and the interviews that I have participated in.

Read More

TechEd 2014 Australia

May 7th, 2014

TechEd 2014 in Australia now has a new format. This year there is twice the event, Starting in Melbourne and followed by in Sydney. Pre-register is now available.

Read More

SQL Server 2014 : Buffer Pool Extension

April 14th, 2014

Following on from my post last week on SQL Server 2014 : What’s New I am having a little deeper look into the Buffer Pool Extension (,strong>BPE). The introduction of the BPE, which is available in Standard Edition and Enterprise Edition allows you to extend your available memory by providing a hybrid buffer pool to help reduce I/O bottlenecks as long as you have access to an SSD.

Read More

SQL Server 2014 : What’s New

April 7th, 2014

With the release of SQL Server 2014 on Aril 1 2014, there are some new things you need to know about this version of SQL Server. In this article I am going to introduce these new features.

Read More

SQL Server 2014 : Licensing you need to know

April 6th, 2014

With the recent release of SQL Server 2014 on April 1 2014, there are some things that we need to know and be aware of to allow us to make any decisions about our potential upgrade path to this new version. Reviewing the SQL Server 2014 licensing datasheet we can see the changes we need to know about.

Read More

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
0

Your Cart