Category: Self Note

Thoughts on Burnout

Thoughts on Burnout

I was reading an NPR piece on worker burnout and some different tactics taken by different companies to deal with it and came across a very nice, concise definition: Christina Maslach is a professor at the University of California, Berkeley,...

FluentNHibernate and SQL Date Generation

FluentNHibernate and SQL Date Generation

So you’d like your SQL entry to have a system generated date/time, eh? Here is a sample table:

To spare you hours dealing with this error:

What you need to do is to use the following mapping for...

What Alan Watts Can Teach Us About Leadership

What Alan Watts Can Teach Us About Leadership

I was listening to a talk by Alan Watts and found one bit of advice that really connected to what I’ve learned about leading others. The principle is that any time you — as it were — voluntarily let up...

Setting Batch Variables Dynamically

Setting Batch Variables Dynamically

One of the challenges of managing builds and deployments of source on multiple developer machines is that it can be complicated to contain and manage different variations in developer environments. For example, often times, it is useful to know the...

A Simple Way to Improve CAML Query Performance

A Simple Way to Improve CAML Query Performance

There are many ways to improve the performance of your CAML queries, but I’ve recently found that in some cases, it’s as easy as switching the order of your filter operations. In this case, I was searching across a list...

Preventing the Garbage Collector From Ruining Your Day

Preventing the Garbage Collector From Ruining Your Day

If you’re working with ZeroMQ, you may run into an exception with the message “Context was terminated”. It turns out that this is due to the garbage collector cleaning up (or attempting to clean up?) the ZmqContext. Found this out...

Watch Out For SPListItemCollection.Count and Judicious Use of RowLimit

Watch Out For SPListItemCollection.Count and Judicious Use of RowLimit

This seemingly innocuous call can be quite dangerous when used incorrectly. The reason is that this property invocation actually executes the query. This is OK if you plan on iterating the results because the results are cached, but costly if...

SQL Query for Multi-Values In An Encoded String

SQL Query for Multi-Values In An Encoded String

Consider a table with an textual column that encodes multi-values like so:

How can we query for all rows using an OR criteria? For a single value, it’s quite easy by searching for the string (in this case, an...