John Paul Ashenfelter continues his SQL tutorial with one of the most useful but most frustrating areas of SQL: built-in functions.
Author: SSWUG Research
SQL Server Magazine LIVE!
Learn from and interact with the writers from Sql Server Magazine. Check it out for dates and location!
HLink working draft arrives
The HTML Working Group has published an initial Working Draft of HLink: Link Recognition for the XHTML Family, offering an answer to looming questions about the role of linking in XHTML.
Adventures in high-performance XML persistence, Part 2
By Cameron Laird – XML-oriented applications vary enormously in performance. This article, the second in a series on XML persistence, presents basic information you should know about XML parsing, including several principles for measuring XML parsing performance that are important for any XML develo
Oracle Report Card: DB software sails, cost fails
By Ellen O’Brien and Tim DiChiara – Seen as cocky, controversial and too costly by some, Oracle has its share of critics. The results of an exclusive SearchDatabase.com survey showed that the software giant still struggles against the perception that it is too pricey but that customers are largely s
Software Prevents SQL Database Intrusions
By Tom Smith – Entercept Security Technologies on Monday rounded out its line of intrusion-detection software with a new version of its product designed specifically to thwart common SQL database attacks.
HP Reports Strong Performance Figures For Linux-Based Oracle Clusters
Hewlett-Packard Co. on Monday disclosed performance-test figures based on widely used “TPC” metrics that could add support to the view of Linux as an enterprise-ready OS.
Can XML Web Services Offer a Standard Across Databases?
by Brian C. Reed – XML is often promoted as the standard format for exchanging data. But dig into how XML is actually being implemented by the database and tools vendors, and you will often find that XML is not necessarily being delivered in the interoperable way they might expect.
New Trace Flag to Enable Singleton Update for Transactional Replication
If you update any column that is part of a unique or clustered index, SQL Server implements the update as a deferred update. A deferred update means that the UPDATE is sent to the Subscriber as a pair of DELETE and INSERT operations.
Inside SQL Server 2000
Master the inner workings of today’s premier relational database management system with this official guide to SQL Server 2000, winner of SQL Server Central.com Reader’s Choice award.