List the users connected to a MS Sql server

Thought I´d inform about a nice little procedure I found today. I failed to remove a database since there were still users connected. Obviously, I was the one keeping a connection but that doesn’t mean I know where I´m keeping that open connection 🙂 Just run...

Entity Framework query sql

Ever tried to build complex joins using Linq with Entity Framework and finally ending up with something you just suspect might be a hell of a lot less efficient than possible? In that moment it might prove useful to get the clean actual SQL your Linq query actually...

Choose columns to link with SharePoint 2007

I´ve recently poked about a bit with SharePoint 2007. Trying to avoid using the somewhat costly web services (which is also hard to debug and has kinda crappy interfaces) I´ve been using the possibility to link SharePoint lists to Access databases. However, I found it...