by Joe Lax – SQL Server and Oracle each have very different methods for maintaining data constancy when accessed by concurrent users. Oracle maintains a snapshot of the data, which prevents queries from hanging without stooping to “dirty reads.” Find out how it works.
Other News
SQL Server 7.0 Security Modes
By Alexander Chigrik – There are two security modes (authentication modes) in SQL Server 7.0:Windows NT AuthenticationMixedThe security mode is selected during SQL Server 7.0 installation and can be modified at any time. To change the security modes, you can do the following:
Build an Intranet Site with SQLXML and Visual Basic .NET
This sample app demonstrates how to use SQLXML 3.0 and Visual Basic .NET to create a Web-based tool for managing projects and tasks, thus improving team productivity.
Report: Hole found in Excel
By Matt Loney – A security hole in Microsoft's Excel XP spreadsheet application could allow hackers to take over a user's PC by using specially formed XML stylesheets.According to security expert Georgi Guninski, the problem occurs when a user opens an Excel spreadsheet file and choo
Insatiable SVG
If you think of SVG as a toy technology to draw nice pictures, wake up! SVG is invading your cell phone and this "graphical XML" might wipe out "text XML" (such as XHTML and XSL-FO), just as graphical user interfaces have wiped out text-based user interfaces.
Altova Inc., Announces DocBook Support And Web Services Interoperability Enhancements In XML Spy 4.4 Suite
Altova, Inc. (www.xmlspy.com) today announced the release of the XML Spy 4.4 Suite, a comprehensive product-line of developer tools for advanced XML application development, consisting of the XML Spy 4.4 Integrated Development Environment (IDE), the XML Spy 4.4 XSLT Designer, and the XML Spy 4.4 Doc
Oracle releases 9i database upgrade
By James Niccolai – ORACLE RELEASED AN upgrade to its Oracle9i database product to developers, adding new XML (Extensible Markup Language) capabilities and other enhancements that it hopes will help it recover ground lost to competitors.
Identify an object’s locks in the database
By Ofer Harel – Here are two simple scripts to identify an object’s locks in the database. Whenever a user complains that there’s a session locked, I use these scripts to find out if there are object locks.
XML from SQL Server
With this download, Josh Sullivan – the winner of our VBeXpress competition – demonstrates how his easy-to-use class makes it a breeze to work with the XML features of SQL Server 2000.
Statistics in SQL (Sample Chapter)
Book By Ales Spetic, Jonathan Gennick – The recipes in this chapter show you how to effectively use SQL for common statistical operations. While SQL was never designed to be a statistics package, the language is quite versatile and holds a lot of hidden potential when it comes to calculating the fol