These questions are similar to what you can expect during a real interview. Being prepared will enable you to think on your feet. The suggested replies aren’t intended to give you one correct answer. Rather, the answers should reflect your personal frame of reference, based on your motives, goals, w
Other News
The FROM Clause
I was digging through Books Online the other day and I ended up on the FROM clause. I was expecting a simple little entry but that wasn’t quite what I found …
David Litchfield and Co. Continue to Pound Microsoft – No Patches in Sight for Existing Holes
From SQLSecurity – NGSSoftware releases yet another SQL Server 2000 buffer overflow with exploit code written in T-SQL (not too shabby). The hole affects the OPENDATASOURCE function when invoking the Jet data access provider. Microsoft’s solution – download the latest Jet version. Does this strike a
Oracle cuts rewards for last-minute deals
By Alorie Gilbert – Known for its aggressive, high-pressure sales practices, Oracle decided last year to discontinue certain incentives, including steep end-of-quarter discounts and higher fourth-quarter commissions, that encouraged customers and salespeople to cram deal-making into the final days o
How to query using special characters in Oracle
by AMIT PRASHANT – Here is how to query an Oracle database with special characters. First, create this test table:
OASIS Creates Controlled Trade Committee
By Clint Boulton – CTML will invoke features of other XML business vocabularies and provide an interface to supporting specifications. The CTML committee will align its work with other OASIS libraries and frameworks, such as ebXML, Universal Business Language (UBL), Business Transactions Protocol (B
Where is the XML in the database?
By Charlie Garry – META Trend: By 2005/06, Intel-based servers will dominate at the DBMS tier. Scale-out database configurations will grow in popularity as management virtualization improves, but remain primarily a high-availability option. By 2004, XML-based content storage and rendering will becom
Can XML Be The Same After W3C XML Schema?
by Eric van der Vlist – The “observation” of a XML document made by a schema processor changes the document, and schemas bias our perception of XML documents. This prompted me to ask the question: can XML be the same after W3C XML Schema?
SQL Server 2000 Optimization Tips
Here is a useful list of tips for SQL Server 2000 optimization.
Billions lost to poor data quality
By Sara Cushman – Good, clean data is sort of like good taste. Many people believe they have it. Plenty don’t. It’s also wildly subjective; the definition of quality data varies from business to business.Data quality problems, though, have far more dangerous and costly consequences than serv