General

Setting FavIcon for your DNN Portal

February 26th, 2012

Setting your FavIcon.ico file for your DNN site can improve the professional appearance of your site. Creating your own Icon is very simple, but changing the setting in your DNN admin settings may not work depending on the version of DNN you are running. This blog will take you through how to change your FavIcon.ico in DNN 6.

Read More

SQL Server Instance Database Sizing’s

January 25th, 2012

Quickly and easily reporting on all DB's in your SQL Instances on space usage is a requirement that is not that easy to achieve for multiple databases. It can be made simpler with the use of the .sql script that I have created that is available for download.

Read More

Microsoft Baseline Security Analyzer

November 16th, 2011

Microsoft Baseline Security Analyzer 2.2 (MBSA) is a tool that provides a streamlined method of identifying any missing security updates..

Read More

Granting a SQL Service account permissions to create SPN’s

November 15th, 2011

When preparing for a SQL Server installation, whether that be for a Stand-alone Instance or a clustered Instance, using a..

Read More

Installing SQLScheduler

September 19th, 2011

Are you using a version of SQL Server Express 2005, 2008, 2008 R2? Well these editions do not have the..

Read More

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.

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

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
Blog

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