Here’s something I always need to Google: how to pivot the results of a query in T-SQL. In the Peergroups application, we help people lend objects from their peers. So, simplified, we have a Request table that includes the following example data: Id Description UserId CreatedDateTime 1 A lawn mower 54 2018-01-21 2 A ladder 12 2018-01-24 Other people in Peergroups will receive a message from these users, to which they can reply whether or not they have that object.

I recently had to look up how to create a login in SQL Server, so that I could connect my local Orchard CMS instance to it. I had to look this up for the umpteenth time. And the docs are often a bit too much for me, as they are (I think) catered towards database experts. Which I am not. So here’s a quick step-by-step guide what I did. First, if you don’t already have it, you can run a