Microsoft SQL Server 2005 Microsoft Corporation Microsoft SQL

Microsoft SQL Server 2005 Новые возможности Андрей Синкин Microsoft Corporation

Продукты Microsoft использующие SQL Server Analysis Services MSDE Reporting Services Commerce Server (DM) MSTV Axapta Biz# Biz. Talk Commerce Server (OLAP) FRx MBS (Green) Navision Project Share. Point Visual Studio Office (Excel) . NET Framework SDK Active Directory Migration Tool Application Center 2000 ASP. NET Web Matrix Project Automated Deployment Systems Back Office Server Biz. Talk Server 2002 Partner Edition CRM for Great Plains CRM Sales for Outlook Great Plains Standard Host Integration Server 2000 Internet Acceleration Server 2004 Longhorn Driver Kit Navision Axsapta Office Live Communications Server 2003 Office XP Developer, Professional Operations Manager 2000 Project Server 2003 RMS Headquarters RMS Store Operations Rights Management Server Sharepoint Portal Server Small Business Server 2003 Ultralight Visio 2000 Enterprise Edition Visio Enterprise Network Tools 2002 Visual Studio. NET Standard, Pro, Acad. , Ent Visual Studio Professional (and above) Visual Studio Tools for Office Windows XP Embedded Tools with SP 1 … plus eight others Biz. Talk Biz# Commerce Server Data Protection Server Excel Server MBS CRM MBS Enterprise Reporting / FRx MBS Payroll MBS PSA Time and Expense Microsoft Business Framework Operations Manager (MOM) Project Share. Point Portal Server / Report Center SMS Speech Server SQM (Windows Client) Visual Studio Burton Visual Studio Whitehorse Baseline Security Analyzer Microsoft Management Console Visual Studio Express DTS Commerce Server (2000) FRx Host Integration Server Navision BI Apps – EIP (2005) Biz# Navision Project Share. Point Portal Server SQM (Windows Client) SMO MBF Visual Studio VDT SQL Server Express Visual Studio SQL Server Biz. Talk Server Commerce Server CRM MOM MSN WMSDE ACS ADS SRMS UDDI WSS WUS

Source:

Source:

SQL Server 2005 . NET Framework Database Maintenance Replication Common Language Runtime Integration Backup and Restore Enhancements Auto-tuning Replication Agents User-defined Aggregates Checksum Integrity Checks Oracle Publication User-defined Data Types Dedicated Administrator Connection Improved Blob Change Tracking User-defined Functions Dynamic AWE OLAP and Data Mining SQL Server In-Proc Data Provider Fast Recovery Analysis Management Objects Extended Triggers Highly-available Upgrade Windows Integrated Backup and Restore Data Types Online Index Operations Web Services/XML for Analysis File Stream Storage Attribute Online Restore DTS and DM Integration Managed SQL Types Parallel DBCC Eight new DM algorithms New XML Datatype Parallel Index Operations Auto Packaging and Deployment SQL Server Engine Management Tools Data Transformation Services New Message Service Broker MDX Query Editor New Architecture (DTR + DTP) HTTP Support (Native HTTP) MDX Intellisense Complex Control Flows Database Tuning Advisor T-SQL Intellisense Control Flow Debugging Enhanced Read ahead & scan Version Control Support For Each Enumerations Extended Indexes XML/A Property Mappings Multiple Active Result Sets SQLCMD Command Line Tool Full Data Flow Designer Persisted Computed Columns Performance Tuning Full DTS Control Flow Designer Queuing Support Profiler Enhancements Graphical Presentation of Pkg Execution Snapshot Isolation Level Profiling Analysis Services Immediate Mode and Project Mode Scale Up Partitioning Exportable Showplan Package (Advanced) Deployment Tools VIA support Exportable Deadlock Traces Custom Tasks and Transformations NUMA support Full-text Search Reporting Services Database Failure and Redundancy Indexing of XML Datatype Multiple Output Formats Fail-over Clustering (up to 8 node) MDAC Parameters (Static, Dynamic, Hierarchical Hierarchica Enhanced Multi-instance Support Side by Side installation Bulk Delivery of Personalized Content Database Mirroring Microsoft Installer base setup Support Multiple Data Sources Database Viewpoints Support for Active Directory Deployment Sharepoint Support XML SQL Client. NET Data Provider Visual Design Tool XQUERY Support (Server & Mid Tier) Server Cursor Support Charting, Sorting, Filtering, Drill-Through XML Data Manipulation Language Asynch Scheduling, Caching FOR XML Enhancements Security Complete Scripting Engine XML Schema (XSD) Support All Permissions Grantable Scale Out architecture MSXML 6. 0 (Native) Fine Grain Administration Rights XML Report Definition XQuery Designer Separation of Users and Schema

Report Builder Client

Report Builder View

Model Designer

Полезные ресурсы Официальная страница http: //www. microsoft. com/sql SQL Server Reporting Services на MSDN http: //msdn. microsoft. com/library/enus/RSPORTAL/HTM/rs_gts_portal_3 vqd. asp Российское сообщество по SQL Server http: //www. sql. ru/