Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2012

DBCC CHECKDB

Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s pretty simple to do, and it _could_ save you some big trouble later on.

What is it?

The command “DBCC CHECKDB(<db name>)” checks the logical and physical integrity of all… Read more

2 comments, 34,588 reads

Posted in SQL Server Notes from the Field on 29 May 2012

Backup compression using IBM TDP for SQL Server

If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in the lucky possition to be able to compress your SQL Server backups. Often I see installations of these versions, where compression is not enabled. Let me show you a couple… Read more

0 comments, 738 reads

Posted in SQL Server Notes from the Field on 15 May 2012

Troubleshooting Database mail

Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to do when everything looks fine, but no mail is flying through the system – what is wrong?.

After testing, if you are unable to receive notification emails,… Read more

0 comments, 1,258 reads

Posted in SQL Server Notes from the Field on 8 May 2012

How to Configure Database mail

In my daily job as a SQL Server consultant I go to a lot of places, many days on the road, and many nights at different hotels. All these things are a part of the job, so of course I am not complaining.

What some times can be a challenge… Read more

0 comments, 3,605 reads

Posted in SQL Server Notes from the Field on 1 May 2012