Monitor Available Disk Space on SQL Server
Woodstone announced Servers Alive 4.0, a program that can monitor any Winsock service, ping a host, and determine whether a Windows NT service or process is running. Enhancements include a new interface, a new alerting engine, a built-in Secure Shell (SSH) server, and database-logging capability. You can use the software to retrieve a URL, check on your database, and report on your SQL Server, Windows, or Oracle server's available disk space. You can run Servers Alive natively as a service and monitor as many as 1000 hosts and services, including all TCP services such as POP3, SMTP, FTP, and DNS. Servers Alive 4.0 supports SQL Server 2000, 7.0, and 6.5 and costs $90 per license. Contact Woodstone at http://www.woodstone.nu.
Monitor SQL Server Transactions in Realtime
AppDancer Networks released AppDancer/FA, enterprise application flow and analysis software. The newest version lets you monitor SQL Server and Exchange Server transactions in realtime. AppDancer/FA not only monitors your devices, applications, and all associated IP flows, but it also lets you understand the inner workings of your network. The software can show you whether your network is suffering from overuse or incorrect use problems, which cause brownout conditions. The software supports SQL Server 2000 and 7.0. Pricing is $4995, and the annual support agreement costs $995. Contact AppDancer Networks at 770-643-6800 or http://www.appdancer.com.
Manage Your Database Through a Wireless Console
Expand Beyond announced PocketDBA 2.0, mobile software for database administration. You can now manage your mixed IT network from anywhere. By using PocketDBA, you can control your database from a wireless console such as a PDA. The software supports SQL Server, Oracle, and IBM DB2 Universal Database (UDB). You can keep your important business databases running at maximum efficiency. PocketDBA 2.0 supports SQL Server 2000 and 7.0. Pricing starts at $500. Contact Expand Beyond at 312-587-9990, 800-404-4059, or http://www.xb.com.
Scan for SQL Server 2000 SP3
Application Security announced that it has enabled AppDetective, vulnerability assessment software, to scan your SQL Server servers for SQL Server 2000 Service Pack 3 (SP3). By selecting a computed column that references a user-defined function (UDF), you can verify whether your SQL Server installation is vulnerable to a Denial of Service (DoS) attack. You can also check SQL Server to see whether database ownership chaining has been disabled. New AppDetective capability also verifies whether you've installed the patch that prevents an intruder from using an invalid OpenRowset command to reveal the account name that SQL Server runs under. For pricing, contact Application Security at 212-420-9270, 866-927-7732, or http://www.appsecinc.com.
Stop the SQL Slammer Worm
Ecora is offering a free SQL Worm Prevention Kit to protect network infrastructures from the SQL Slammer, or Sapphire, worm. The SQL Slammer worm enters networks through the Internet, looks for unpatched SQL Server 2000 databases, replicates itself, and starts sending out data that results in Denial of Service (DoS) failures. The free kit includes Ecora PatchLite, the patch to close the Slammer worm, recommended CERT guidelines, and step-by-step instructions about how to apply the patch. You can download the SQL Worm Prevention Kit at Ecora's Web site at http:// www.ecora.com/worm.
Detect Missing SQL Server Patches
Shavlik Technologies is providing free tools that can detect which SQL Server security patches are missing from your computers and servers and can guard against the SQL Slammer worm. You can download HFNetChkLT and HFNetChk.exe from the company's Web site. You can use the tools to determine which machines in your network are missing crucial patches. HFNetChk.exe is especially important because it searches for the SQL Server patches that Microsoft Windows Update doesn't support. Contact Shavlik Technologies at 651-426-6624, 800-690-6911, [email protected], or http://www.shavlik.com.
Collaborate About Projects and Tasks
SiteScape announced SiteScape Enterprise Forum 7.0, collaboration software that lets employees, customers, business partners, and suppliers easily communicate and share information in a Web-based environment. You can host online discussions, share and revise documents and files, chat, schedule meetings by using shared calendars, and organize tasks. You can set start and due dates, prioritize tasks, and monitor the progress of each task. Bookmarks provide you one-click access to frequently accessed discussions, documents, and calendars. The software now runs on SQL Server 2000, Oracle 8i, and FrontBase databases. Pricing is $99 per user. Contact SiteScape at 910-256-5038 or http://www.sitescape.com.
QUERY AND REPORTING TOOL
Drop Tables and Columns from Your Database into Multistep Queries
Austin Sierra Technologies announced Query Studio 1.1, a multistep visual SQL builder for Microsoft Visual Studio .NET that supports cross-database queries and cross-schema queries for database servers. You can drop tables and columns from your database into multistep queries without writing SQL or ADO.NET code. The software supports SQL Server, Microsoft Access, Advantage Database Server, IBM DB2, Oracle, and Sybase databases. Query Studio is available in two editions: Desktop and Developer. The Desktop Edition is available as a standalone application and costs $99. The Developer Edition integrates with Visual Studio .NET and costs $249. Contact Austin Sierra Technologies at 425-885-2100, [email protected], or http://www.querystudio.com.