Microsoft announced the SQL Server 2005 Express Edition technical preview at Tech*Ed Europe. Express Edition is the renamed and much improved MSDE. Key features include the elimination of the query governer and support for databases up to 4GB in size. It's limited to 1 CPU and 1GB of RAM. They also have a feature called XCopy deployment. This seems to be the ability to copy a database into a certain directory and have SQL Server automatically recognize it and make it available for use. AND you can download it today.
Does amyone know if sql server 2005 (Yukon) will have built-in backup compression. I know that SQL 2000 does not and that you have to use thrid party software to accomplish this. If some has heard of anything regarding this please let me know or direct me to where I can find this information. Thanks Jerry