(Srinath MS) Checking for Daylight Savings Time is one of the most common date checks developers perform. .NET provides an easy method to do this.
Other News
Just a few more words about multi-row processing
(Willie Favero) Continuing our conversation from Monday, I had just a few last thoughts on this subject (I assume they are my last thoughts on this subject but who really know for sure).
Thinking XML: Firefox 2.0 and XML
(Uche Ogbuji) Firefox 2.0 brought several important changes in its XML support. It’s currently reaching its peak in user deployment. Learn about updated XML features in Firefox 2.0, including a controversial change to the handling of RSS Web feeds.
Automatic Handling of DITA Docs In XML Editors
(Eliot Kimber) I’m in demo prep heck at the moment, trying to get some real DITA functionality built on top of Really Strategies’ RSuite CMS product. One of the key challenges here is integrating XML editors to handle this use case:
Managed BI Services: A Concept Map
(Harikrishna S. Aravapalli) While introducing a business intelligence (BI) center of excellent (CoE) Framework to one of the client’s CIOs, it came as an insight that most clients look at such offering as additional dollar costs to be invested on the technical aspect of the BI solution rather than o
Global Exception Handler for VB.NET
(Mark Dryden) I’ve been involved in an interesting post where a member wanted to create a Global Exception Handler. As an absolute purist of course, I recommend that an adequate testing phase should eradicate virtually all errors, barring those that are effected by outside elements, e.g. FileSystem,
Sending blob attachments in email with utl_smtp
(Rex Baldazo) Last time I showed how to send an html-formatted email from an Oracle PL/SQL application using utl_smtp. And I promised I would extend the package a little with a second method that would allow sending blob attachments in the emails. The most common application where I work is sending
DBMS_COMPARISON – to compare and synchronize tables (new in Oracle 11g)
(Lucas Jellema) One of the interesting new pieces of functionality in Oracle 11g is offered by the DBMS_COMPARISON package. This package allows us to compare two tables – or two views on tables – and inform us on the differences in data. More specifically: the package can summarize if there any chan
Using VIEW to reduce number of tables used
(Peter Zaitsev) Many Open Source software solutions use database per user (or set of tables per user) which starts to cause problems if it is used on massive scale (blog hosting, forum hosting etc), resulting of hundreds of thousands if not millions of tables per server which can become really ineff
Oracle Database 11g: Automatic SQL Tuning
(Jim Czuprynski) Oracle Database 10g offered Oracle database administrators the ability to analyze high-volume SQL statements and then derive and implement more efficient alternative execution plans called SQL Profiles to insure better query and DML performance. This article delves into a new Oracle