Matija Lah

Matija Lah

Matija Lah

Matija Lah, formally a university graduate of law, has been involved in information management since the nineties.

His first introduction to SQL Server in IUS Software d.o.o. Slovenija has later culminated in a new career developing data-centric solutions and consulting. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Windows Server System SQL Server).

Currently, most of Matija's time is spent on projects involving advanced information management, natural language processing, and knowledge management.

View all posts by Matija Lah
Matija Lah

SQL Concatenation Done Right – Part 1 – Dubious Practices

April 15, 2015 by

This article is a part of three articles series to explore SQL Concatenation techniques.

Having to represent sets of data as strings is a very common requirement in information management, even in modern times where a variety of more or less elaborate standards for storing, and moving, data are at our disposal. For instance, XML, JSON, or similar techniques, allow the data to be extracted from one data source, using a well-known standard, and be stored temporarily until being loaded into a destination data store, or until being consumed in some other way. Actually, both XML as well as JSON might even be used as a standard way of storing data permanently; especially, if the consumers expect the data to use one or the other format.

Read more »