CA eTrust Antivirus reports infection by JS/Snz.A on sqlcast blog!

Update (1st. January): CA has released a new eTrust definitions update that corrects the error (build 5421), apparently this was a false positive; thanks to a reader for reporting on this. No word from CA so far (issue number 16683491 01). I have discovered the following virus detection message appearing on Windows computers using CA…

1

SQL Server Configuration Manager behavior in Clustered installation

According to Books Online reference "SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to mange the network connectivity configuration". One of the greatest things about SQL Server Configuration Manager (SSCM for the sake of brevity) is that you…

0

Reducing tempdb size in a SQL Server Cluster (after ALTER DATABASE execution)

Some weeks ago a colleague from another company called me for help in fixing a database performance problem. The root cause was located on a possible contention issue on tempdb that was causing database to perform badly from time to time. He did find a match between the times of bad performance and the following…

1

How to check Fragmentation on SQL Server 2005

I have been asked this question several times: Is there a tool in SQL Server where I can easily check database fragmentation? The answer, as with many other things, would be “Yes” and “No”. Fragmentation is a “natural” process in the database lifecycle. If the database is frequently updated via INSERT, UPDATE, or DELETE statements…

5