Not everyone will need this tool, but in case you have a Microsoft SQL Database Server and a lot of disk drives/SAN, you may choose to read on. Let’s assume you are a Database Administrator, and you have a lot of Disk Drives, and you have SQL Databases residing on quite a few of them. You know that a database file increases in size based on a specific setting and it is called, AutoGrow. Some of you would have it as x%, some x MB and some will have it set to different settings for different file... [More]

Scenario: You have a SQL Server, and plenty of databases. Time progresses, and you started using another Disk OR Partition. Let's say you want to know how much space is being taken by all the Databases put together. OR better still, you want to get the details of all the Databases at one shot and not via that Right-Click->Properties thingy... Here is what could help you...     Go to SQL Query Analyzer window and ensure that Results to Text (CTRL + T) option is selected.  ... [More]