Welcome to MSDN Blogs Sign in | Join | Help

February 2009 - Posts

Friday, February 27, 2009 9:36 AM

What data should you backup from your SQL Server cluster?

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
Posted by John Daskalakis | 4 Comments
Filed under:
Thursday, February 26, 2009 10:48 AM

Useful T-SQL queries for a SQL Server 2008 administrator

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
Posted by John Daskalakis | 2 Comments
Filed under:
Wednesday, February 11, 2009 1:58 PM

How to manage SQL Server 2008 by creating and using Policies

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
Posted by John Daskalakis | 1 Comments
Tuesday, February 10, 2009 1:03 PM

How to use the resource governor in SQL server 2008

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
Posted by John Daskalakis | 0 Comments
Friday, February 06, 2009 11:33 AM

How to remove (drop) the partitioning of a SQL Server 2005 table

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. - Partition
Posted by John Daskalakis | 1 Comments
Thursday, February 05, 2009 8:46 AM

How to configure DCOM to listen to a specific ports range

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
Posted by John Daskalakis | 1 Comments
Filed under:
 
Page view tracker