Failover Cluster Testing Methods

1.1 System Failover Testing During system testing, we will gather as much information as possible about the potential outcomes of system failures. We will not test, however, many component failures in the system such as a motherboard going out, losing a processor or having a cooling fan going out. These represent outages that have been…

5

Extracting Project Actuals information from Microsoft Project Server (MSPS)

MSPS has four databases that it stores data from Enterprise Project Server – Draft, Published, Reporting, and Archive databases.   It is recommended not to query Draft and Published databases directly.   Reporting database as name indicates is the right database to query directly to extract MSPS data for further reporting of consumption in other applications.    I…

0

UDF and Performance

This was one of the thread entry in SQL discussion by Umachandar who is from SQL Product Team, Microsoft.    Take a look a the SCHEMABINDING information on blog site.   I think it is a question of when to use UDFs. You should simply avoid UDFs in SELECT statements or DMLs since there are lot of…

0