I'm not a spontaneous guy, so for me to do two spontaneous things, out of schedule, in the same week, feels quite liberating! And it is a good reminder that letting myself become too regimented is a sure sign that I'm being pulled too far into the rat race, into the humdrum existence that I've always dreaded. Building a trail and listening to Texas folk-rock are good cures for that.
"O people! Consort with the followers of all religions in a spirit of friendliness and fellowship," Bahá'u'lláh commanded his own followers in His epistle of the Glad Tidings.
In that spirit I, and three to four-hundred others, ventured to downtown Minneapolis this evening for Minnesotans Standing Together - A multi-faith prayer service for respect. The service began and ended with bagpipes, surrounding comments, prayers, songs, chanting, and meditation from the Christian (Lutheran, Unitarian, Catholic), Jewish, Muslim, Hindu, Bahá'í, and Buddhist faith traditions (a Lakota speaker was unfortunately absent). These were words of unity, love, and respect for one another — and a call to actively show those feelings, to uphold them in society in the face of enmity, rancor, and hate.
This devotional program was presented at the Bahá'í House of Worship on September 5, 2010. Before going upstairs into the temple, I joked to my friend that I wanted to go downstairs to the bookstore, to be material before being spiritual. The architecture is inspiring enough, but the devotions and music were, well, heavenly :-).
Did you know that many Bahá'í books are available for free download onto your computer, smartphone, or e-reader?
I'm writing a class with several methods that take integer input. The input values cannot be less than zero. Since we're not on .Net 4.0 yet, I'm manually writing code contracts (that is, my functions check preconditions), e.g. before doing anything else, I write something like…
if (sequenceNumber < 0)
{
throw new ArgumentOutOfRangeException("sequenceNumber", "Sequence number must be 0 or greater");
}
This got me thinking: why don't we ever use unsigned integers? Seems like having a uint would better communicate the requirement, and would simply not allow a negative number. The main answer seems to be that casting between uint and other data types, which is inevitable, is ugly. And that uint is not CLS compliant. Even though I'm not trying to write CLS-compliant code at the moment, I think I'll stick with int — because that is our existing convention, and I don't see enough reason to change the convention.
Stephen's first law of diagnosing problems in production should have been: make sure you actually know the scope of the problem. We have a process that checks for duplicates in an inbound file. Records marked as duplicates are not moved into production. A refinement of the process was installed this week. All the sudden, e-mails showed that thousands of records were being marked as duplicates. I came over to help investigate, and found people looking at code, trying to figure out what was going on, because they knew without doubt that these records were not in fact duplicates.
But we needed to step back and ask what is the scope of the problem? We looked at the e-mail with the duplicates, picked a name or two from the list, and looked in the original input files and confirmed that they were not in the files. So how/why were they reported? But then let's set that aside, and ask: did all of today's records make it into production? If yes, then we have a problem but not a crisis. The answer was yes: we could see a 1-1 match between inbound file and outbound production data. Therefore, we have a minor reporting problem, but the core of the system was working just fine. Panic averted.
So what was the cause? A staging table that had not been truncated after a previous file was processed. All those records were being reported as duplicates.
The Times has a special feature about On the Origin of Species, including annotations from various Scientists commenting on favorite passages. The first annotation is by the famous primatologist Frans de Waal, who comments one of the passages that struck my interest when I read the book earlier this year:
I should premise that I use the term Struggle for Existence in a large and metaphorical sense, including dependence of one being on another, and including (which is more important) not only the life of the individual, but success in leaving progeny
Darwin, in the course of his opus, did not merely lay out the voluminous evidence for natural selection, he also frequently dropped hints of further research to come: for instance, the topic of cooperation. As de Waal notes, we're generally taught to think of Darwinism as survival of the strongest individual competitors. Look at so-called "social Darwinism," and you'll see something that Darwin would likely have hated. Because he clearly believed that cooperation and education (an extension of "leaving progeny") were key components of the general competition between traits (evolution) in a population — that evolution is more than just my biceps are bigger than yours, my brain case has more volume than yours, etc.
So asked a new friend (well, something close to this anyway). In a nutshell: it means striving to build unity in our midst, and acting on a path of service that starts "at home" but continues into the whole community, not just the Bahá'ís.
"global temporary tables are visible to all sessions," says the MSDN documentation. I have occasionally wondered when this would be helpful. This week I finally found a use, albeit limited: I want a quick-and-dirty process that will e-mail a CSV file to me every day for a week. I wouldn't do this for a full on production system (without dwelling on it, it just strikes me as too error prone and inelegant), but for some testing I want to do over the course of a week, it makes sense.
I run a query that populates a temp table, and I want to e-mail the contents of
the query using sp_send_dbmail.
Again, the documentation tells something important: "Note that the query is
executed in a separate session, so local variables in the script calling
sp_send_dbmail are not available to the query." This applies not just to a
table variable, but also a local temp table (e.g. #temp). But a global temp
table (e.g. ##temp) is a different story: works just fine. So there you go,
quick and dirty way to e-mail yourself some query results when you don't want to
just pass the raw query directly to the send command.
Save Darfur Coalition just called me. And thanked me for being so pleasant on the phone. How sad. Its not like it was a cold call — I've supported them in the past and thus have a reasonable expectation that they'll try to contact me in the future. Why are they calling? Because apparently the conditions in Darfur are deteriorating. Do I believe the woman on the phone? Well, the Times reports that Violence Said to Be Rising in Sudan’s Darfur Region (2010-08-05). At this point Sudan is as much a powder-keg as ever, with secession of the south likely next year, renewed civil war equally likely. The Save Darfur Coalition< is helping spread awareness of, and global pressure on, the Sudanese government's grave abuses (killings, rapes, and other human rights violations). My money will not do much to stop the situation. But public pressure does make a difference, and I'll provide a small amount to help keep that pressure steady.
Meanwhile, Pakistan is also calling, though not literally. The flooding has been absolutely terrible, and relief agencies expect that hunger and isolation will be extreme in the coming months. Time to step up and show the love again for Pakistan (dead link removed; SF 2025 removed). Unicef, World Food Programm, International Committee of the Red Cross, Oxfam, etc. — let's all give one of them a cold call, only to give rather than receive.
