SQL Server 2005

SQL Server 2005 Installation Failure on Windows Server 2003

December 10th, 2014

When Installing older versions of SQL Server on new hardware we need to be aware of limitations that could cause errors to be generated. In this article we will have a look at an error while installing SQL Server 2005 Slipstreamed with SP2 onto a Windows Server 2003 Server with multiple cores. Error 1053 results and how can we get around this to complete the installation? Read more ….

Read More

SQL Server 2005 Upgrade Advisor

October 20th, 2014

SQL Server 2005 Upgrade advisor is a must tool if you are still working with SQL Server 2000 and looking to upgrade. However when you go to use this tool, you may hit an issue with being able to run the tool and get any valid results for your environment. This quick blog will give you the steps to keep you going with investigating your environment.

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

Database Maintenance in SQL Server 2005 Express – Performance

September 3rd, 2011

Following on from my previous blog on SQL Server Agent for SQL Server 2005 Express, this post is to run..

Read More

Database Maintenance in SQL Server 2005 Express – Integrity

September 2nd, 2011

Following on from my Blog on SQL Server Agent for SQL Server 2005 Express, this post is to run you..

Read More

Database Maintenance in SQL Server 2005 Express – Recoverability

August 28th, 2011

The recoverability of your databases is probably the most important thing you need to be thinking about when you are..

Read More

SQL Server Agent for SQL Server 2005 Express

August 28th, 2011

With the prevalence of DotNetNuke DNN out there in the community and the large numbers of people utilising hosted solutions..

Read More

SQLDiag Configuration Tool

May 1st, 2011

A new tool became available on the 27th April 2011 and is available for download from Codeplex . This tool..

Read More

SQL Server 2005 SP4 RTM

December 20th, 2010

SQL Server 2005 SP4 RTM was made available on December-17-2010. If you want to stay up to date with your..

Read More

SQL Server 2005 SP4 CTP

December 9th, 2010

SQL Server 2005 SP4 CTP was made available in November 2010. If you want to stay up to date with..

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