(Randall P. Spalten and Preethi Vishwanath) This article explains how to use the XML native data type in a non-Unicode database in DB2 Viper 2. Find tips on how to avoid substitution characters, pointers for query structuring and character reference usage, and explanations of the new utility user-de
Other News
Oracle Database: Rotating Tables
(JP Vijaykumar) I love carpentry. My favorite TV shows include “THIS OLD HOUSE” and “THE NEW YANKEE WORKSHOP”. I can make wooden rotating tables. But how can you rotate RDBMS tables?
Do you really know how for-loops work? How to speed up your for loops
(Jeroen van Wilgenburg) Did you know that the second parameter of a three parameter for loop gets executed on every loop? When this parameter is an expensive operation this could slow down your application. Of course I knew the second parameter gets executed every time, but I didn’t realize what kin
Declarative WCF Security
(Juval Lowy) Security is by far the most intricate area of the Windows Communication Foundation (WCF). In every WCF operation call on the service side, security is governed by the service contract, the operation contract, the fault contract (if present), the service behavior, the operation behavior,
Declarative WCF Security
(Juval Lowy) Security is by far the most intricate area of the Windows Communication Foundation (WCF). In every WCF operation call on the service side, security is governed by the service contract, the operation contract, the fault contract (if present), the service behavior, the operation behavior,
Hashing out the differences
(Jag Singh) In the ideal world the operational source would provide a mechanism for identifying changes made to the data since the last extract, also known as change data capture (CDC). The source may contain update date, database online log scrubbing mechanism, or audit logs, etc. for the purpose.
MERGE Without an INSERT — It’s Not Always Like an UPDATE
(Alex Fatkulin) Before you proceed with reading this post, I strongly encourage you to read Tom Kyte’s trilogy about write consistency, since I’ll do only a brief introduction to the subject.
Day 30 as DBA, Call for Questions for DBAs
Webcast: Day 30 as DBA This follow-on to the Day 1 as DBA show will go into the things you can do now that you’re semi-established in your routines. Daily maintenance, auditing, security checks, best practices and more. There is a lot to consider and think about when you’re putting a good foundation in place for your systems, we’ll cover […]
Are You A Real DBA??
Featured Article(s) Understanding Asynchronous Javascript and XML (AJAX) In the earlier days of classic web development scenario, every time a page was requested for, it had to be submitted to the web server. Hence, the application’s response time increased because of repetitive pages refreshes and reloads. Ajax is a cross-platform technology that can be utilized to make your web pages […]
Finishing an ASP.NET AJAX-based Application
(Xianzhong Zhu) In this third part of a three-part article, we finish our examination of three possible patterns for constructing a web application. To refresh your memory, we considered the pros and cons of each solution, and focused on rebuilding a legacy ASP.NET 2.0 web application in an AJAX for