SQL Server Yukon: What's New in .NET Framework Programming and Database Management

1. Yukon – What is New Rajesh Gala

2. Yukon – What is new • .NET Framework Programming • Data Types • Exception Handling • Batches • Databases • Database Engine Administration • Full-Text Search • Indexes • Meta Data • Query Processor • Tables • Table and Index Partitioning • Triggers and Event Notification • Views

3. Yukon – What is new.NET Framework Programming • You can now create a database object inside an instance of SQL Server that is programmed against an assembly created in the Microsoft .NET Framework common language runtime (CLR). Stored procedures, functions, triggers, user-defined types, and user-defined aggregate functions can leverage the rich programming model provided by the CLR.

4. Yukon – What is newBatches • SQL Server "Yukon" Beta 1 introduces a new feature called multiple active result sets (MARS). MARS allows client drivers to have more than one pending request per connection.

5. Yukon – What is newData Types • SQL Server "Yukon" Beta 1 provides new data types and enhances several of the existing SQL Server data types.

6. Yukon – What is newDatabases • By using the new options in the following DDL statements, you can work with new features, such as database views, database mirroring, and the snapshot isolation framework.

7. Yukon – What is newDatabase Engine Administration • Database administrators have enhanced tools for administering the database engine.

8. Yukon – What is newException Handling • Transact-SQL has the TRY and CATCH constructs that allow you to handle transaction abort errors that would otherwise have resulted in the termination of a batch.

9. Yukon – What is newFull-Text Search • Managing full-text search is streamlined and more efficient. You can use new DDL statements (instead of system stored procedures) to create, manage and modify, and drop full-text indexes and catalogs. You can also attach and detach full-text

10. Yukon – What is newIndexes • ALTER INDEX, a new Transact-SQL DDL statement, is introduced for reorganizing and rebuilding relational and XML indexes. The CREATE INDEX statement has been enhanced to support XML index syntax, partitioning, and included (nonkey) columns. Several index options have been added including ONLINE, which allows concurrent user access to the underlying data during some index operations.

11. Yukon – What is newMeta Data • SQL Server "Yukon" Beta 1 introduces catalog views. Catalog views change the way in which users can access system meta data information. This beta release also introduces two new virtual tables.

12. Yukon – What is newQuery Processor • The database engine has been enhanced with query processing tools that developers can use to manipulate data and get complex information from the database.

13. Yukon – What is newTables • You can create and alter tables with columns using new data types, which include xml, varchar(max), nvarchar(max), varbinary(max), date, time, utcdatetime, and CLR user-defined types. Computed columns can be persisted for use in creating indexes on them. Cascading referential integrity constraints are enhanced by specifying SET NULL and SET DEFAULT in addition to CASCADE and NO ACTION. The combined width of variant data type columns can now exceed 8 kilobytes (KB) per page. Very large tables and indexes (greater than 128 extents) can be dropped faster than in earlier versions of SQL Server because of a deferred allocation unit drop mechanism.

14. Yukon – What is newTable and Index Partitioning You can partition tables and indexes by dividing them into units that might be spread across more than one filegroup in a database. Partitioned tables and indexes are partitioned horizontally so that groups of rows are mapped into individual partitions. Operations performed on the data, such as queries, are executed as if the entire table or index is a single entity. Partitioning can make: • Querying large tables or indexes faster and more efficient on multiple-CPU computers. • Large tables or indexes more manageable by allowing quick and efficient access to or management of data subsets, while maintaining the integrity of the overall collection.

15. Yukon – What is newTriggers and Event Notifications • SQL Server "Yukon" Beta 1 introduces DDL triggers and event notifications. • DDL triggers, like standard triggers, execute stored procedures in response to an event. But unlike standard triggers, DDL triggers execute in response to DDL statements (primarily statements that begin with CREATE, ALTER, and DROP). DDL triggers are used for administrative tasks, such as auditing and regulating database operations. • Event notifications execute in response to DDL and data manipulation (DML) statements, as well as trace events, but do not execute stored procedures. Instead, event notifications send information about a server event to a service broker. You can use event notifications to log and review changes or activity that occurs on the database.

16. Yukon – What is newViews • The restrictions to updating data through a view have been relaxed, and statistics can be created on nonindexed views for query optimization.

17. Yukon – What is newDemo • XML Data Type • .Net Framework Programming • Yukon Report Server