Ben Dill's Blog

  • IE Image Bug = Website Performance Hit

    While troubleshooting a site I'm developing, I noticed that a page was double posting.  After a little brute force diagnostics, (comment everything out, bring things in one-at-a-time), I was able to isolate the issue.

  • Who Owns Your Databases?

    Right now we have owners set to whoever creates the databases for most databases, but there are a few owned by sa.  I'm thinking how great it would be to consolidate this.  To this end, I've created a database owner domain account and added it as a SQL server login.  The login only has the public server role.  In a move common with things I typically do, going overboard, I have denied this accounts ability to connect to the server and disabled it.

  • Windows Server 2008 Typo???

    I haven't posted in a long time and this isn't exaclty ground breaking content, but I saw this today and I can't help myself.  To me this looks like a typo in the help file name.  Perhaps I'm seeing something where there is nothing.

  • Integer Based Bit Manipulation - SQL

    Hopefully my topic isn't too far off.  In this post I'm going to cover what I like to think of as easy bit manipulation.  Well, it's easier anyway.  The basic concept is that an integer is comprised of bits.  Integers are easier to look at and play with than bits, especially if we're storing bit values in SQL and we want to update them...  Using logical bitwise operators, we can query one integer with another to see which bits they have in common.  When performing the query, if one value is strictly a bit, we can see if that bit is 'on' in the second value, which is a sum of one or more bits.  Alternatively, we can test two summed bits to see if one is a union of the other.  To me this means all of one exists completely in the other.

  • SQL + XML(?) + Unicode = Issue

    The title of this post may not be entirely accurate, but it is pretty close.  I recently encountered an issue with a 3rd party component that was reading unicode information from a MSSQL 2005 database and then sending an email using the value.  For some reason, what appeared to be random unicode characters from SQL were displayed as the flattened '?'.  The odd thing was the they were right next to other unicode values that came through just fine.  Very odd...

  • SQL Server - Print MAX

    Welcome to my blog, this is post numero uno.  I would like to thank Joe Stagner for hooking me up with a blog on  My name is Bennett Dill and I am an Application Architect at a market research firm in Cincinnati Ohio.  I have been programming for about ten years starting with ASP Classic and VB 6 right on up to C# and ASP.NET.  I don't know if I'm going to be a good blogger, but I'll give it a whirl.