Archive for the ‘SQL Code’ Category

A Misadventure in (someone else’s) GoF Land

It’s ok to decouple your design from your implementation, as long as you eventually get to the implementation.

Read the rest of this entry »

Parameterizable SharePoint SqlQueryWebPart

I’ve been so frustrated with the lack of a flexible way to just display the output of a raw SQL Query via SharePoint so I wrote one.
At first I thought I didn’t need parameters, but I was wrong. Everyone needs parameters, or else it’s not all that useful. Of course, that [...]

Read the rest of this entry »

Ok, I promised a better LINQ example..

So, I made one, except I posted it on CodeProject instead of this blog. I figured with this thing I wanted to get a lot of people in the audience. Not to mention that makes free advertising for me and my blog anyway.

Read the rest of this entry »

Down the rabbit hole with LINQ-to-SQL.

Man, just when I thought I was starting to get the hang of LINQ-to-SQL and knowing what kind of cool features it has, I ran into some interesting problems. For one the DataContext needs to have an ‘appropriate lifetime’ which means you have to play around with it, there aren’t real standards. The [...]

Read the rest of this entry »

Quick, list the dbs and Users!

I’ve been orchestrating a move from an old SQL 2000 database to a SQL 2k5 DB host. Most of the dbs are in use somewhere by some application or other, and I can’t tell by looking at it just what they are. One of the things I’ll need to do is contact all of the [...]

Read the rest of this entry »