(Mike Hillyer) Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simpl
Other News
Create SQL Server Database Using C#
(Nguyen Thanh Phuong) In this presentation, I would like to show you how to create SQL Server Database using C#. Actually I had to deal with the problem when programming for our own specific DBMS.
Tool Kit Irons Out Wrinkles in Oracle E-Biz Suite’s API Functions
(Lisa Vaas) SmartDB Corp.’s latest version of its tool kit, SmartDB Workbench 10.0, promises to help systems integrators get their hands around the new API capabilities in Oracle E-Business Suite.
Can you add cluster nodes to an existing clustered SQL Server 2005?
(Larry Chesnut) I had a question come to me the other day. Can you add a node (from the SQL Server Point of View) to a cluster after it is already set up? Or put another way, if I add another node to the Windows cluster, how can a virtualized SQL Server be made able to use the newly added […]
IBM Launches SAP-Optimized DB2
(Barbara Darrow) IBM formally unveiled a version of its DB2 database that’s optimized to run SAP applications.
Transforming XML in Microsoft Access
(Simon St. Laurent) I mentioned in an earlier weblog that Access supported XSLT transformations on import and export through the GUI, but not through VBA. Here, extracted from something I wrote for Access Hacks, is a solution, if an imperfect one.
SQL Server 2005 Express
(Serdar Yegulalp) Along with the upcoming release of SQL Server 2005, Microsoft is introducing a new edition of SQL Server called SQL Server Express. (R)
Oracle Database Certified On 64-bit Windows Platform
Oracle has announced that its Oracle Database 10g and Oracle9i Database Release 2 are certified for clients on the new Microsoft Windows Server 2003×64 Editions and Windows XP Professional x64 Edition.
Building a data values dictionary with SQL
(Arthur Fuller) When a client asked a developer to construct a data values dictionary, the client was actually referring to a list of the distinct values in various columns and tables. Check out the basic SQL that was developed to fulfill this client’s request.
Text Configuration Files and XML
(Tony Lawrence) Configuration files are a problem for both operating systems and applications. Where do you keep them, how are they structured?