(Gregory A. Larsen) In my first article in this series, I discussed different aspects of entering date/time data into SQL Server DATETIME and SMALLDATE columns. This article will expand my discussion of date/time data by exploring how to use different SQL Server functions to display dates and times
Author: SSWUG Research
Head-to-Head: Siebel vs. Oracle CRM
(Joe Outlaw) Siebel is still the undisputed CRM-application market leader when it comes to functionality. But, as market demand shifts away from pure CRM enablement and toward business-process automation, vendors with broader application footprints — like Oracle, for example — are growing in popul
How to Delete SQL Server Database Duplicate Rows from a Table
(David VanDeSompele) As much as we try and prevent it, duplicate data still finds its way into corporate data systems, but the good news is that purging duplicate rows can be a relatively simple task.
Optimize SQL Server Data Access
(Roger Jennings) Moving your data-access applications to ADO.NET and XML Web services from traditional ActiveX Data Objects (ADO) and OLE DB providers presents new challenges for you and your organization’s database architects and database administrators (DBAs). The .NET Framework’s System.Data.
Database consultants can’t wait FOR XML
(Dan Frumin) XML has penetrated every aspect of business applications, from data interchange to presentation logic using tools like XSLT. It seems that if an application doesn’t use XML, something is missing. But none of this is enough to unseat the reigning champion of storage: the database.
Raising the XML flag
(David Becker) The last time Microsoft updated its Office productivity package, one of the company’s most reliable moneymakers and one of its most mature and predictable products, the big news was the disappearance of Clippy, the animated helper customers loved to hate. This time around, XML pla
Updating XQuery
(Jason Hunter) In “X Is for XQuery” (Oracle Magazine, May/June 2003), I introduced XQuery, a technology under development by the World Wide Web Consortium (W3C) intended for querying and manipulating XML data or anything that can have an XML facade, such as a relational database. That introductory a
OLE DB Provider for Oracle
The Microsoft OLE DB Provider for Oracle provides access to Oracle databases. Using the Microsoft OLE DB Provider for Oracle, Microsoft SQL Server distributed queries can query data in Oracle databases.
Enforcing Business Logic using DB2 Triggers, Java UDFs, and the JavaMail API
(Kulvir Singh Bhogal) Newton’s third law states that for every action, there is an equal and opposite reaction. Don’t worry, I’m not giving you a physics lesson. In this article, I will be guiding you through the concept of cause and effect as implemented in a database application that brings togeth
Getting DB2 JDBC Drivers to Go
(CFGURU Blog) Following on from the recent snippet on Oracle, there’s been a thread on getting DB2 JDBC drivers to go. Turns out the DataDirect drvier suite has been updated and there’s a correction to the documentation to get DB2 on OS/390 going. If you have a hankering for all things DB2 read on.