Includes all the features of the 2005 edition for SSMS 2008. Two new features included are Transparent Data Encryption (TDE) and Extensible Key Management (EKM). TDE performs real-time I/O encryption and decryption of the data and log files. EKM enables parts of the cryptographic key hierarchy to be managed by an external source such as Hardware Security Module (HSM), referred to as a cryptographic provider. Check out the Feature Comparison for more details.
Secure your sensitive data
Manage SQL security objects
Increase productivity & efficiency
A SQL Server Management Studio add-in that helps in the creation and modification of Service Broker objects. From creating service dependent objects like queues and contracts, to configuring each database instance of Service Broker. Service Broker Assistant also provides support for message types, XML schema collections, remote service bindings and routes. Check out the Feature Comparison for more details.
Manage Service Broker objects
Easily configure Service Broker
Manage event notifications
Generate CLR stored procedures and functions from existing procedures and functions in SQL Server. The code can be generated in C# or VB.net, compiled into an assembly and even create a Visual Studio SQL Server project with the generated code. See a Feature Comparison for more details.
Create projects to add custom business logic
Automatically compiles and generates assemblies
Supports C# and VB.net
Many database developers have T-SQL scripts scattered across directories and folders. Finding that one script that you need can be frustrating and time consuming. Enter SnipStorm Explorer, a Windows explorer for T-SQL scripts, or snippets. This tool only displays snippets that are stored on your hard drive for easy access and quick viewing. See a Feature Comparison for more details.
Explorer for T-SQL scripts
Online storage and access with SnipStorm.com
Available as Windows desktop app and SSMS addin