Previous / yesterday’s date in DOS batch file

Previous / yesterday’s date in DOS batch file
Here is the script to get previous date output in DOS using bat files. This is very useful when we take backup of files with previous date name. (for example backup_daily_20072010.zip ) or can set bat files to get last 7 days backup to a zip.  According to [...]

[ More ] July 21st, 2010 | No Comments | Posted in Programming |

PL/SQL Fundamentals Part 2

In the last session , we have seen a brief about relational database model and a table structure. Let us see the database maintenance language called SQL in this chapter.
SQL is English like data base query language initially developed by Donald D Chamberlin and Raymond Boyce to manipulate data in IBM’s database called System R. [...]

[ More ] July 19th, 2010 | No Comments | Posted in Programming |

Bat file to get File size in human readable format

There is an example of Bat file which can give output of file size in human readable format (Value with KB / MB etc ). This bat file is good with some copying / backup bat files. Here you will get the file size in variable called %size% . You can test the script by [...]

[ More ] July 15th, 2010 | No Comments | Posted in Programming |

PL/SQL Fundamentals

In my last article we were discussing about a few points related to the origin of the computer era. In this lesson, we will talk about database management systems, query language and the procedure based programming.
Any application software picks data from its database. A database can be defined as a collection of processed data arranged [...]

[ More ] July 13th, 2010 | 1 Comment | Posted in Programming |

We are living at the edge of Technologies

We are living at the edge of Technologies. We cannot even imagine the life without computers, softwares and internet in the present life. From students through the formally illiterate individuals till the cutting edge technologists has the use of computers in their daily life in one way or the other.  So technology is a must [...]

[ More ] May 22nd, 2010 | 1 Comment | Posted in Programming |

Use Microsoft SQL Server Express 2008 It is free

Microsoft SQL Server Express Is a freely downloadable and distributable product from Microsoft. It is a light weight version of SQL server. SQL Server Express includes powerful features such as SQL Server Management Studio Express, for easily managing a database.
It is mainly for developers, embedded and smaller-scale applications,  You can Create databases up to 4 [...]

[ More ] December 26th, 2008 | 1 Comment | Posted in Misc, Programming, Servers, Softwares |