SQL Server Blog

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

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.

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.

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.

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.

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

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.

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

Whether you are a Team Leader or Department Manager in a large multi-national organisation or from a small IT business,..

SQL Server 2008 SP2 was made available in September 2010. If you want to stay up to date with your..

SQL Server 2008 SP1 was made available in August 2009. If you want to stay up to date with your..