SelecTViews With Stephen Wynkoop A pet peeve – what is up with the silence about the massive cloud data breach??? Also on the show today – Michael Crump and some great applications for Silverlight. [Watch the Show] $$SWYNK$$ Plan Guides In response to yesterdays tip using sp_execute_SQL I received the following comment from Leif regarding a database configuration that can […]
Other News
SQL Transparent Hierarchical Processing of Relational, XML and IMS Data
(Michael M David) Current SQL support of relational, XML and hierarchical legacy data such as IMS is driven by flattening the hierarchical data in order to integrate it naturally with relational (flat) data so that it can be processed relationally.
Introduction to: Ontologies
(Juan Sequeda) In my most recent post, I introduced RDF as a flexible and schema-less data model. However, some of you may think then that using RDF data is going to be a complete mess.
Unit Testing Using Visual Studio 2010
(Vince Varallo) This article will demonstrate how to use Visual Studio 2010 to develop, run, and maintain unit tests.
Returning NULL Values In JSON Using SerializeJSON() And ColdFusion
(Ben Nadel) As I’ve been setting up a JSON-RPC (Remote Procedure Call) API for a ColdFusion project, I’ve been learning a few little tips and trips about JSON formation. Last week, I talked about how struct keys defined using array-notation maintain case during serialization. This week, in accordanc
Programming the Windows Transactional File System (TxF)
(Nick Wienholt) One of the most obvious uses of the The Transactional File System (TxF) is to write to a single file within the scope of a transaction, eliminating the possibility of the file becoming physically corrupt if the write operation does not complete successfully.
Returning data from one path based on predicates in another (part 2/2)
(Matthias Nicola) This is the continuation of my previous post, to see how we can write a query that achieves the following:
DB2 Data Warehouse DSNZPARMS Part 3
(Dave Beulke) The previous two weeks’ Part 1 and Part 2 discussions highlighted and discussed the various DB2 Data Warehouse DSNZPARMS for z/OS within Versions 8 and 9.
Schooner Releases Active Cluster for MySQL
(Sean Michael Kerner) Scaling the MySQL database for high-availability and clustering is an activity that can take many forms.
Running SELECT … INTO :bind_variable from SQL
(Tanel Poder) I just wasted a few minutes troubleshooting one of my scripts – and realized that while SELECT … INTO :bind_variable does not error out when executed as top-level SQL, it doesn’t seem to populate the resulting bind variable: