SQL Server Blog

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

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

Windows Server 2008 Cluster Disks Issues

March 3rd, 2011

When building a Windows Server 2008 Stretch cluster you may experience some issues when adding some clustered disk. In this blog I discuss how to get around this issue and how to use cluster.exe to achieve the desired outcome with a working Cluster.

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

Test connection failed because of an error initializing provider

February 20th, 2011

Test connection failed because of an error initializing provider [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied. This message is not very meaningful and is hard to investigate. In this blog I take you through a scenario of how to identify and fix this issue.

Read More

Server Principal Name Error

January 5th, 2011

Server Principal Name (SPN) errors can cause you large amounts of time to find and fix. In this blog I work through 1 particular issue that you may come across when trying to connect remotely through SSMS using kerberos.

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

SSRS Folder Permissions

December 16th, 2010

Do you have SQL Server Reporting Services 2008 and you need to keep track of who has access to the different Report Folder Structures and the permissions they have for those folders? Read on and I will show you how you can keep on top of this.

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.


Your Cart