SQL Book Review

I’ve been working on setting up a maintenance plan in SQL Server on one of our production servers.  Right now we back the whole server up nightly, but we have a machine that I’d like to get some more granularity […]

Lame SQL, Just Lame

We have a table with a bunch of columns that are of “bit” type. I want to count the number of bits flipped to 1 in those columns. Seems like that should be a fairly common use case, doesn’t it? […]

Weird SQL Concatenation

At work I automate reports that usually pull a really large chunk of data from several tables in our loan origination software.  Today I came across a report with a blank value where I was concatenating 2 fields together: CASE […]