Peter Morlion logo

SQL Tip: pivoting results

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 […]

Setting up SQL Server and logins

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 […]