Oracle database growth size
How can we check the size of database growth? I needed to know this while generating a report for management regarding DB size.
Now here a little scri
SQL Server Version
November 1, 2009 by Nauman · Leave a Comment
If you need to know the version you are currently running of SQL Server you can easily get it by running the following query. SELECT ‘ SQL Server ‘ + CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ productversion ‘ )) + ‘ – ‘ + CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ productlevel ‘ )) [...]
Simple script to backup all SQL Server databases
November 1, 2009 by Nauman · Leave a Comment
Problem Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server. This is not a big deal if you have a handful of databases, but [...]