SQL 2005

Missing Performance Counters

Missing Performance Counters

We had an incident today where a set of SQL performance counters were not showing in Perfmon. The performance counters in question were the SSISPipeline set on a 64bit instance of SQL Server 2005, the reason why they were not showing was that in a 64 bit installation the registry setting that stores the location […]

Registered Servers Error in SSMS

Last week I needed to repair my installation of Windows and ended up reinstalling completely over the top of the existing OS, this lead to an error is SSMS when I wanted to use Registered Servers, I have added the error in it’s entirety below: See the end of this message for details on invoking […]

Installing Anti Virus on a SQL Server

It’s been quite a while since I last posted anything on this site, there’s been a lot of change behind the scenes and have a number of entries to post based on things that have happened in the last few weeks. Earlier this week I was asked by one of our infrastructure guys when would […]

Changing how you view results in SSMS

Richard Douglas describes how you can make viewing your data results easier for others in SSMS in a few easy steps.

Finding Files: Part 1 T-SQL

Richard Douglas shows how you could use the undocumented stored procedure xp_FileExists to start another process.