This is just a quick tip on combining (aggregating) result strings in SQL Server. Sometimes it's useful to add multivalued columns to results (or CSV files) but it's not all that simple.

For combining results of a JOIN to a single column you can use the STUFF function ...

Photo by John Carter

Recently I was moving a SQL Server model database log file to another disk. I made an ALTER DATABASE [model] MODIFY FILE... command a bit too fast and pasted the destination from a file browser window. Of course this set the log directory as the new ...

I recently started learning and using T-SQL for a database integration project I'm doing at work. T-SQL (or Transact-SQL) is Microsoft's extension to SQL that adds some transactional programming features to it. It's used in SQL Server.

I'm slowly getting the hang of it. Mostly I ...

Pelican FTW!

I finally restarted my blog with an actual domain and a switch from Drupal to the Pelican static blog generator. The server uses Fedora 20 and is hosted by DigitalOcean. It's a good hosting company with excellent pricing.

This post is mostly just a list of the ...

This is a repost from my old blog.

Drupal 7 is the PHP content management system that needs no introduction. But if you also want an excellent search engine to use with it then Apache Solr is the best choice. Solr builds on Lucene and adds some nice features on ...