BACKUP AND RECOVERY
Get Smaller, Safer, Faster SQL Server Backups
Red Gate Software announced SQL Backup 3.0, software that provides compressed, encrypted backups for SQL Server 2000 databases. The product offers three levels of compression that let you choose whether to optimize your backup for speed or size. A user-friendly GUI lets you use wizards to walk through the backup and restore processes. A command-line interface lets power users set up maintenance plans by using syntax similar to T-SQL BACKUP and RESTORE commands. And an extended stored procedure interface lets you run SQL Backup remotely from your favorite database-connectivity tool. Other features in this release include 128-bit Rijndael encryption, the ability to create split or mirrored backups, MD5# tamper detection, and a simple log-shipping functionality that requires low setup overhead. Pricing for SQL Backup 3.0 starts at $295, and a free, fully functional 14-day trial version is available for download on Red Gate's Web site. For more information, contact Red Gate Software at 866-733-4283, 44-870-160-0037, firstname.lastname@example.org, or http://www.red-gate.com.
Get SOX in a Box
RippleTech announced its pre-configured Sarbanes-Oxley Section 404 compliance solution, LogCaster for Sarbanes-Oxley. Nicknamed "SOX in a Box," the product is an intelligent event-log-consolidation solution that lets you quickly implement the internal IT audit and reporting controls necessary for compliance. An easy-to-use interface lets you select the reports you need about the control of financial data, ensuring compliance while identifying areas of potential risk. In addition, the product provides instant access to audit data and gives you the ability to report on controls to meet Sarbanes-Oxley requirements. You can get the reports on demand or automatically in various formats. The product provides security features including security-event-log management; filtering, alerting, and validation of security-policies; instant access to security audit data for system and file access; and security-event-log consolidation. A free demonstration copy of the product is available for download. For pricing and other information, contact RippleTech at 866-739- 8587, 610-862-4000, logcaster@rippletech .com, or http://www.rippletech.com.
Ease Administration of Small and Large Business Databases
AquaFold announced Aqua Data Studio 4.0, a database query and administration tool that lets developers work with SQL scripts and visually modify database structures. Aqua Data Studio provides an integrated database environment that lets DBAs and developers perform multiple tasks simultaneously from one application. New features in the latest release include Visual Editing for Security, which lets you use simple forms to visually create, alter, and drop security objects such as SQL Server logins, roles, users, server roles, object permissions, and column permissions. An enhanced, customizable Query Analyzer lets you view the SQL editor and results in a split pane. Query Analyzer scripts now support four new client-side commands that let you execute a stored procedure with local variables bound to the parameters. And a new Export Tool lets you export the contents of any table or the results of any SELECT statement and save the data in a delimited text file or a file with INSERT statements. The latest release supports the newest versions of all major database platforms, including SQL Server 2005, IBM DB2 8.2, PostgreSQL 8.0, Sybase Anywhere 9.0, and MySQL 4.1. Pricing for Aqua Data Studio 4.0 starts at $149 per license. For more information, contact AquaFold at email@example.com or http://www.aquafold.com.
Create an Encryption Shield to Foil Intruders
ActiveCrypt Software announced SQL Shield 2.0, software that provides a layer of encryption in addition to SQL Server native encryption and renders SQL scripts impenetrable by any known decryptor. The software provides SQL Server 2000 and 7.0 and Microsoft SQL Server Desktop Engine (MSDE) servers with encryption for triggers, views, and procedures. SQL scripts encrypted with SQL Shield remain executable, so you don't have to restore them for execution every time you need to run them. Plus, installing the software doesn't affect settings and doesn't entirely replace default encryption options; users can always choose which encryption settings to apply. The latest release of the product features a new GUI that lets you quickly encrypt a single procedure or a whole database. Pricing for SQL Shield 2.0 starts at $249 for a single SQL Server 2000 license and $199 for a single SQL Server 7.0 license. For more information or a free evaluation copy of the software, contact ActiveCrypt Software at firstname.lastname@example.org or http://www.activecrypt.com.