Identifying Unused Databases
This is one of the issues the consultant faces, when there client has little documentation on the systems and the databases they use. The first step in this process is simply looking at the date &am…
Backup database to disk = ‘Nul’
To understand what this is doing, first we need to understand what Nul is, in the context of a file. It is not just a misspelling of NULL. DOS, since the earliest days, has had a number of devices …
How to recover space from a huge transaction log file
Most of the novice dba’s forget to take the transaction log backups, which eventually ends up consuming a lot of disk space. This is one of the questions people ask me very often. Here are the steps …
What causes Multi-Page allocations?
In SQL Server versions before SQL 2012 single page allocations and multi-Page allocations are handled by different components, the Single Page Allocator (which is responsible for Buffer Pool allocati…
How to Recover from a Lost SA Password in SQL Server
I saw many people asking this question over and over again and today, I’d like to share with you a backdoor to SQL Server 2012 which would help you gain SYSADMIN access to your production SQL Se…