Devenius Software Development

SQL Encryption Assistant is a SQL Server Management Studio addin that simplifies the management of asymmetric keys, symmetric keys and certificates. Backup your certificates, service master keys and database master keys using this SSMS addin. Add signatures to your stored procedures, functions, triggers, and assemblies. You can even encrypt your sensitive data stored inside SQL Server. SQL Encryption Assistant supports SQL Server 2005 and 2008 as well as Visual Studio.

Read More!

Perform encryption key management inside SQL Server with this Free tool. Basic Edition lets you create, alter, and drop your encryption keys and certificates. The built-in object explorer lets you view and manage your keys.

Standard Edition adds features that make key management in SQL Server easier. You can view key dependancies, connect to multiple servers simultaneously, auto generate scripts, and manage an unlimited number of keys and certificates.

Professional Edition provides access to all features. With the professional edition you can now digitally sign your stored procedures, functions, triggers, and assemblies, as well as the ability to encrypt your sensitive data. Generate scripts for versioning purposes.

Professional 2008 Edition has 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.

Ever find that that a stored procedure could use a makeover? Maybe a little better performance is needed, or some custom business logic is required? The answer..CLR stored procedures. Leverage the CLR (the Microsoft .NET Common Language Runtime) and all that managed code has to offer. Managed code is better suited than Transact-SQL for calculations and complicated execution logic. With the functionality found in the .NET Framework Library, you have access to thousands of pre-built classes and routines. In just a few clicks, SQL.CLR can generate a CLR procedure in C# or VB.net, a compiled assembly and a project for adding additional logic.

Read More!

SQL.CLR supports SQL Server 2005 and 2008 as well as Visual Studio.

Our latest idea focuses on SQL Server Broker Service. With Service Broker, a feature in Microsoft SQL Server 2005/2008, internal or external processes can send and receive guaranteed, asynchronous messages. This new technology, a part of the Database Engine, provides a message-based communication platform that enables independent application components to perform as a functioning whole. Service Broker includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications. Service Broker reduces application development time by providing much of the infrastructure that is necessary to build a distributed application. Service Broker also makes it easy to scale your application up or down to accommodate the amount of traffic the application receives. This add-in will assist in the development of all relevant objects dealing with the Service Broker.