Many administrators believe that if they take a backup of their user databases, they are on the safe side. Indeed, on a disaster recovery scenario they can rebuild Windows, they can then rebuild the Windows Cluster and they can reinstall the SQL Server...

Some database administration queries you can use for SQL Server 2008 in order to identify possible problems. I have not written all of these queries myself -- Identify all processes that are blocked for more than 10 seconds SELECT * FROM sys.sysprocesses...

A nice new feature of SQL Server 2008 is Policy-based Management. This whole new feature means that you can enforce certain policies on your SQL Server 2008 whether your users (or the DBAs) like it or not. This feature is 'Enabled' by default when you...

Starting with SQL Server 2008, a new feature called Resource Governor is introduced in the SQL Server family. The Resource Governor gives you the ability to allocate Processor and Memory resources to a specific workload. These resource limits can even...

You have decided to remove or recreate the partitioning. If you try to drop either the partition schema or the function you will get errors like these: - The partition scheme "XXXXXXXXXXXXX" is currently being used to partition one or more tables....

In order to allow DCOM to operate efficiently you need to open these ports in the firewall: - Port 135 TCP and UDP - The ports range: 1024-5000 UDP Some network admins won't be happy to do these changes and some might even refuse to open their firewall...