Monday, January 19, 2009
PSSDIAG is a general purpose diagnostic collection utility that Microsoft Product Support Services uses to collect various logs and data files. PSSDIAG can natively collect Performance Monitor logs, SQL Profiler traces, SQL Server blocking script output, Windows Event Logs, and SQLDIAG output.
RML Utilities for SQL Server (x86)
Tools to help database administrators manage the performance of Microsoft SQL Server.
SQL Nexus Tool
Tool that helps you identify the root cause of SQL Server performance issues
DbDiff - DbScripting (without dmo,smo)
Compare MSSql database structures. (Sql 7,Sql 2000,Sql 2005)
Thursday, January 15, 2009
If the DBCC checkdb , returns error such as below, that means that the clustered index (index ID 0) could have been corrupted and data loss is a possiblities.
Server: Msg 8928, Level 16, State 1, Line 1Object ID 1335232803, index ID 0: Page (1:14469854) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1335232803, index ID 0, page (1:14469854). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1Object ID 1335232803, index ID 0: Page (1:14469855) could not be processed. See other errors for details.Server: Msg 8928, Level 16, State 1, Line 1
If the Index ID is more than 1 , then only the index is spoilt.
After determining, the Page id we can get the raw data by using the below command. The 3 that's means formatted data and the 2 is the raw data.
DBCC TRACEON (3604);
DBCC PAGE ('DB', 1, 14469854, 3);
After this, we can find out the primary key of the tables . Based on this we can restored the data from the backup to here.
Another way is to restore the page data, this is only can be done minimumly in sql 2005
SQL Server in Recovery by Paul S. Randal.
Fixing damaged pages using page restore or manual inserts
Thursday, January 08, 2009
If you encounter this error, while restoring your sharepoint to another share point server,
Object Project Server Application failed in event OnPostRestore. For more information, see the error log located in the backup directory. SqlException: Access to module dbo.proc_MIP_GetObjectVersion is blocked because the signature is not valid.
This is could be due to that the shared services cannot be install in SQL server 2005 embedded version. The error when creating a new shared services "SSP Databases cannot be created in the Windows Internal Database; they must be created in SQLExpress or a full SQL Server installation"
or these error
Access to the table dbo.sites is blocked because the signature is not valid.
Access to module dbo.proc_GetCurrent is blocked because the signature is not valid.
Please follow the below guide,
This will provision the SPWebService service has not been fully provision after we restored.http://kbalertz.com/944154/receive-error-message-browse-SharePoint-collections-after-hotfix-package-public-update-Windows-SharePoint-Services-applied.aspx
If you still has error, then follow this guide to Restore a shared service provider administration site.
To check the shared services db is the problem , login to ms sql and query the shared_services1_db tables and you will see error.
Tuesday, January 06, 2009
Using PDF in Oracle Reports
which included Comparison of PDF Font Features ( which is interesting to note)
Resolving Cross-Platform Porting Issues
Managing oracle fonts in Oracle Reports