(Molly Sharp) It’s only my 7th day on the job here at PLOS as a product manager for content management. So it’s early days, but I’m starting to think about the role of JATS XML in the journal publishing process.
Author: SSWUG Research
Issues replicating XML data types for databases in SQL Server 2000 compatibility mode
(Chad Churchwell) We have a legacy application that was not certified for SQL 2005, so we were running it on a SQL 2005 server using SQL 2000 compatibility mode. The in house development team is increasing functionality by writing custom code around the existing tables and have created some tables o
Streaming XML parser in C++.
(Przemek Mazurkiewicz) XmlInspector is a streaming XML parser written in C++. This project was born because I could not find any parser that meets my requirements:
ASP.NET MVC 4 – Making Asynchronous Calls to External Services from an Action Method
(Mahesh Sabnis) While developing applications, developers often face the challenge of retrieving data from more than one external sources. Traditional multi-threaded programming can be often complex and hard to get right. Prior to .Net 4.5, asynchronous controllers used to inherit from the AsyncCont
Optimizing MIN and MAX MySQL Functions
(Jervin R) MySQL can optimize aggregate functions like MIN and MAX as long as the columns specified are indexed. This means that, in the case of MIN and MAX, the optimizer should be able to identify the highest and lowest values of an indexed column from the B-Tree index,
Some typical DB2 registry settings for Temenos T24 and other OLTP systems
(Henrik Loeser) In one of my previous articles I described what table properties could be used (CREATE or ALTER TABLE) for XML-based OLTP systems like Temenos T24. Today I will show and explain some DB2 registry settings that are typically in use for such (and other) systems.
Oracle RAC Timezone woes and solution
(Ben Prusinski) Recently had a timezone issue with an Oracle 11gR2 RAC cluster. Even though I had set the host time and date, for some reason it did not get propagated to the Oracle RAC configuration.
DATABASEPROPERTYEX Function in SQL Server
(Rohatash Kumar) In this article, I would like to show how to extract the metadata about a database in SQL Server. Here you will see two examples, one to extract the information of a specific database and the other to find the information of all databases. So let’s have a look at a practical example
Optimizing IN Subqueries in MySQL 5.6
(morgan tocker) thought I would take the new subquery optimizations in MySQL 5.6 for a spin today, using the world sample database provided by MySQL for certification and training.
Learning About Test-Driven Development (TDD) Using Tiny Test
(Ben Nadel) Unit testing and Test-Driven Development (TDD) have, collectively, been one of the largest blind spots in my view of the programming world. A couple of weeks ago, in an attempt to remedy this, I created a very small unit testing framework – Tiny Test – such that I could learn about unit