(Daniel T. Chang) Model-driven software development generally starts with either application modeling or data modeling. Application modeling and data modeling, however, are closely related to, and complement, one another. IBM has recognized the importance of integrating application modeling with dat
Other News
Hierarchical TableAdapters 301
(William R. Vaughn) One of my Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition) readers commented that he was still having problems setting up a TableAdapter that was fed from stored procedures instead of base tables. With help from Steve Lasker and Beth Massi at Microsoft, I was able
Learning Oracle by the Numbers
(Steve Callan) You may think the title of this article refers to “Learning Oracle is as easy as one, two, three.” Actually, the numbers I have in mind are eight, nine and ten (and soon to be eleven). Although Oracle obviously increments the version number from release to release, the versions you wo
Building a Search Engine with MySQL and PHP 5
(Alejandro Gervasio) If you maintain a medium-sized, growing web site, you might find that it needs an internal proprietary search engine to improve your visitors’ experience. This article, the first of three parts, will get you started with building such an engine using PHP and MySQL.
SQL Trace
(Buck Woody) Once you’ve learned the basic concepts in SQL Server, you’ve ensured that your servers are configured properly, your maintenance plans are set up, and you’ve tuned the system as far as you can, then it’s time to delve a little deeper.
Watch the Latest Weekly SQL Server Show, Posted Today
Watch the Latest Weekly SQL Server Show, Posted Today SelectViews: SQL injection protection tips, cross-site scripting, overall security tips. First-Ever Minicast on SQL Server Surface Area Tools, 60 second SQL Server tip and much more. Watch the show, posted weekly to SSWUG.ORG and open access to all. This week features our first "mini-cast" and a new player feature that lets […]
Modifying XML records dynamically in BPEL
(Marc Kelderman) When you use an adapter to retrieve data from the database or reading records from a file, you will get a collection of XML records. Often you want to modify data within this list of XML records. This can be done like the the BPELX:InsertAfter/BPELX: and other functions. But there i
Binding XML Data using XMLConnector (Flash Application)
XML (Extensible Markup Language) is a flexible markup language, meant to store, carry, and exchange data. We can make use of XML as a simple database to store data and retrieve data.
A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
(Rich Headrick) This paper will discuss and demonstrate some of the basic RAC management commands you might use to manage your Oracle 10g RAC components. The material presented will be applicable to most if not all Linux and Unix platforms. It will not cover RAC on the Microsoft Windows operating sy
iPhone development with PHP and XML
(Jack D Herrington) I was so proud of myself: I held out for an amazing four days before I gave in to the iPhone. Certainly, the fact that my original phone was a piece of junk was a lot of incentive. But what really sold me was the fact that the phone had Wi-Fi built-in and—more importantly—has a g