(Ben Nadel) The CFThread tag, in ColdFusion, is a powerful but mysterious beast. Threads allow us to perform some very efficient, asynchronous tasks; but, at the same time, they can be tricky to interact with if you don’t understand how they work.
Other News
Connecting to SQL Server with ASP.NET
(Khyati Patel) To create a database connection first of all we need to define a connection string. The best place to have a connection string is web.config of an application.
Migrating Oracle Materialized View to SQL Server
(Gowri Shanker and Welly Lee) This blog post discusses approaches to migrate Oracle Materialized View to SQL Server. We compare Materialized View with SQL Server Indexed View, discuss scenarios supported by Indexed View and provide suggestions you can consider for the non-supported scenarios.
Dynamically retrieve and map human task information with WebSphere BPM V6.2
(Sean Gu and Yu Wu) This article demonstrates an approach to dynamically assign human task roles at the process template level using WebSphere BPM V6.2 products. You’ll learn how to correlate a process template with its human task activities, how to make human task role assignments with dynamic mapp
Relational Database Designs Optimizing Object Oriented Programming
Relational Database Designs Optimizing Object Oriented Programming Today I’d like to share another relational database design I find useful when working with Object Oriented Programs. Let me remind you once again that you don’t want your Object programs to determine your schema. However, when they align more closely, both worlds benefit. I really love working with the Type/Subtype schema when […]
SelecTViews – Interview with Jonathan Ellis, CTO and co-founder of DataStax
Video Programming for IT Professionals
MongoDB a Nice Fit for Object Oriented Programming
MongoDB a Nice Fit for Object Oriented Programming Yesterday we talked about database designs that work well with object oriented development patterns. One of the concerns I strongly emphasized is that object oriented programming and relational databases don’t mix as nicely as other non-SQL counterparts available today. David responds today with a nice review of his experience with MongoDB. I […]
Updated DB2 Academic Certification program available
(PatFletcher) It is very exciting to put in this update… We have been working hard to create an even better and easier-to-use DB2 Academic Certification program, and now it is ready!!
A true story about using XML forms and DB2 to process millions of tax returns
(Matthias Nicola) A short summary of why and how the New York State Department of Taxation & Finance is using DB2 pureXML is available here:
ROUTINE_PRIVILEGES implementation
(Shlomi Noach) Following up on MySQL security: inconsistencies, and on MySQL bug #61596, I was thinking it may take a long time till the non-existent ROUTINE_PRIVILEGES view is implemented. Here’s my own implementation of the view.