Tag Archives: T-sql Engine

Get ready for an upgrade! We proudly inform you that we will perform MS-SQL upgrade for your accounts. All accounts using MS-SQL 2000 will be upgraded to either MS-SQL 2005 or MS-SQL Express 2005. We have specified the upgrading process.

All accounts using our old cluster (old plans) will be upgraded to MS-SQL Server 2005 Express Edition. Moreover, those having accounts in our all new Premium Hosting (the new cluster) will use the MS-SQL Server 2005 Standard. What’s so special about both MS-SQL 2005?

MS-SQL Server (SQL 2005 Express)

From the first of many pluses, The Express edition is a fast and easy way to develop dynamic applications, which is easy-to-use and lightweight. With MS-SQL Express 2005, you’ll be able to build robust and reliable applications. Simple but powerful application development is in your hand.

It offers you with attractive features for website development and performs fast There is full-text search features to provide powerful query capability over textual data. Additionally, You can also easily load databases to a hosted environment with XCopy feature. Native XML is also supported inside the database to ensure Web environment easily interoperates with other applications through Web services.

Another plus is that SQL Server Express cooperates with SQL Server 2005 Reporting Services to create interactive reports. Complicated reports with tables and charts are no longer impossible tasks to do as SQL Server Express reduces the complexity with graphics and integrate them in applications.

And What about MS-SQL Server (SQL2005 Standard)?

Many users recognize MS-SQL Server 2005 as the successor of the previous version, MS-SQL Server 2000. Just like the Express edition, it also has many advantages you can take from.  For example, the native XML support, that helps to manage XML data. MS SQL Server 2005 has the massive support to manage efficiently the Extensible Markup Language data.

It also has embedded some database file extensions to the T-SQL engine to allow further embedding  in any XQuery inquiries in T-SQL.  Moreover, MS SQL Server 2005 clearly identifies new file extensions named XML and DML, permitting modifications on the query based on the XML data.

Additionally, it delivers powerful and productive management tools for DBAs and simplifies management with integrated management environment to monitor and manage plus adjust all  databases and associated services throughout your enterprise. An extensible management infrastructure (easily programmed) using SQL Management Objects (SMO) is also provided, enabling you to customize and extend their management environment and build additional tools as you’d like to.

That’s why we decide to upgrade our MS-SQL into the 2005 Standard and Express, clearly nothing more than to provide more awesome web hosting experience for all users. So prepare now for perfection…

~ Gabrielle ~