SQL Server Compression Estimation
September 14th, 2011
Previously I blogged about the release of the Compression Estimation Tool available for download from CodePlex. To read more about..
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.
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.
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..
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