SQL Server 2008 R2

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:

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.

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.

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.

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

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

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

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

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

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

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

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