(John D.) In this article we’ll create a simple database in Microsoft Access and then create a user interface in Visual Basic 6.0.
Author: SSWUG Research
CASE Function in SQL Server 2005 – part III
(Muthusamy Anantha Kumar) In Part I and Part II of this series, we have illustrated how to use simple case expressions in queries. In this installment, I am going to illustrate how to use case functions in clauses such as group by.
11i: Encrypted Password String Disclosure
Integrigy has released an advisory regarding an undisclosed security vulnerability in Oracle Applications 11i that may allow an unauthenticated, internal attacker to obtain Oracle Applications’ user account encrypted password strings, which in turn can be decrypted using previously published informa
Sub-templates and More with Oracle HTML DB
(Lawrence Linnemeyer and Bradley Brown) In this third part of a three-part article covering Oracle HTML DB, you’ll learn about sub-template definitions and more.
Studying design patterns in VB.NET
(David M. Simmonds) Design Patterns in VB.NET is specifically designed to help Software Architects and Programmers to take advantage of GoF design patterns so that they can build software which is flexible and easy to maintain. You will find that application of the concepts which you learn in this s
SQL Server 2005: Creating Scalar User-Defined Functions from Assemblies
(Robert Vieira) Scalar functions are not much different from stored procedures. Indeed, for the most part, they have the very same differences that the T-SQL versions.
Multiple installations of DB2 9 with SAP on Linux and UNIX
(Marianne Nesiem and Lili Zhang) One of the many enhancements of IBM DB2 9 for Linux, UNIX, and Windows is the ability to install multiple copies of the DB2 software on the same server. In this article, you’ll follow step-by-step instructions to learn how to take advantage of this enhancement in an
A Smoother Change to Version 2.0
(Marc de Graauw) “Ch-ch-ch-changes” sang David Bowie, “Just gonna have to be a different man. Time may change me but I can’t trace time.” It’s a great idea for a song, but when moving to the next version of an XML-based exchange, we would like a transition with less stutter. However, this is not ea
Accessing and Updating Data in ASP.NET 2.0: Programmatically Accessing Data using the Data Source Controls
(Scott Mitchell) Working with data in ASP.NET version 1.x required writing data access code. This involved establishing a connection to the database, specifying the SQL command, and then executing the command. ASP.NET 2.0’s data source controls greatly simplifies this process by encapsulating the da
Optimize merge replication performance
(Hilary Cotter) Merge replication has been a feature of SQL Server since SQL Server 7.0. It is designed for clients who are frequently offline and need to bi-directionally replicate with a publisher. (R)