General

T-SQL Tuesday #100 – Automation and cleaner code/data is the key to future success

March 14th, 2018

This month’s T-SQL Tuesday #100 is hosted by Adam Machanic (B | T) who started T-SQL Tuesday 8 years ago and has invited..

Read More

T-SQL Tuesday #100 – Skills Shortage

March 13th, 2018

Thank you Adam Machanic (B | T) not just for Hosting T-SQL Tuesday #100 but also for starting this fantastic..

Read More

HP Enterprise DBC Appliance

March 18th, 2012

HP and Microsoft have partnered together to build this consolidation appliance that has been optimized specifically for SQL Server 2008 R2. This appliance provides for your one stop private cloud.

Read More

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
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