(Mary Sanders) With release 6.1 and continued with 6.2, the Home page access pull down was renamed from Select a View to Access Method By and the options were changed.
Other News
MySQL Slashes and Backslashes
(Dave Stokes) There was a on Twitter to @MySQL How can I insert “/” into a varchar field please. Since they were polite and used please, I wanted to be helpful.
Partner TechTip: The Commercial Power of SQL-Based Monitoring
(Kurt Thomas) Organizations can now apply the valuable insights, analysis, and real-time notifications that they use for system information to information from broader business applications thanks to the SQL-based monitoring feature in QSystem Monitor.
WPF Button Controls Class Hierarchy
(Richard Carr) The sixty-third part of the Windows Presentation Foundation Fundamentals tutorial looks at the base classes of the WPF button controls. This article includes the inheritance hierarchy of all of the WPF controls described in the tutorial to date.
Invoke a POST method with XML Request message in C#
(Amogh Natu) To invoke a POST method located at a particular URL with an XML request message, we need to follow the below steps:
Optimization Tips for Multiple Range Predicates, Part 1
(Itzik Ben-Gan) Supporting your query filters with the correct indexes is essential for optimal query performance. When your query filter has a single predicate that’s a search argument (SARG), things are straightforward: You create an index with the filtered column as the key.
SQL92_SECURITY
(Andrew Reid) I tested the examples in this post in two Oracle 11.2 databases. In the first example, Andrew creates a table, inserts a row into it then grants UPDATE privilege on it to Fred, who is then able to work out the value in the table, without changing it permanently, using a series of UPDAT
Postgres Datatypes – the Ones You’re Not Using.
(Craig Kerstiens) Postgres has a variety of datatypes, in fact quite a few more than most other databases. Most commonly applications take advantage of the standard ones – integers, text, numeric, etc. Almost every application needs these basic types, the rarer ones may be needed less frequently.
Considerations to use DB2 HADR with TSM
(Somu Chakrabarty) Starting with version 6.1 TSM now uses DB2 as its backend database engine. It is a normal DB2 instance, but very tightly controlled by IBM support. After installation one cannot change any parameter in the TSM DB2 instance without permission from IBM support.
Catching CFLock Timeout Errors In ColdFusion
(Ben Nadel) When it comes to catching errors in a ColdFusion application, I typically use a custom error type or the “Any” type. But, today, I had to do something that I’ve never done before – catch a CFLock timeout. As it turns out, a lock-timeout is fairly easy to filter out of the myriad of error