(Jagadish Chatarji) In this series of articles, we shall concentrate on working with associative arrays in Oracle PL/SQL. Even though I start with simple examples in the first article of this series, I shall introduce you (in my upcoming articles) to the power of much more advanced techniques using
Other News
Test Driven Development with Visual Studio 2005 Team System
(Doug Seven) Test Driven Development (TDD) is not a new concept. In fact, the idea of test-first, code-second has been around for many years. In the latest release of Microsoft’s premier developer tool, Visual Studio 2005 Team System many new features have been added, including features for testing
Passing Information Securely Between ASP and ASP.NET
(Bryan Roberts) You can transfer information between systems using ASP.NET in multiple ways; however, many are cumbersome, complicated, or insecure. For example, many data transfer methods pass information in plain text, which makes the data vulnerable to both interception and misuse. This article
Building an XML Utilities Package, XML Debugger Part 1
(Lewis R Cunningham) Today we’ll start designing and coding our package. We need to remember to start simply and build it up as we go along. The design itself can be grown as issues arise. On a project involving multiple platforms and tens of people, if not hundreds, having a concrete design is i
How To Receive Data from a Single Table, concluded
(Bryan Sylverson) Figure 3-13 shows how to use the BETWEEN operator in a WHERE clause. When you use this operator, the value of a test expression is compared to the range of values specified in the BETWEEN phrase. If the value falls within this range, the row is included in the query results.
DB2 UDB security, Part 5: Understand the DB2 audit facility
(Ted J. Wasserman) The DB2 UDB auditing facility is an important security tool in the DBA’s toolbox. It generates and allows a DBA to maintain an audit trail for a series of predefined database events. It is capable of logging database events such as authorization checking, database object maintenan
Informix OnBar and TSM, Part 2
(Eric Herber) This is the second part of a two-part article series discussing the backup of the IBM Informix Dynamic Server (IDS) using IBM Tivoli Storage Manger (TSM).
Summary of Key User IDs for the Integrated e-mail Archiving and Records Management Solution
This technote summarizes the various user IDs used in the e-mail archiving and records management solution.
Tracking query execution with SQL Server 2005 Profiler
(Jeremy Kadlec) A single transaction in SQL Server is the lowest common denominator for performance tuning. When it comes to capturing and analyzing data at this level, the best native tool is SQL Server Profiler. Analyzing the results from SQL Server Profiler enables you to discern a great deal of
SQL Server 2005 Integration Services – Migration Tasks
(Marcin Policht) In the previous article of our series covering SQL Server 2005 Integration Services, we discussed Control Flow tasks designed to simplify the transfer of SQL Server objects (such as databases, user-defined error messages, and SQL Server Agent jobs). We will complete this overview by