SQL Server Blog

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

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

Hiring a SQL Server DBA

December 7th, 2010

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

Read More

SQL Server 2008 SP2

December 6th, 2010

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

Read More

SQL Server 2008 SP1

December 6th, 2010

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

Read More
0

Your Cart