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 The All New Stellar Repair for MS SQL 9.0
BAK is an extension that stands for a backup copy of a file, and in our guides’ context, it is associated with SQL Server Database. One can restore the backup file to select SQL Server Database, but the most important thing is that the backup files shouldn’t be corrupt or damaged. Now assuming, that you … Continue reading How to Restore Database in SQL Server 2008 R2 from BAK File?
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 CORRUPTION 101
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 T-SQL Pivot