(Arthur Fuller) With a little creative thinking about particular business problems, you can often devise a solution in SQL. For instance, companies can choose between two methods to reconcile charges with payments. The first method (known in Canada as Open Item) means that you match payments against
Author: SSWUG Research
SQL Server 2005 DDL Trigger Workbench
(Robyn Page and Phil Factor) How about automatically tracking and logging all database changes, including changes to tables, views, routines, queues and so on? With SQL Server 2005 it isn’t that hard, and we’ll show how it is done. If you haven’t got SQL Server 2005, then get SQL Server Express for
IronXSLT: Changing the Way You Work with XSLT in Visual Studio
(Oleg Tkachenko) Yes, I’m trying to change the way you work with XSLT in Microsoft Visual Studio. It must be a pleasure to develop and rocket fast at runtime. Yes, Visual Studio already supports editing, running and even debugging XSLT, but it’s still a painfully limited support. So I’m started buil
Rails and DB2 data types
(Leons Petrazickis) When creating a table in a Rails migration, you have to specify data types using platform-agnostic names.
It’s All About the Scripts
(Dan Wahlin) AJAX-enabled Web sites rely heavily upon JavaScript. Without JavaScript, Web pages that leverage AJAX are practically rendered useless. While writing JavaScript code is fairly straightforward, writing and managing cross-browser AJAX scripts can be challenging — this is where the ASP.NET
How to get the today’s date in MDX
(Mosha Pasumansky) The question in the title of this post is a popular one. There are many scenarios, where it is desirable to navigate to the member of the Time hierarchy which corresponds to the current day, month or year. Sometimes, there is a desire to set the default member to be aligned with t
Render SQL*Plus output in HTML
(Bob Watkins) SQL*Plus has traditionally been thought of as a plain text SQL query tool. But since Oracle 8i, it has also had the capability to render its output using HTML.
How to write MySQL conditional comments
(Xaprb) MySQL’s version-specific conditional comment syntax confused me for the longest time. Then I learned about printf formatting rules, and it all became clear. Read on if you don’t already know what I mean.
Building Google gadgets, Part 2: Working with the user interface
(John Muchow) Part 2 of the Building Google gadgets series introduces the advanced features of gadgets, including creating a tabbed user interface, drag and drop, and MiniMessages, and gets you started creating your own. (R)
Oracle Secure Backup, Part 3: Conclusion
(Jim Czuprynski) With Oracle Secure Backup, Oracle now offers the capability to insure that all Recovery Manager (RMAN) backups are created and maintained in a secure fashion, all without the need for a potentially expensive and cumbersome media management layer (MML). This article – the final one i