SQL Server Blog

SQLIO Benchmark Testing SSDs

June 27th, 2011

SQLIO is a tool available for download from Microsoft that you can use to help determine the I/O capacity of..

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

Microsoft Tech-ED Australia 2011 – Registrations

June 8th, 2011

Microsoft Tech-ED Australia 2011 which is being held on the Gold Coast, QLD from Aug 30 – Sep 2 is..

Read More

SQLQuery Stress

May 23rd, 2011

SQLQueryStress is a performance testing tool, which has been designed to allow you to load test individual queries. This tool..

Read More

Performance Analysis of Logs Tool

May 23rd, 2011

Are you a SQL Server DBA that from time to time has encountered some sort of performance issues with your..

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

Microsoft tech-ed 2011 – Potential Unleashed

May 7th, 2011

Australia's Microsoft Tech-Ed event is on again on the Gold Coast from August 30 – September 2 2011.

Read More

Guest user in the MSDB database in SQL Server

May 6th, 2011

Microsoft has released a new KB article on not disabling the guest user in the MSDB. This has been released to counter the recommendations found in BOL.

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

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.