DATABASE ADMINISTRATION
Work with Database Files
White Town Software announced shareware software for working with .dbf files. The product line comprises CDBF, a database-file viewer and editor; CDBFLite, which lets you work with database files by using the command line and the Internet; and CDBFAPI.DLL, a library of tools for working with database files. The software can export data in SQL for any SQL Server, HTML, or XML format. Contact White Town Software at [email protected] or http://www.whitetown.com.
Archive, Monitor, and Report on SQL Server
HybridX announced SQL Spy and SQL Insider, freeware software for archiving, monitoring, and reporting on SQL Server 7.0 and later databases. SQL Spy provides realtime monitoring of your database. You can graphically display lock and process actions in a moving line graph, capture SQL statements sent to your SQL Server, set warning limits for the number of locks and processes, kill connections to SQL Server, and receive notifications when data objects are added to SQL Server. SQL Spy also lets you monitor who is connected and for how long and what the CPU and memory utilization levels are. SQL Insider lets you manage object permissions, check the size and row counts of tables, search for words, scan passwords, and perform Internet keyword searches. Contact HybridX at [email protected] or http://www.hybridx.com.
Compare 2 SQL Server Databases
Adept SQL Tools announced AdeptSQL Diff, an application that lets
you visually compare two SQL Server databases, then produce and execute synchronization SQL scripts for the entire schema or just a selected part. AdeptSQL Diff scans both databases and displays the combined schema tree view. The application marks the differences with color so that you can compare SQL definitions of objects such as tables, views, and stored procedures side by side in a large panel to the right of the schema tree. If you have only one database, you can reverse-engineer your database schema. AdeptSQL Diff runs on Windows XP, Windows 2000, Windows NT, Windows Me, and Windows 98. Pricing starts at $240 for a personal license. LAN packs and site licenses are also available. Contact Adept SQL Tools at [email protected] or http://www.adeptsql.com.
Monitor Your Database
Pearl Knowledge Solutions announced SQLCentric, a Web-based, SQL Server-centric network database monitoring system that you deploy on your company's intranet. If any SQL Server or SQL agent in your network goes down or if drive space drops below a specified limit, SQLCentric will notify you by email or pager. SQLCentric features follow-up messaging, server grouping, and realtime drilldown. The Web interface uses color coding so that you can click any status light for full details. Pricing is per monitored server. Contact Pearl Knowledge Solutions at 917-499-7622 or http://www.pearlknows.com.
DEVELOPER TOOL
Maximize XML Developer Productivity
Altova announced XMLSPY 5, AUTHENTIC 5, and STYLEVISION 5, XML tools to maximize software developer productivity and help accelerate XML adoption in the enterprise. XMLSPY 5 is a development environment for designing, editing, and debugging enterprise-class XML applications. AUTHENTIC 5, which supports SQL Server 2000 repositories, is a document editor that lets users capture thoughts and ideas in XML format. STYLEVISION 5 provides conversion utilities for migrating HTML Web sites to XML-based sites. For pricing, contact Altova at [email protected] or http://www.altova.com.
Create Database Front Ends
Servoy announced Servoy R2, a development and deployment environment that lets developers create desktop applications, database front ends, and data-entry and reporting systems. Servoy R2 doesn't require you to install applications or Java Database Connectivity (JDBC) drivers on end-user machines. Servoy R2 connects to multiple data sources simultaneously and can combine data from multiple database servers into one application and report. Servoy R2 supports SQL Server, Oracle, IBM DB2, Sybase, MySQL, and Informix databases. For pricing, contact Servoy at [email protected] or http://www.servoy.com.
OLAP
Extend Analysis Services Functionality
Panorama Software announced Panorama NovaView BI Platform 3.5, analytical desktop software that extends the full functionality of SQL Server 2000 Analysis Services and SQL Server 7.0 OLAP Services. Enhancements include alerts, content delivery services, budgeting and forecasting write-back functions, drillthrough capability, data mining, custom rollups for financial analysis and reporting, dimension- and cell-level security, ragged-dimensions support, and server-based named member sets. NovaView's OLAP functionality includes reporting and highlighting, trend analysis, and hide and unhide capabilities. The software integrates with Microsoft Excel, Microsoft SharePoint Server, and Microsoft MapPoint. For pricing, contact Panorama Software at 805-980-4467 or http://www.panoramasoftware.com.
SECURITY
Protect Sensitive Data from Unauthorized Access
Protegrity announced that its Secure.Data for SQL Server 2000 has been certified for use with PeopleSoft AppConnect. The integration lets PeopleSoft customers using SQL Server 2000 use Secure.Data to protect sensitive data from unauthorized access. PeopleSoft AppConnect reduces the complexities of integrating multivendor applications at the people, process, and data levels. PeopleSoft AppConnect comprises three components (Enterprise Portal, Enterprise Warehouse, and Integration Broker) that use Internet architecture to connect your business operations in realtime. For pricing, contact PeopleSoft at 925-225-3000 or http://www.peoplesoft.com or Protegrity at 203-326-7200 or http://www.protegrity.com.
TECHNICAL RESOURCE
View a SQL Server Presentation
At the Black Hat Windows Security Conference, Application Security gave a presentation that illustrates many new SQL Server vulnerabilities. The presentation, "Hunting Flaws in Microsoft SQL Server," is available for no charge at http://www.appsecinc.com/news/briefing.html. Contact Application Security at 212-420-9270 or 866-927-7732.
