Hello!

I'm a passionate web developer and systems architect living in Stockholm, Sweden. I work at Valtech and I am an EMVP.

EMVP logo

Read more about me

Joel Abrahamsson illustration

About web development with ASP.NET and EPiServer, fatherhood and other adventures in my digital jungle

Posts tagged with "t-sql"

  1. My favorite way to do paging with T-SQL

    Posted June 26 2009. 0 comments. This is how I like to do paging with T-SQL. I've seen quite alot of ways to do paging with SQL Server, both with and without temporary tables and this is definetly my favorite as I find it uses both straight forward and easy to read T-SQL code.

  2. Getting the first day in a week with T-SQL

    Posted June 26 2009. 3 comments. A colleague just asked me if I knew a way to get the first day in a week in SQL Server. While I'm sure there are many ways to get the first day (date) in a week with T-SQL here is a very simple way that in my opinion is quite elegant.

  3. Dynamic sorting with T-SQL

    Posted June 26 2009. 2 comments. Almost all stored procedures that I write whose job it is to fetch data has to sort the data according to one or several columns. More often than not the selection of those columns, and the sort direction, is determined by the web application and therefore has to be based on parameters. I've spent quite some time researching ways to do dynamic sorting with T-SQL without using dynamic SQL

Follow me on Twitter

  1. Blogged: Learning Scala part nine – Uniform Access http://bit.ly/bmUat8 1 days ago
  2. @mikaellundin Your blog is a never ending source of wisdom. And weird mathematical problems. :) 3 days ago
  3. Bookmarked: Validate XHtml 1.0 Strict as part of your build process « Mint http://bit.ly/bOhaZj 3 days ago
follow me

Latest comments

  1. Svante wrote "Yes, I noticed that it was a singleton, and I guess the real..." on Something to beware of when using EPiAbstractions and an IoC container
  2. Joel Abrahamsson wrote "Well, first of all you wont get any arguments from me regard..." on Something to beware of when using EPiAbstractions and an IoC container
  3. Svante wrote "Hmm... Since the issue really is with the public instance co..." on Something to beware of when using EPiAbstractions and an IoC container

About this site

This blog is built with EPiServer Community, EPiServer CMS, ASP.NET MVC and a bunch of other great products. The source code is available for download at the projects page, where you also can read more about this site and my other projects.

read more