SQL Server Blog

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

SQL Server 2012 Licensing – How does it compare

November 7th, 2011

With the release of SQL Server 2012 sometime within the first 6 months of 2012, Microsoft released recently a data..

Read More

SQL Server 2008 R2 SP1 CU5

October 9th, 2011

Microsoft has released Service Pack 1 Cumulative Update 5 for you to download as of 22 February 2012. The download..

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

SQL Server 2008 R2 SP1 RTM

July 14th, 2011

Microsoft has released Service Pack 1 RTM for you to download as of 11 July 2011. If you want to..

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