Developer Productivity

Developer Productivity:
• Common Language Runtime (CLR) Integration
SQL Server 2005 introduces the capability to develop database objects using any Microsoft .NET language.
• Deep XML Integration
SQL Server 2005 delivers a new XML data type, enabling the storage of XML fragments or documents in SQL Server databases.
• Transact-SQL Enhancements
New query types and the capability to use error handling in transactions provide developers with more flexibility and control in SQL Server query development.
• SQL Server 2005 Compact Edition
Full integration of SQL Server 2005 Compact Edition with SQL Server 2005 and Visual Studio 2005 provides a platform for developers to rapidly build applications that extend enterprise data management capabilities to mobile devices.

Read more »

Enterprise Data Management

Enterprise Data Management:
• High Availability
Failover clustering and database mirroring technology in SQL Server 2005 enables enterprises to deliver highly reliable, available applications to employees, customers, and partners.
• Management Tools
SQL Server 2005 introduces an integrated suite of management tools and management application programming interfaces (APIs) to provide ease of use, manageability, and support for operating large-scale SQL Server deployments.
• Security Enhancements
SQL Server 2005 has been designed to help provide the highest level of security for enterprise data through features such as database encryption, more secure default settings, password policy enforcement, granular permissions control, and an enhanced security model.
• Scalability
Scalability advancements in SQL Server 2005 include table partitioning, replication enhancements, and 64-bit support.

Read more »

Which of the following statements is/are false for Extended events in sql server 2008?

A. Enhanced event handling system in SQL Server
B. Both b and c below
C. Used for problem identification or problem trouble shooting
D. An architecture that is not very scalable, highly configurable
Ans: D

Read more »