(Matt Hines) Oracle released an updated version of its user authentication package on Aug. 16, adding a range of tools gained via the company’s acquisitions and its work to build additional security measures into other products.
Author: SSWUG Research
Learning and creating databases
(Scott Noyes) I have been working with a spreadsheet that records student performance. I have improved this spreadsheet to the point where I would like to create software. I was advised to learn Microsoft Access and then transfer created files from Excel. Considering the limitations of Access, I sho
Develop proof-of-concept .NET applications, Part 4: Wire your application to DB2 pureXML data
(Farzad Farahbod, Chat Chatterton and Chenhong Xia) This is Part 4 of a tutorial series that teaches you how to create proof-of-concept applications to access relational and XML data in IBM DB2 V9, using Microsoft Visual Studio .NET 2005. Part 1 explained the application specifications, database
TreeToTable makes hierarchical tables easy with SQLServer 2005 and C#
(Arjan Pot) Creating an hierarchical table in SQL Server is easy. But when it comes to using the data in SQL queries, it is clear that SQL offers limited support. The issue solved in this article is how to use hierarchical tables in easy to understand SQL statements. I present a C# CLR function that
Working XML: Expand RSS capabilities with RSS extensions
(Benoit Marchal) For all its popularity, the RSS standard is surprisingly simple and, one can even write, limited. RSS does not pretend to do many things, but it is designed to be extended through RSS modules. This article introduces three popular RSS extensions and explains how to design your own e
CodeSnip: Hiding Columns using GridView
(Sachin Dedhia) A simple technique for hiding certain columns in an ASP.NET GridView control. The secret is knowing when to set the Visible property to false.
Using Visitor Objects with MySQL Data Sets in PHP 5
(Alejandro Gervasio) If you’re looking for brand new material to help you expand your background in using design patterns with PHP 5, then hopefully this article will suit your needs. Welcome to the final installment of the series “Introducing Visitor Objects in PHP 5.” Composed of three chapters, t
Mini-Tip #2 – NVL2()
(Lewis R Cunningham) NVL2 is a neat little SQL function that I think is underused. It seems to me it could have a better name.
DB2 9 Fundamentals exam 730 prep, Part 5: Working with DB2 objects
(Hana Curtis) Learn about data types, tables, views, and indexes as defined by DB2 9. This tutorial explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL), and how they can be used in an application. This tutorial is the fifth in a series of s
How to configure SQL Server 2000 to use non-uniform memory access (NUMA)
In Microsoft SQL Server 2000, support for non-uniform memory access (NUMA) and locked pages was introduced in build 8.00.925. Therefore, you can install SQL Server 2000 Service Pack 4 (SP4) or a later version of SQL Server 2000 to use NUMA. NUMA support is only available on Microsoft Windows Server