(Michael Klaene) In the previous article, I discussed the similarities and differences between the ASP.NET and JavaServer Faces frameworks. Two sample two applications were shown. One of the applications was developed using JSF and the other used ASP.NET. Both applications served the same functional
Author: SSWUG Research
Extending an ASP.NET Datagrid to Support Simple Cross Tab Reporting: The Structure
(Jagadish Chaterjee) This article guides you through developing your own ASP.NET custom control by extending the existing datagrid control (in ASP.NET). It mainly concentrates on Cross Tab Reporting with the ASP.NET data grid.
Don’t trust your MySQL general query log if you don’t trust your users
(Beat Vontobel) I just stumbled across a recently discovered security issue in MySQL when I made use of the general query log today (which is usually deactivated on our servers) to track down the behaviour of some legacy applications: If you grant access to possibly untrusted users, you shouldn’t co
Delete duplicate rows from a table
(Natalka Roshak) There’s an Oracle-specific trick to delete the duplicates from a table.
Part 2 – How to easily populate a table with random data
(Chris Eaton) I got a bunch of questions on how to expand on the idea I showed in part 1 on how to easily populate a table with random data so I thought I would post a part 2 to answer some of these questions. I’m going to add in two additional techniques.
Understand the impact of Sarbanes-Oxley compliance on your disaster recovery plan
(Mike Talon) No discussion of disaster recovery (DR) and compliance issues would be complete without looking at the Sarbanes-Oxley Act of 2002 (SOX). Originally designed to help avoid the irregular accounting situations made famous by companies like Enron, SOX was passed in 2002 to outline strict gu
Consuming a Web Service from a SQL Server 2005 CLR Assembly
(Julian Skinner) One advantage of CLR assemblies is the ability to consume web services from within the database. This wouldn’t be easy with T-SQL, and would also require a lot of work in an unmanaged extended stored procedure. With .NET, it’s almost as simple as accessing a local DLL.
X- and Y-Axis Transformations in SQL Server
(Alex Kozak) When I was writing code for user interfaces, I needed to present data in different ways. Logically it wasn’t difficult, but since the presentation layout was often quite different from the storage (tables’) structure, I had to use numerous record sets, loops, and arrays to manipulate th
Oracle releases out-of-cycle fix
(Robert McMillan) Oracle has released a critical security patch to the company’s E-Business Suite software.
Dr Michael Kay on Building XML Workflow Applications
A new tutorial entitled Building XML Workflow Applications, written by XML industry guru, Dr. Michael Kay — founder of Saxonica, the producer of the Saxon XQuery and XSLT processor — was announced today by Stylus Studio (http://www.stylusstudio.com), the industry-leading provider of XML development