The All New Stellar Repair for MS SQL 9.0

Stellar Data Recovery has several software that works on the Microsoft SQL Server platform to provide data recovery solutions where it all seems to be lost. Most SQL Database administrators and developers would one day face one or more of these questions: Do you have a corrupt database file and need to recover the data?... Continue Reading →

CORRUPTION 101

CORRUPTION TOOLKIT: BACKUP & RESTORE - See if the backup is clean once you restore (usually on another server. BCP (Bulk Copy) & DB ATTACH - try to BCP remove the corrupt tables and restore (attach) the remaining database REBUILD/REPAIR databases System database issues (corruption) - rebuild will replace system database then you can replace... Continue Reading →

T-SQL Pivot

To a large extent business users want to visualize data in a tabular format as shown below. This is a good presentation however, it takes 3 rows just to present data for CustomerID 11000 and 31406 rows to present data for all the CustomerIDs. What if your requirement is to represent each year as an individual... Continue Reading →

Create a website or blog at WordPress.com

Up ↑