Video Programming for IT Professionals
Other News
Silverlight 4.0: Applying Data Templates on ListBox at Runtime
(Mahesh Sabnis) DataTemplates in Silverlight are typically used for visual representation of your data. They are particularly useful when you are binding an ItemsControl such as a ListBox to a collection. I was recently asked to make use of a DataTemplate on a ListBox at runtime, for performing Upda
Alternative to my SQL based GetNumRings function
(Simon Greener) When creating a new PL/SQL procedure or function, where possible, I write the algorithm in SQL first. Once the SQL is done, it then becomes comparatively easy to encapsulate the SQL in a PL/SQL procedure or function for generic use.
Querying XML Data Using XPATH Expression and the XML DOM
(Vishal Gilbile) Sometimes we need to query XML data based on a particular condition simialr to how we do in SQL Server. For e.g. let’s suppose we want to display the data of the employee which matches the criteria specified in the where clause.
Adventures in TSQL: Adding date and time values
(Carl Nolan) With the addition of the SQL Server date and time types, I have often found myself needing to create a datetime (or datetime2) value based on the addition of a date and a time value. However, there is no built-in function for such an operation.
Speeding up queries by a factor of 100 or more with DB2 Text Search
(Antonio Cangiano) During a recent Rails project at IBM we had to deal with a large table consisting of customers. The table is made up of legacy enterprise data, and contains close to a million records.
Simpler and Safer Clustering: MySQL Cluster Manager Update
(Mat Keep) Clustered computing brings with it many benefits: high performance, high availability, scalable infrastructure, etc. But it also brings with it more complexity.
How to conditionally set data as editable based on another fields value
(Grant Ronald) This question comes up a few times in ADF land and it appeared on the OTN forums this week so I thought I would create a quick demo. The scenario is that depending on some data value, you want to define that some other data is not editable. For example, if an order status is “CANCEL
Batting Clean up with Reader Questions
(Peter Vogel) Here are the answers to some questions I’ve gathered from readers (some triggered by previous columns), from my clients and from participants in classes that I’ve taught.
A small correction to the parallelism process
(Willie Favero) Short blog post alert.. I was researching a problem with a long running data warehouse query today and came upon this fix. I could imagine this happening with a few of our killer queries but as I read through the doc, I decided they weren’t quite right.