By Ellen O’Brien – By now, in-memory databases were supposed to be all the rage. In the late 1990s, when hard drives were smaller than they are now, and industry analysts were predicting huge demand from Web-based businesses in need of high-transaction, 24/7 caching capabilities, it seemed in
Other News
Invoking IMS Apps using DB2 II Technology
Do you want to know how to build a UDF in DB2 capable of invoking an IMS application using a Web Service? This tutorial will show you how.
Sample SQL Server Disaster Recover Plans
Learn how other companies put together their SQL Server disaster recovery plans.
Table Access During Index Build
Q. As you’re building an index on a table, does SQL Server block access to that table?A. SQL Server doesn’t block read access to the table you’re building an index on unless you’re building a clustered index. However, if someone tries to update the table’s data, SQL Server blocks the update—
TIPS TO HELP STUDENTS PASS ORACLE9i DBA EXAM 1
Expect to answer 60 multiple choice questions within 120 minutes. To pass the exam, you need to answer at least 42 questions correctly (70%). Specifically, the exam tests you about the following categories of information:
Procedure to Reverse a String
by Chacravarthi Ramasami – The following tip uses a procedure that reverses a string provided as an argument.
Grid Computing: The Next Big Thing
By Brian Moran – Currently, Microsoft doesn’t have a grid-computing story to tell in the SQL Server space. Oracle has been talking nonstop. SQL Server users will be faced with hard choices if Oracle delivers a commodity grid-computing solution years ahead of Microsoft.
Character Encoding of XML Names and Conversion of Data Types
Describes how the XmlConvert class encodes and decodes names in XML data.
Write Better C# Documents
by Bill Wagner – The C# compiler produces XML documentation files from your comments. NDoc, an open source tool, takes that output and produces a Windows help file for your class libraries.
When to use local and global declarations
by Benoît Marchal – W3C XML Schema offers many powerful options for structuring and organizing your XML vocabularies. In this tip, Benoit compares global and local declarations of elements, and provides pointers on when to use which.