(Bruce Szabo) SQLCentric is a piece of software that makes it easy to report on the status of the SQL servers in a domain. The company claim is that when SQL is the center of your universe you need SQLCentric. The company that makes the software is Pearl Knowledge Solutions. SQLCentric provides
Other News
Adventures in Clustering on 8 Nodes
(Larry Chesnut) I imagine there are not too many of you out there who have the where-with-all to test out SQL 2005 Beta 2’s clustering abilities on an 8 node cluster. This is a new feature available to SQL 2005 and only when using Windows 2003 Enterprise or Datacenter editions.
XML-to-SQL Query Translation Literature: The State of the Art and Open Problems
(Rajasekar Krishnamurthy, Raghav Kaushik, and Jeffrey F. Naughton) Recently, the database research literature has seen an explosion of publications with the goal of using an RDBMS to store and/or query XML data. The problems addressed and solved in this area are diverse. This diversity renders i
XML for Client-Side Computing
(Coach Wei) XML is a simple, flexible text format initially designed for large-scale electronic publishing. It is flexible, open, and human-readable, and can be learned easily. XML can also be generated, parsed, analyzed, and transformed easily. It’s no wonder that XML has been widely used for s
DB2 UDB: The Autonomic Computing Advantage
Getting the most from today’s complex database systems is a challenge. Learn how self-managing capabilities in DB2 UDB v.8.2 do some of the work for you. (R)
ODBC programming using Apache Derby
(Rajesh Kartha) This article introduces you to ODBC programming with Apache Derby or IBM Cloudscape as the backend data source. You’ll learn how ODBC applications differ from embedded SQL applications, how to set up Apache Derby as an ODBC data source, and how an ODBC application is structured. In a
Trace File Manager: Managing Distributed Trace Files with Oracle and PHP
(Paul Gallagher) If you’re a DBA or a developer using Oracle-compliant tools, you almost certainly on occasion apply tracing to active database sessions, usually in the hunt for rogue SQL or some other coding misdemeanour.
INF: MDX: How to Determine the First or Last Member with Data
In some applications, it is useful to find the first or last dimension member that has data associated with it. This article illustrates how to use the HEAD(), TAIL(), and UNION() functions to return the first and last members of a dimension that have data. The article also illustrates the use of th
Introduction to Device Independence
(Peter Mikhalenko) Several years ago the only way to work with a web site was through a personal computer. There were different browsers, some of which were text-based terminals and others that were GUI apps. It was assumed that the “normal” user had a machine with a large color display with full gr
Have a Nice Date
(Alexander Kozak) Not too long ago, one of our project managers asked me if there was a SQL Server function to return just the date–without the time portion. I knew the answer, of course, because of all the times I’ve coded T-SQL workarounds like this: SELECT sampleDate = CONVERT(VARCHAR(50), Da