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