(Kent Milligan) SQL user-defined functions (UDFs) have been available since OS/400 V4R4. UDFs provide a great tool for allowing you to easily perform a business calculation as an SQL query, processing a set of rows in your database. If you want an explanation of how to implement UDFs, take a loo
Other News
Integrate DB2 Express-C into service-oriented applications using ActiveGrid LAMP Studio
(Wendy M. Schott) The recent release of IBM DB2 Express-C is another strong endorsement for LAMP (Linux, Apache, MySQL, Perl/PHP/Python) as a compelling, lightweight enterprise application platform. Enterprise developers today are increasingly using LAMP to integrate Web services and databases on th
Managing Oracle Portal
(Aradhana Puri) Oracle Portal, part of Oracle Fusion Middleware, is a Web-based tool for building, deploying, and maintaining self-service and integrated enterprise portals. It also provides services that enable you to perform configuration and administrative tasks. To perform most configuration and
Password cracking tools for SQL Server
(Kevin Beaver) If you’re performing a penetration test or higher-level security audit of your SQL Server systems, there’s one test you must not miss. It seems obvious, but many people overlook it: SQL Server password testing. Given the inherent weaknesses compared with more secure Windows authentica
Calling an Arbitrary Web Service
(Scott Golightly) Test Web Services quickly and more efficiently without having to write full-blown applications each time by using .NET reflection and the CodeDOM to dynamically generate a proxy to a Web Service.
Wonders of the OUTPUT Clause in SQL Server 2005
(Jagadish Chaterjee) This article mainly focuses on the new “output” clause introduced in Microsoft SQL Server 2005. In this article I shall also teach you about producing output for DML statements, which could not be done in any of the previous versions of SQL Server. I shall give examples of sever
What happens when SQL Server executes a query/stored procedure?
(Jugal Shah) SQL Server performs a couple of internal steps before executing a query. The steps that interest us here are compilation and execution.
Having fun with the XmlSchemaProvider: Serializing object trees
(Wouter van Vugt) About a year ago, I became very enthusiastic. I found a new attribute in the framework which allows me to determine the WSDL contract which describes my objects. Used in conjunction with the IXmlSerializable interface, I can also make sure the serializer pumps out the correct XML,
Golden’s Rules: Migrating from SQL Server to MySQL
(Bernard Golden) Databases are a key piece of every organization’s software infrastructure. They are complex pieces of software that we rely on to rapidly spit out data in response to queries and to reliably track transactions, never losing track of the fact that a payment has been made (or received
Why XML transformation via XSLT in the browser is limited
(Tony Patton) The last couple of weeks we’ve examined the AJAX approach to browser-based development with the XMLHttpRequest object and JavaScript. While working with XML data is straightforward, you can easily manipulate XML with XSLT stylesheets. However, using XSLT in the browser is limited, so s