(Mike McIntyre) This article and source code demonstrate how to use Visual Basic 2005 to compare two files to determine if they are equal. This comparison looks at file paths, file lengths, and file contents. NOTE: While source code for VB.NET is not provided, the CompareFiles function included in t
Author: SSWUG Research
SQL Server 2005 Integration Services – Part 41 – XML Task
(Marcin Policht) The importance of XML-based technologies is steadily increasing and this trend is reflected by a variety of new features in this category introduced in SQL Server 2005 Integration Services. One of the most prominent ones is the XML Control Flow task, which provides assistance with p
XForms tip: Using accesskeys for greater accessibility
(Tyler Anderson) XForms, the Web 2.0 of forms, could not possibly be Web 2.0 without providing accessibility features. I’m sure you’ve used the Alt key before, or accidentally typed it while typing up a document. The Alt key focuses in on the File tab at the top of most applications. XForms has simi
Data Bound Applications with ADO.NET and Custom Objects
(John Papa) The Windows Forms binding controls are vastly improved descendents of the data binding controls of the past. They get you going quickly and handle the redundant tasks associated with setting up forms, and you can customize and extend their behavior significantly. Data can travel in a var
Creating a Custom ExpressionBuilder in ASP.NET 2.0
(Bilal Haidar) A new feature in ASP.NET 2.0 has been introduced, the ExpressionBuilder. The ExpressionBuilder allows declarative binding for control properties for data that is coming either from the ConnectionStrings and AppSettings section of the web configuration file or from the web application
Designing High Performance Stored Procedures
(Gene Pinski) Managing large amounts of data is always a challenge. Several major database vendors claim that their database engines are ready for terabytes of data, which is true to a certain extent. However, when those terabytes are not static data, but live information that people update constant
MySQL Administration Via ColdFusion
(Raymond Camden) A user asked me if it was possible to backup and restore a MySQL database from ColdFusion.
Dynamic XML document construction with the PHP DOM
(Melonfire) When working with XML-based applications, developers often find themselves facing the requirement to generate XML-encoded data structures on the fly. Examples of this include an XML order template based on user input in a Web form, or an XML representation of a server request or client r
Accessing and Updating Data in ASP.NET 2.0: Declaratively Caching Data
(Scott Mitchell) The ASP.NET 2.0 data source controls provide a declarative means for accessing and working with data. Simply set a few properties of the data source control, bind it to a data Web control, and, voila, data is being retrieved and displayed without having written a single line of code
Simplify DB2 for i5/OS index advice
(Scott L. Forstie) Understanding and implementing the best SQL query optimization goal can improve many queries’ response time greatly. IBM DB2 for i5/OS on V5R4 delivers a new way to control query optimization through several popular dynamic SQL interfaces. This article shows how to implement the n