SQL Server Blog

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

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.