(Mark Brunelli) Larry Ellison is going after Red Hat Inc. support customers in a big way. (R)
Author: SSWUG Research
Select Views: Oracle OpenWorld, SQL Server 2005, Data Explosions and more.
Pro-Center Video Programming for IT Professionals
XForms tip: Alerts and message boxes
(Nicholas Chase) XForms is about collecting data, but it is also about improving the user experience. In some cases, you need to provide additional information to the user outside of the actual form. In traditional Web pages, you accomplish this through the use of alert boxes and pop-up windows. In
Flexible fragmentation strategy in Informix Dynamic Server 10
(Ajaykumar Gupte) Consider the kind of application where data fragmentation is based on date expression, using a separate fragment for sales report for each day. Each day, the DBA needs to add a new dbspace for the date expression. If the application requires a large number of ranges in different fr
Set the current working path with VB.NET
(Irina Medvinskaya) An ability to set the current working path often comes in handy if a developer wants to be able to use relative paths instead of absolute paths in the code. In this tip, I explain how to set the current working path using VB.NET.
Malicious code injection: It’s not just about SQL anymore
(Bryan Sullivan) The good news: Developers are becoming increasingly aware of the threat posed by SQL injection attacks and the pitfalls of leaving pre vulnerable to such attacks. The bad news: there are other types of pre injection attack, including LDAP injection and XPath injection, that can be j
Accessing the Web.Config at Design Time for ASP.NET 2.0 Controls
(Damon Armstrong) One of the things that has always bothered me about the ASP.NET validation controls is that it sometimes takes two or three of them to validate a particular field. Say, for example, that you have a password field you want to validate. Normally it’s required, has a minimum and maxim
How to manipulate hierarchical information in flat relational database tables
(Akshay Srinivasan2) A simple table in a relational database is the employees table. This has an employee ID and a reports to ID which is an employee ID. The normal way to fill your tree with this hierarchical information is to query for the root nodes i.e. nodes with no parents in this case null in
Replacing xp_execresultset in SQL Server 2005
(Adam Machanic) SQL Server 2000 included a very useful extended stored procedure called xp_execresultset. This XP had two parameters: @cmd and @dbname. @cmd was expected to be a SELECT statement that would produce a single column of output, each row of which would produce a valid query. @dbname was
DB2 9 pureXML Guide
(Whei-Jen Chen, Art Sammartino, Dobromir Goutev, Felicity Hendricks, Ippei Komi, Ming-pang Wei and Rav Ahuja) IBM DB2 9 for Linux, UNIX and Windows marks a new stage in the evolution of data servers. IBM has continually led the data management industry with the release of innovative technology. DB2