MS SQL 2005 Server was released after 5 servers of it previous SQL version, MS SQL 2000, Hence it required allot to revisions to cope up with the current windows development environment. Therefore MS SQL 2005 SP2 had major changes in it, with too many performances and security fixes. Microsoft could not add few revisions due to its basic development structure however they had all the scope to introduce them in SQL 2008 release. And indeed, MS SQL 2008 has many installation as well as performance fixes being applied to it and allowing Windows Administrators to have full control on SQL activities. The biggest advantage of SQL 2008 over SQL 2005 is the ability to manage and maintain server performance. SQL 2008 does not require too much resource which is the best deal for today’s Shared Hosting environment. Also an upper hand to whose to do not want to invest too much on hardware of their dedicated servers just to run SQL server on it.

I have tried to gather the major improvement introduced by Microsoft on SQL 2008 from Internet which is an advantage over SQL 2005 however it all depends on what features are useful to you in the development of your ASP .NET applications. But switching to Microsoft SQL 2008 is definitely going to improve the performance even if you don’t use any of the below feature. And not to forget that with the release of SQL 2008, Microsoft will announce “End Of Life” for SQL 2000 version, which will mean that there won’t be any official support or update release for SQL 2000.

more…

Difference between Hardware firewall and software firewall
Which firewall is best?

Well this question again generate a cross question.
What are your requirement?

If you need to protect your network through IP based regardless of Application using the port. Hardware firewalls has a strong and fast protection from most forms of attack coming from the outside world. Hardware firewall has a designed technique called packet filtering that examines the header of a packet to determine its source and destination addresses [IP’s].  This information is compared to set rules that determine whether the packet is to be forwarded or blocked
Now days a new technique called Stateful Packet Inspection (SPI) is used in firewall
That check the origin of packets that means it check whether the response is from internet, if yes whether it is the requested response for a machine from local network.
If yes the allow traffic
Bad thing is that, if, say, you get email containing WORD doc that has spyware/Macro hidden in it, which communicate to outer world when WORD file is opened/executed.
Your hardware firewall will allow communication to outer world and the requested incoming packets too, as the packet origin was from local network,
Resulting Machine infection

more…

Exchange 2003 and 2007 difference

·        2003 is 32 bit
·        Single server base, No roles base
·        Outlook Mobile Access (or OMA)
·        Active sync
·        Up-To-Date Notifications

Exchange 2003 with SP2

·        Direct Push
·        Global Address List lookup
·        Mobile Admin

2007 exchange server
Enhanced and Newly added features

·        Has Power full command line Power shell for configuration
·        Most of configuration is done through power shell
·        Fast message retrieval
·        Follow-up flags
·        Meeting attendee information
·        Enhanced Exchange Search
·        Windows Share Point and file share document access
·        Reset PIN/Password
·        Enhanced PPC security
·        Autodiscover for over the air (OTA) provisioning
·        Out of Office
·        Support for HTML messages

more…