Bytes and Bites of Internet
Archive for January, 2010
SQL Server 2008 …. Installation How To
Jan 26th
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 for production server and so you will have more closer look of enterprise level DBMS. And it is very cheap to buy.
Anyways, here is the process of installation … its pretty straight forward (just like all other MSFT products .. point n’n click :-D), so I will be showing screenshot of steps which requires careful selection.
More >
Database …. Introduction to SQL Server
Jan 19th
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 I think its mainly because of its “User Friendly Nature” (or say good GUI :-D, oh did i mentioned i miss fun using black and white CLI with no ability to interact ? 
). I have used been user of SQL Server from its three generations , 2000, 2005 and 2008 ( Latest one 2008 R2, is still in beta ), and It has been improved greatly in every iteration offering more features and better performance.
Windows 7 GOD MODE
Jan 10th
If you have been playing games, you might be aware of “GOD MODE” that we use in Games. Basically it make you “GOD” and you can be killed by anyone , get all weapons and hell sometimes you can even fly in air and walk though the wall !!!
No no, this god mode won’t let your windows 7 turn in to windows 7000 … but can say it will put all the administration settings into one page (like, UAC or Security Center or Internet Options are few to name). I read it on one of my favorite site Download.com.
Database 101 … Physical Requirements
Jan 9th
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 here I want to write about all to the ground very basic requirements of “any” DBMS. Physical structure of DBMS comprise of 3 core components Processor, RAM and Storage Unit. And believe it or not, all three has very significant effect on overall performance of DBMS, with no need to say if not chosen wisely it can hinder your DBMS operation.
Life without Internet !!!
Jan 6th
During these Christmas holidays, I tried something new … I tried to live without internet !!! Well, you may think what’s a big deal but guys believe me for a person like me who breath internet this is a “BIG” thing.
In 90’s Internet was considered as luxury to have. I still remember using it via highly charged long distance call of telephone line and the speed was killing (dare to say, 8-10 kbps 
) … but those days were good, you always get time to have tea before finishing up something to download in size of even few Mbs … but today more then necessity technology has become addiction to us (at least in my case).