(Sas Jacobs) Welcome to part 2 of the three part case study on building a Flex 2 application. In part 1, we started to build our real estate listings application. We created the interface for the application and the custom class that loaded the external XML document. In part 2, we’ll populate the Re
Other News
Finally, Web Services for the REST of Us?
(Joe McKendrick) For years now, proponents of REST-based Web services have been battling WS-* and SOAP proponents on which delivers the most agility to enterprises.
Explanation of error 3928 in SQL Server 2005 and in SQL Server 2000
This article discusses error 3928 in Microsoft SQL Server 2005 and in SQL Server 2000. The wording of the error message may be misleading when you troubleshoot this error.
Rational Data Architect and DB2 9: The Rest of the Database Explorer View
(Paul Zikopoulos) In my latest articles, I’ve been writing about the IBM Rational Data Architect (Rational DA) integrated development environment (IDE) that’s specifically designed for those involved in data server design and schema evolution. So far, I’ve shown you how to add a database connection,
Process Delegation Workbench
(Robyn Page and Phil Factor) Here is a way of designing part of a SQL Server Database application so it seems faster to the user.
Iterating through tables and databases in SQL Server
(Arthur Fuller) This tip presents two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on
Generate SQL Statements with objects, Attributes and Reflection
(Edmund H Smith) Many developers hate one thing about software development, writing SQL Statements. SQL is a language on its own and it is ubiquitous in today’s development environment. When there are changes made to the tables, we have to modify the affected SQL statements, be it in the application
Returning Complex Data from User-Defined Functions with CROSS APPLY
(Jeff Smith) SQL Server User-Defined Functions (UDFs) can return either a single value or virtual tables. However, sometimes we might like for a User-Defined Function to simply return more than 1 piece of information, but an entire table is more than what we need. For example, suppose we want a func
Something old, something new, something DB2 9, something blue
(Willie Favero) Yes, I know that’s extremely corny. However, for this particular post it’s actually fairly accurate. We’re going to talk about how a bind parameter is switching back to its old original default, how one of the oldest bind parameters is taking on a new default, we are talking about DB
Top 5 Myths About Patching Apps Environments
(Steven Chan) A rational person might contend that actions follow attitudes which follow beliefs. Bad news: there’s a substantial amount of psychological literature that suggests that this isn’t how we really tick.