(Josef Richberg) There have been numerous occasions where I have to pick a one of two records out of a given result set, but how I determine which one has some unique rules. I have two examples of this and I show how I used Row_Number() to solve this.
Author: SSWUG Research
Organizing Resources in WPF Using Resource Dictionaries
(Ged Mead) When you first start creating a WPF application, it’s tempting to keep the resources, such as styles, brushes, control templates, and so on, at low level in the tree. By that I meant that you might find that if you create a style for buttons, for example, you put them in the Window.Resou
LIKE Predicate Enhanced in DB2 11
(Troy Coleman) Users of DB2 Version 10 and earlier releases may find inconsistent behavior when using the LIKE predicate, particularly if the column contains trailing blanks and is of variable length.
Search multiple SQL Server Error Logs at the same time
(Mike Eastland) I am troubleshooting a specific error that recurs in my SQL Server error log. I want to identify all of the occurrences of this error from a certain point in time, but my error log has been cycled multiple times since then. How can I retrieve this information without manually openi
LDAP as a Naming Service in Enterprise Application Integration
(Kanagarajan Ramakrishnan Maheshwari) In enterprise integrations, applications across different systems are integrated by various means and techniques. In such large-scale integration, there is a need to identify the key integration components or elements and maintain them in a secure centralized lo
MySQL Explain Explained
(Noel Herrick) Whenever I have a problem query in MySQL, I say to myself, I know, I’ll use Explain Plan. Now I have two problems. I run the explain plan, but then I have to look up all the cryptic terms and read through the documentation to know what in the world is going on. Well, over the weekend,
ASP.NET Ajax Application Architecture (jQuery, jSon, .NET ScriptService)
(Kashif Akhter) To provide your users with a richer and more responsive user experience by building an Ajax Application.
RESTful API Support in IBM XIV
(Bertrand Dufrasne, Dietmar Dausner, Roger Eriksson, Roman Fridli, Itzhack Goldberg, Markus Oscheka and Stephen Solewin) Representational State Transfer (REST) is a simple stateless architecture that essentially uses existing web technology and protocols, essentially Hypertext Transfer Protocol (HTT
JSON Debugger Visualizer in Visual Studio 2013
(Avneep Dhanju) We are proud to announce the addition of JSON Visualizer to Visual Studio debugger in the Update 2 for Visual Studio 2013. JavaScript Object Notation or JSON is a popular format for transmitting data between server and client applications.
Generating SQL with SQL templates
(stewashton) SQL databases offer a huge advantage to developers: we can use queries against the data dictionary to generate SQL code. “SQL templates” are a simple idea that makes this technique easier to use.