SQL Server 2008 R2

SSRS 2008 R2 Menu Drop Downs

August 8th, 2014

Recently I was working with an instance of SQL Server Reporting Services 2008 R2 and noticed that when logged in using an account that is a member of the Browser Role, that there are some drop down menu items available on Report folders, Reports that were showing the following options being available for me to do:

Read More

SQL Server Support for SysPrep

June 17th, 2014

Sysprep was first supported with SQL Server 2008 R2 to help with your raid deployment of SQL Server environments. With the release of SQL Server 2014 improved support is available for SQL Server installations via Sysprep.

Read More

SQL Server 2008 Service Pack Plans

May 29th, 2014

Microsoft have announced the plans for the last Service Packs for SQL Server 2008 and SQL Server 2008 R2 to be released after the end of mainstream support for both of these versions come July 8, 2014. You can find out more about what this means for you.

Read More

SQL Server 2008 R2 In-place Upgrade

March 1st, 2012

Upgrading SQL Server versions to SQL Server 2008 R2 can be achieved in a couple of different ways. In-place Upgrade, Side by Side Installations or New Installations on new hardware. In this blog I am taking you through an in-place upgrade to SQL Server 2008 R2.

Read More

SQL Server Database Maintenance

December 20th, 2011

As a DBA or Consultant, Database Maintenance is one of the most important tasks that needs to be implemented. What..

Read More

Recursive Common Table Expression

December 17th, 2011

Microsoft introduced the Common Table Expression (CTE) with the release of SQL Server 2005, so it has been around for..

Read More

SQL Server 2008 R2 SP1 CU1

July 22nd, 2011

Microsoft released the first Cumulative Update – CU1 for Service Pack 1 on the July 18 2011. Cumulative Update 1..

Read More

You cannot create, add, or edit steps for a SQL Server Agent Job in SQL Server Management Studio 2008 R2

June 17th, 2011

While on a client site I received an email indicating that when using SQL Server Management Studio 2008 R2 on..

Read More

Alter Index Vs DBCC IndexDefrag Vs DBCC DBReIndex

June 13th, 2011

DBCC IndexDefrag & DBCC DBReIndex are deprecated features in the next version of SQL Server. This blog has a look..

Read More

SQL Server 2008 R2 SP1 CTP

May 18th, 2011

Microsoft has released Service Pack 1 Community Technology Preview for you download as of 22 April 2011. If you want..

Read More

SQL Server 2008 R2 Test Data Load Using VS2010

May 16th, 2011

In this blog I am going to give you an insight into how easy it is to generate random data..

Read More

SQL Server Compression Estimator Tool

May 12th, 2011

On Monday 9th May 2011 the release of the SQL Server Compression Estimator Tool was made available on Codeplex  for..

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.