(Alex Homer) Most data access technologies provide a way for you to query the schema of a database, and obtain information about the tables, stored procedures, data types, users, and other content of a database. However, the technique varies depending on the data provider or database driver you are
Other News
Rebuilding SQL Server Cluster Nodes
(Muthusamy Anantha Kumar) Active/Passive SQL Server 2000 clustering gives more reliability and fault tolerance to Production SQL Server environments. When a failure occurs, all of the resources fail over from the active node to the passive node and make the passive node active. This article expl
Towards a Semantic Web
(Greg Ross) The need to search and interpret machine-understandable data on the Web is becoming a high priority in a variety of industries–which is why Tim Berners-Lee’s vision of the Semantic Web could take the Web to a new level and open up entirely new fields of opportunity. (R)
Passing Parameters from One Page to Another
(John Tabernik and Scott Mitchell) Passing parameters from one page to another is a very common task in Web development. Granted, it’s importance and frequency has faded a bit with ASP.NET’s inherent preference for postback forms, but regardless, there are still many situations in which you need to
Recompile after reorg?
(Craig Mullins) Is it necessary to recompile and/or rebind a program after doing a reorg on a table that is used by the program to take advantage of the reorg? (R)
Thinking XML: Querying WordNet as XML
(Uche Ogbuji) WordNet is a Princeton University project that aims to build a database of English words and lexical relationships between them. Such a tool is an excellent basis for semantic application in XML, like the synonym-aware searching example that was presented in an earlier installment of t
An introduction to the benefits of online analytical processing (OLAP)
(Robert L. Bogue) To understand what OLAP is, you must first understand a few OLAP terms. OLAP works on facts, and facts are numbers. A fact could be a count of orders, the sum of the order amounts, or an average of order amounts. (R)
Convert Numbers into Words
(Murugesan Appukutty) This query converts numbers into their text equivalents.
Hacking Open Office
(Peter Sefton) If you are using any word processor or editor in a group situation, such as a technical writing team, or an office, then it will probably be in your interest to set up templates for authors to use to ensure consistency, reduce effort, and help automate conversation of documents betwee
Moving System Databases – A Checklist
(Christoffer Hedgate) Moving a database in SQL Server is normally as simple as detaching it from the server, moving it to it’s new location and then attaching it again. However, that only counts for user databases. Moving system databases requires quite a bit more work. Since I had to do this a