Ce functionalitati ati dori sa fie prezente in Screencast-uri? Functionalitatile scrise cu Bold exista deja:
Transparent data encryption |
External key management |
Data Auditing |
Hot Add CPU |
Transparent failover for Database Mirroring |
Automatic recovery from page corruption (Database Mirroring) |
Log stream compression (Database Mirroring) |
New Performance Counters for Database Mirroring |
Declarative Management Framework |
Server Group Management |
Streamlined installation |
Enterprise System Management |
Performance Data Collection |
System Analysis |
Data compression |
Resource Governor |
Query Optimization Modes |
Extended Events |
Logging Improvements (Minimal Logging = log only what is necessary for rollback) |
Entity Data Model |
Language Integrated Query (LINQ) |
Visual Entity Designers |
Entity Aware Adapters |
SQL Server Change Tracking |
Synchronized Programming Model |
Visual Studio Support |
SQL Server Conflict Detection |
FileStream data type |
Remote BLOB Store API |
Integrated Full-Text Search |
Sparse columns |
Filtered Indexes |
Large user-defined types |
Date/Time Data types |
LOCATION data type |
SPATIAL data type |
XML Enhancements |
Backup compression |
Partitioned table parallelism |
Star join query optimizations |
Resource Management |
Grouping Sets |
Change Data Capture |
MERGE SQL statement |
Scalable Integration Services |
SQL Server Integration Services (SSIS) pipeline improvements |
SSIS persistent lookups |
SSIS support for the new date/time data types |
SSIS VSTA support |
Analysis scale and performance |
Data Mining Algorithm Enhancements |
Block computations |
Writeback |
Enterprise Reporting Engine |
Better scale-out configuration |
Internet report deployment |
Manage the reporting infrastructure |
Report Builder enhancements |
Built-in forms authentication |
Report Server application embedding |
Office integration |
TABLIX |
FORCESEEK table hint |
Memory Related Dynamic Management Views |
Visual designer, and add nodes to a peer-to-peer replication configuration without stopping system activity |
Performance Studio to troubleshoot, tune, and monitor |
Table-valued parameters |
Transact-SQL Row Constructors (Table-valued constructors) |
Include Scalar Values in Row Constructors ( INSERT INTO MyTable (ColX,ColY)VALUES ((SELECT Top 1 ColZ FROM MyOtherTable), (SELECT Top 1 ColW FROM MyOtherTable));) |
One statement variable declaration/assignment |
Compound Assignment Operators |
HierarchyID data type |
Deprecation Counters |
Large User Defined Aggregates |
New versions of ODBC driver, OLE DB provider, and ADO.NET data provider |
SQLCE Version 3.5 |
Lock Escalation changes |
Intellisense |
Debug in SSMS |
Object Dependencies |
ORDPATH |
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro