MS SQL SVR STD 2005 5 CLT AE
MS SQL Svr 2005 Std NOTE: This is an ACADEMIC ED
A COMPLETE DATA MGT & ANALYSIS PLATFORM FOR MEDIUM BUSINESS & LARGE DEPT PI DATE: OCTOBER 2005 * Proc Lic is reqd for each CPU in the OS instance running SQL Svr * SQL Svr 2005 makes it simpler & easier to deploy, manage & optimise enterprise data & analytical App * Simplifies Mgt by providing 1 Intg Mgt console to Mon & manage the SQL Svr relational database, * SQL Mgt Objects (SMO) is a new set of Prog objects that exposes all of the Mgt functionality of the SQL Svr database * Enforcing policies for SQL Svr login password in the authentication space * Providing for more granularity in terms of specifying permissions at various scopes in the authorisation space * Provides new language capabilities for developing scalable database App * Advancements such as native XML data type & XQuery help organizations to seamlessly connect Int & Ext Sys * Adv notification capabilities for development & deployment of scalable App that can deliver personalised, timely information updates to a variety of connected & mobile devices * Service Broker is a distributed App framework that provides reliable asynchronous messaging at the database to database level * Provides graphical extract, transform & load (ETL) capabilities * Develop XML Web services in the database tier, making SQL Server an HTTP listener * Reporting Services is an Entp managed reporting environment, embedded & managed via Web services