SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

The Recovery Pending status usually means that the SQL Server transaction file is damaged. If that is the case, you need to repair the database. To do that, you can use Stellar Repair for MS SQL. This ...

Because SQL ... fix orphaned users. This procedure can do several things. It can tell you which users are orphaned and it can fix an orphaned user manually or automatically. Here's an example: I ...

Are there any particular tools you recommend to DBAs to help them fix common problems? Yes, I recommend any of the tools made by SolarWinds (Database Performance Analyzer, SQL Sentry, Database ...

I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ... Poking around the internet led me to realize that in order to understand and fix SQL performance, I ...