Monday, February 6, 2012

Oracle database growth size

November 28, 2010 by · 1 Comment 

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 · 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 · 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 [...]