This section describes features specific to the Microsoft SQL Server family of databases.
Horizontal Partitioning
Horizontal positioning in MS SQL Server 2005 is a method for making large tables and indexes more manageable by dividing them horizontally and spreading them across more than one filegroup in a database.
Common Language Runtime (CLR) Integration
CLR integration means that stored procedures, triggers, and user-defined types, functions, and aggregate functions can be written for SQL Server in any .NET language, such as VB .NET or C#.
Encryption
SQL Server 2005 uses a new security infrastructure that supports hierarchical encryption and key management.
Full Text Search
SQL Server 2005 supports full-text queries against a table's plain character data. PowerDesigner supports this feature through the full text catalog and full text index objects.
XML Indexing
SQL Server 2005 provides improvements in indexing XML data. PowerDesigner supports these new features through the XML index object.
XML Data Types
The new XML data type allows you to store XML documents and fragments in a SQL Server 2005 database. PowerDesigner supports this through new column properties and the XML schema collection object.
Database Mirroring
SQL Server 2005 supports database mirroring, in which the principal server sends, in real-time, blocks of its database log records to the mirror instance which, in the event of failover, can be made available within a few seconds.
Service Broker
The service broker manages a queue of services. Applications that use Service Broker communicate by sending messages to one another as part of a conversation. The participants in a conversation must agree on the name and content of each message. PowerDesigner supports service broker through the following objects:
Resource Governor
Resource Governor, available in SQL Server 2008, lets you limit resource requests by workloads for CPU time and memory to optimize their allocation. PowerDesigner supports Resource Governor through the following objects:
Synonyms
PowerDesigner supports SQL Server 2005 synonyms through the standard synonym object.
SQL Server 2000 Analysis Services
The OLAP Services feature from SQL Server v7.0 is called Analysis Services in SQL Server 2000. PowerDesigner supports analysis services through an add-in.
Microsoft SQL Server 2005 Analysis Services
PowerDesigner allows you to retrieve multiple dimension objects in a PDM in order to build cubes, and to create a new multiple-dimension diagram. From this diagram, you can generate cubes to a Microsoft SQL Server 2005 Analysis Server (SSAS).