This link has been bookmarked by 14 people . It was first bookmarked on 05 Jul 2006, by Marleaux flournoy.
-
11 Jul 08
-
07 Jul 08
-
SQL Management Objects
SQL Management Objects (SMO) is a new set of programming objects that exposes all of the management functionality of the SQL Server database. In fact, Management Studio was built with SQL Management Objects. SMO is implemented as a Microsoft .NET Framework assembly.
-
Availability
Investments in high-availability technologies, additional backup and restore capabilities, and replication enhancements enable enterprises to build and deploy highly available applications. Innovative high-availability features such as database mirroring, failover clustering, database snapshots, and enhanced online operations will minimize downtime and help to ensure that critical enterprise systems remain accessible.
-
Database Mirroring
Database mirroring allows continuous streaming of the transaction log from a source server to a single destination server. In the event of a failure of the primary system, applications can immediately reconnect to the database on the secondary server. The secondary instance detects failure of the primary server within seconds and accepts database connections immediately. Database mirroring works on standard server hardware and requires no special storage or controllers. Figure 1 shows the basic configuration of database mirroring.

-
Fast Recovery
SQL Server 2005 improves the availability of SQL Server databases with a new and faster recovery option.
-
Online Operations (Index Operations and Restore)
The ability to create, rebuild, or drop an index online is an enhanced feature of SQL Server 2005 that augments the indexing capabilities of earlier versions of SQL Server. The online index option allows concurrent modifications (updates, deletes, and inserts) to the underlying table or clustered index data and any associated indexes during index data definition language (DDL) execution.
-
Support for 64-bit
-
CLR/.NET Framework Integration
With the release of SQL Server 2005, database programmers can now take full advantage of modern programming languages to implement functionality within the server as well as many assemblies in the Microsoft .NET Framework class library.
-
Enhanced programming model. Programming languages that are compatible with the .NET Framework are in many respects richer than Transact-SQL, offering constructs and capabilities that were previously not available to SQL Server developers.
• Enhanced safety and security. Managed code runs in a CLR environment, hosted by the Database Engine. This allows .NET Framework database objects to be safer and more secure than the extended stored procedures available in earlier versions of SQL Server.
• User-defined types and aggregates. Two new database objects that expand the storage and querying capabilities of SQL Server are enabled by hosting the CLR.
• Common development environment. Database development is integrated into the Microsoft Visual Studio 2005 development environment. You can use the same tools for developing and debugging database objects and scripts that you use to write middle-tier or client-tier .NET Framework components and services.
• Performance and scalability. Because managed code compiles to native code prior to execution, you can achieve significant performance increases in some scenarios.
-
Transact-SQL Enhancements
Transact-SQL has long been the basis for all SQL Server programmability. SQL Server 2005 provides many new language capabilities for developing scalable database applications. These enhancements include error handling, new recursive query capabilities, and support for new SQL Server Database Engine capabilities. Transact-SQL enhancements in SQL Server 2005 increase your expressive powers in query writing, enabling you to improve the performance of your code and extend your error management capabilities. The continuous effort that is being put into enhancing Transact-SQL shows a firm belief in its significant role in SQL Server.
-
Cross-Tier and Cross-Language Debugging
SQL Server 2005 and Visual Studio 2005 together provide even deeper integration in the area of application debugging.
-
Report Builder
Report Builder, a new component of SQL Server 2005 Reporting Services, allows business users to create their own reports using a user-friendly model of their data.
-
-
28 Jan 08
-
18 Nov 07
-
07 Apr 07
-
15 Feb 07
-
05 Jul 06
-
01 Feb 06
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.