SQL Server Blog

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

SQL Server 2008 SP3 CTP

August 24th, 2011

Microsoft has released Service Pack 3 CTP for you to download as of 22 August 2011. The download of SP3..

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

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

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

Failed :(0) Alter failed for server “ComputerName\Instance”;

April 20th, 2011

Being on-call I received an alert for a client with the following message – ‘The following jobs(s) failed to execute..

Read More

Reading large SQL Server error log files

February 27th, 2011

SQL Server error logs can grow quite large due to an issue or from infrequent cycling of the log file. If these log files get to large then you are not able to read the contents either through SSMS or a file editor. This blog takes you through how to read the log using xp_readerrorlog.

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