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..
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.
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.
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.
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.
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..
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.
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..
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,..
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..
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..
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
Recent Posts
Categories
AlwaysOn Availability Groups Arc Data Services Availability Groups Azure Azure Data Studio CosmosDB Data Database DevOPs Database Lifecycle Management DevOPs Disaster Recovery DLM General High Availability JSON Kerberos Performance Power BI Presentations Reporting Services Security Service Broker Service Packs SMC SQL SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server 2022 SQL Server 2025 SQLServer SQLServerCentral T-SQL T-SQL Tuesday TSQL Uncategorized