If by any chance you happen to know a little history of computers, you will be surprised that most of the early innovators had taken their primary field of study as Mathematics or Physics !!! At first glance, you may wonder what a mathematician is doing in field of computers right ?? But even if
Category: Database
SQL Server 2008 …. Installation How To
Just I had explained in previous post, even just for learning purpose if you want to experience real power of SQL Server, then you should atleast have Standard edition of SQL Server 2008. But if you can get Developer edition then it is better, because developer edition is an enterprise edition which can’t be used
Database …. Introduction to SQL Server
After understanding of internal of DBMS, different major physical components we are now ready to move company specific DBMS product, and the product i work on is Microsoft SQL Server. Microsoft is “fresher” in database field compared to its rivals Oracle and IBM. But it has conquered significant portion of market as of today and
Database 101 … Physical Requirements
Just like any other software, any given DBMS has its own system requirements. They too have min. and recommended system requirements. Minimum system requirements are something that DBMS need to just “work” and recommended system requirements can make DBMS work well beyond OK (but having very good performance of DBMS is whole different story) But
Database 101 … Internals of Database
Depending on storage method used by database, it can be classified in various models. Such as, Relational database, Network Database, Object Oriented Database etc. definition can be found over Wikipedia. The most commonly used Database Model today is Relational Database Model, in which all information stored as a relation. This model was originally formulated by
Database 101 … Why we need it anyway ?
Before going in to much detail, first lets see what is database… by book it is defined as, Database is collection of useful information For any enterprise, data is perhaps the most precious asset. It can be any sort of data … say customer information, sales data etc. But random data is only useful when