(Yakov Werde) Among PowerBuilder 12.5 .NET’s new features comes the ability to use WCF to call RESTful web services.
Other News
Migrating SQL Server Databases – The DBA’s Checklist (Part 2)
(Sadequl Hussain) Continuing from Part 1 , our Migration Checklist continues:
Understanding ASP.NET MVC Model Binding
(Bipin Joshi) ASP.NET MVC model binding allows you to map HTTP request data with a model. This article discusses how model binding works for various types of models (simple types, complex types, collections etc.). It also shows how to create a custom model binder if situation calls for it.
Search engine friendly URLs in ASP.NET MVC using dynamic routing and a SQL Server database
(Lars-Erik Kindblad) Search engine friendly URLs, also known as rewritten URLs, is a feature where a more logical and readable URL is exposed to the user. An example of such an URL is www.kindblad.com/about.
Query Planner Gotchas
(Martin Farach-Colton) Indexes can reduce the amount of data your query touches by orders of magnitude. This results in a proportional query speedup. So what happens when you define a nice set of indexes and you don’t get the performance pop you were expecting?
IBM Certifies Obsidian’s Longbow for DB2 pureScale Stretch Clusters
(Chris Eaton) In May, IBM and Obsidian certified Longbow for use with Geographically Dispersed pureScale Clusters (GDPC). Using this configuration you can extend pureScale clusters over large distances to create a highly available active/active cluster between sites. The announcement is available
String Tokenizer for Oracle
(Simon Greener) We often have need of string tokenizers in applications. Here is one for Oracle based on work by Pawel Barut.
Knowing what you want to achieve before thinking of how to achieve it – a query optimization example
(Tanel Poder) Today I received a question which was a good example of systematic problem solving approach. It was about getting a long-running query to run faster. It took a long time as the correlated subquery in the query was not unnested, was re-visited many times, causing the whole subquery subt
Scalar subquery unnesting
(Timur Akhmadeev) Here is a nice example of what Oracle 11.2.0.2 is able to do with a subquery inside an expression. It can unnest it – that is a new 11.2.0.2 feature of the transformation part of the CBO.
Geek City: Where are LOBs stored?
(Kalen Delaney) When researching a question from one of the students in my class last week, I was reading the documentation for CREATE TABLE about storing LOB columns at http://msdn.microsoft.com/en-us/library/ms174979.aspx.