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 info@whitetown.com 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 rvallee@hybridx.com 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 info@adeptsql.com 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 sales@altova.com 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 sales@servoy.com 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.