Part of Dorian Software's security event-management package, Event Rover makes it easy to view, sort and mine event-log data. Offering a convenient tree view to facilitate the creation and review of reports, the product sorts and dynamically regroups data from active and saved event logs as well as compressed archives. It provides summary information to the administrator when the log is opened, including log size, the number of events in total and by type, and user-account data. Starts at $249.99 for 10 machines. Dorian Software Creations, (678) 222-3443 internationally, (866) 682-3646 in North America. www.doriansoft.com/eventrover
AppRiver SecureTide
SecureTide, a hosted e-mail virus- and spam-prevention service, addresses concerns about productivity, corporate privacy and legal liability. Through keyword/phrase tracking, SecureTide identifies suspect e-mail messages, then blocks or redirects them. It can also ban EXE, MP3 and WAV files. LDAP mirroring automatically updates e-mail server address changes. Armed with 60 spam-filtering techniques, SecureTide offers multiple antivirus engines and proprietary work- , virus- and phishing-detection systems, as well as perimeter security to guard against denial-of-service attacks. $675 per year for 50 users. AppRiver, (850) 932-5338. www.appriver.com
dtSearch Corp. Network 7.0
This text-search software instantly combs through more than a terabyte of text in less than a second, up from 8 GB in previous versions. Functioning across the desktop, network, Internet or intranet, Network 7.0 can span any number of indexes in a single search. Among its components is dtSearch Spider, which can follow links within a Web site or across multiple sites to retrieve integrated relevancy rankings and other displays of local and spidered content with highlighted hits. Other components include dtSearch Web for Web publishing and dtSearch Desktop for searches on PCs. Starts at $800 for five users, with multiuser discounts. dtSearch Corp., (800) 483-4637. www.dtSearch.com
Bluestream Database Software Corp. XStreamDB 3.2 Native XML Database
This native XML database is among the first commercial implementations of XQuery for XML databases, with extensions for updates and full-text searches. Version 3.2 performance improvements, achieved through precompiled XQuery functions, increased the speed of operations by 30 times in company tests. Security changes include the addition of group security functions, improved system table security and extended operation permissions. $3,000 per copy. Bluestream Database Software Corp., (604) 669-4469, Ext. 102. www.bluestream.com
Thursday, July 28, 2005
Microsoft's SQL Server 2005
It's been about five years since the last major upgrade to SQL Server--time enough for Microsoft to update just about every component of the database platform and incorporate many new features.
T-SQL Developments
On the database development front, SQL Server 2005 provides more T-SQL (Microsoft's extension to SQL) functionality--enhancements that fill in some of the holes found in SQL Server 2000. T-SQL now has a ranking function, for example, that lets you return a specific group of records from a large query. With 2000, developers had to create temporary tables, then filter out what wasn't needed--not very efficient.
XML Support
SQL Server 2005 includes much more support for XML data than 2000, including a new XML data type that can hold XML documents or XML fragments (XML without a top-level element) to be stored in a column, parameter or variable. The XML data can be retrieved or updated with XQuery or XML DML (Data Modification Language).
Integrated .Net Support
SQL Server is now integrated with .Net CLR (Common Language Runtime), which controls tasks such as memory management and code compilation. This gives SQL Server the power of full-fledged development languages like VB.NET and C#.NET to create stored procedures, triggers and user-defined functions.
Keep It Safe
Microsoft's security problems keep it vigilant. The new default installation of SQL Server 2005 disables many services and features that were typically enabled in SQL Server 2000, including remote named pipes, TCP and HTTP connections, OLE automation and the xp_cmdshell extended stored procedure. Although these are disabled by default, Microsoft says an upgrade installation will leave enabled most of what you had enabled. Also, these services and protocols can be managed using the new Surface Area Configuration tool.
T-SQL Developments
On the database development front, SQL Server 2005 provides more T-SQL (Microsoft's extension to SQL) functionality--enhancements that fill in some of the holes found in SQL Server 2000. T-SQL now has a ranking function, for example, that lets you return a specific group of records from a large query. With 2000, developers had to create temporary tables, then filter out what wasn't needed--not very efficient.
XML Support
SQL Server 2005 includes much more support for XML data than 2000, including a new XML data type that can hold XML documents or XML fragments (XML without a top-level element) to be stored in a column, parameter or variable. The XML data can be retrieved or updated with XQuery or XML DML (Data Modification Language).
Integrated .Net Support
SQL Server is now integrated with .Net CLR (Common Language Runtime), which controls tasks such as memory management and code compilation. This gives SQL Server the power of full-fledged development languages like VB.NET and C#.NET to create stored procedures, triggers and user-defined functions.
Keep It Safe
Microsoft's security problems keep it vigilant. The new default installation of SQL Server 2005 disables many services and features that were typically enabled in SQL Server 2000, including remote named pipes, TCP and HTTP connections, OLE automation and the xp_cmdshell extended stored procedure. Although these are disabled by default, Microsoft says an upgrade installation will leave enabled most of what you had enabled. Also, these services and protocols can be managed using the new Surface Area Configuration tool.
Subscribe to:
Posts (Atom)
Posts
