Tag Archives: SQL

Windows performance monitor is a real time performance monitoring tool. It gives result in three different ways, Graphical view Histogram view and plaint text counter view. Some times we need to log the utilization of a server for the future reference. It includes various  services like IIS, SQL, CPU, Disk usage etc.. you can write them to a file and …

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. Foreseeing the scope of …

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 in two-dimensional tables ( …

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 for every individual and the …

SQL Server Express is now available with 10 GB Storage support. Earlier it was supported only 4GB. Now most SOHO users can use Microsoft SQL Express for their applications. It is ideal for websites and web based applications. It is coming along with a SQL management tool, reporting capabilities, full-text search, and spatial support. Compatible with all editions of SQL …

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 GB in size. Also …