SQL Server 2005 VS SQL Server 2008

New Features in SQL Server 2005:
1. It included native support for managing XML data, in addition to relational data.For this purpose, it defined an xml data type that could be used either as a data type in database columns or as literals in queries.
2. XML columns can be associated with XSD schemas; XML data being stored is verified against the schema. XML is converted to an internal binary data type before being stored in the database. Specialized indexing methods were made available for XML data. XML data is queried using XQuery; SQL Server 2005 added some extensions to the T-SQL language to allow embedding XQuery queries in T-SQL. In addition, it also defines a new extension to XQuery, called XML DML, that allows query-based modifications to XML data.
3. SQL Server 2005 also allows a database server to be exposed over web services using TDS packets encapsulated within SOAP (protocol) requests. When the data is accessed over web services, results are returned as XML.
4. For relational data, T-SQL has been augmented with error handling features (try/catch) and support for recursive queries (Common Table Expressions).
5. SQL Server 2005 has also been enhanced with new indexing algorithms and better error recovery systems. Data pages are checksummed for better error resiliency, and optimistic concurrency support has been added for better performance.
6. Permissions and access control have been made more granular and the query processor handles concurrent execution of queries in a more efficient way.
7. Partitions on tables and indexes are supported natively, so scaling out a database onto a cluster is easier.
8. SQL CLR was introduced with SQL Server 2005 to let it integrate with the .NET Framework.
9. SQL Server 2005 introduced "MARS" (Multiple Active Results Sets), a method of allowing usage of database connections for multiple purposes.


New Features in SQL Server 2008:
1. The current version of SQL Server, SQL Server 2008,[4] (code-named "Katmai",[5]) was released (RTM) on August 6, 2008[6] and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime.
2. SQL Server 2008 also includes support for structured and semi-structured data, including digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams.
3. Other new data types include specialized date and time types and a Spatial data type for location-dependent data.
4. Better support for unstructured and semi-structured data is provided using the new FILESTREAM[8] data type, which can be used to reference any file stored on the file system.
5. Structured data and metadata about the file is stored in SQL Server database, whereas the unstructured component is stored in the file system. Such files can be accessed both via Win32 file handling APIs as well as via SQL Server using T-SQL; doing the latter accesses the file data as a BLOB.
6. Backing up and restoring the database backs up or restores the referenced files as well.
7. SQL Server 2008 also natively supports hierarchical data, and includes T-SQL constructs to directly deal with them, without using recursive queries.
8. The Full-Text Search functionality has been integrated with the database engine, which simplifies management and improves performance.
9. Spatial data will be stored in two types. A "Flat Earth" (GEOMETRY or planar) data type represents geospatial data which has been projected from its native, spherical, coordinate system into a plane. A "Round Earth" data type (GEOGRAPHY) uses an ellipsoidal model in which the Earth is defined as a single continuous entity which does not suffer from the singularities such as the international dateline, poles, or map projection zone "edges". Approximately 70 methods are available to represent spatial operations for the Open Geospatial Consortium Simple Features for SQL, Version 1.1
10. SQL Server includes better compression features, which also helps in improving scalability.
11. It also includes Resource Governor that allows reserving resources for certain users or workflows.
12. It also includes capabilities for transparent encryption of data as well as compression of backups.
13. SQL Server 2008 supports the ADO.NET Entity Framework and the reporting tools, replication, and data definition will be built around the Entity Data Model.
14. On the management side, SQL Server 2008 includes the Declarative Management Framework which allows configuring policies and constraints, on the entire database or certain tables, declaratively.
15. The version of SQL Server Management Studio included with SQL Server 2008 supports IntelliSense for SQL queries against a SQL Server 2008 Database Engine
16. SQL Server 2008 also makes the databases available via Windows PowerShell providers and management functionality available as Cmdlets, so that the server and all the running instances can be managed from Windows PowerShell.

Registry key contain last few “Run” command

Today I came across a very interesting registry key which I wanna share. If you go to your "Start" menu and open the "Run" dialog from there, you will see a dropdown list labeled as "Open". This list contains the last few entries you wrote there [probably last 26 entry is its limit]. This list populated from the following registry key

"HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RunMRU"

Lets try yourself, and you know you can make some funny staff from there.

Have fun coding, take care.

/Zaq

Children are spending more time at their computers today than playing with their friends. What are the negative consequences of that.

One of the most significant and useful invention from last century is computer, which has huge upbeat impact on our daily life as well as few side effects are annihilating our next generation; the more important one is addiction of computer games specially to children.

It’s about not only playing with friends and shouting; there are lots of other things that the children from this generation are missing while they are choosing playing game with computer rather than friends. Play ground is second school for children; there are lots of thing that they learn from there. It helps to growing up child metal health; to learn about team work, to share skills, get habituation to win and acquire loses. Children have their own community and a big part of this build during playing with friend especially in play ground. Physical game always helps child to grow and strong their physical health. Few times indoor games may also make children blow and usually those are more interesting as well as more effective to build IQ, learn them take quick decision and let them improve their observation. And one more thing; getting habituation with virtual world makes them test and emotion less which makes others to suffer including their family.

To avert this problem the main part depends on guardian or who are responsible to taking care of children. They should have sense how paying with computer is demolishing their children’s’ health; both psychological and physical. They can bring their child to play grounds to play regularly. We should also be more conscious about making more playgrounds instead of destroying from the rest few. School can have the most significant role regarding this issue; they can design few courses that can create opportunity to play in school which is more secured place for child to play. We can also talk with our child to let them know the fact why they should choose playing with their friend but playing with computers.

In conclusion I want to say we are losing our green child and which is not for green house effect fairly less of our awareness. And we are offering a very feeling less and robotics generation for the next world.

Overpopulation is a twentieth century concern. What are the reasons for overpopulation and how can overpopulation be controlled?

For last few decades’ policy makers from the third world agreed with few points as global threat and overpopulation is one of the most important one without any doubt.

Among many reasons we can easily distinguish few and public awareness will be the top one. In our country general people don’t have enough knowledge what badly comes with making family large; taking more child decreased their life style and it becomes difficult to bear family expanses and taking care about everything pleasingly. Illiteracy comes after the previous one, illiterate people have lack of understanding that why they should keep their family smaller. Poverty is another reason and as poverty stands itself as a big one it has few side effects like illiteracy and early marriage which causing overpopulation. Since poor people cannot effort their family expanses unaccompanied, they need more working hands and that produce overpopulation. And also poor people want to change their fate and want security when they got older, so they want boy child and which significantly causing overpopulation. Superstition is another cause which makes people to think, birth control system is unfair and God will taking care of their child as God gives their child. Early marriage is a further one; when people get married earlier they have long time to take babies and as a result usually they have more child than others. Another reason is a bit more abstract, in our society we have an advantage that we need not to think about how to taking care of our child; usually we have senior members to look after them. Add to this as most of our families are joint-family, mothers have an advantage to become an earning member even with a very young child, because normally more family members are there who can watch over during working hours.

To prevent this problem I think first step should be to build public awareness; when our people will know the bad effects then they will start to think about this and it may decrease overpopulation. Our government should also take policies to influence our public to keep their family smaller; such as who keeps their family small may get some extra facilities like ration, free medical facility etc. In addition they can be awarded and that can stands as example which can makes people to think again before taking more children. Even government can also make law which prevents people to take more than one or two child. But behind all we need to make our people educated to teach them the real problem; and educated people must have this sense how many good thinks they will lost if they make their family larger.

But we should also think how this large population could help our nation besides thinking about the prevention policies. For example we can see in China; they have produce their over population into manpower and got tremendous success. In every sector they have the most productive manpower and which makes the world moving to China to build industries which makes china as one of the strongest country over the world.

So, we should try hard to prevent this problem and beside this we should work to use this population in productive way to build our economy strong.