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,...
Category: Self Note
So you’d like your SQL entry to have a system generated date/time, eh? Here is a sample table:
CREATE TABLE [dbo].[AuditLog] (
Id int IDENTITY(1,1) PRIMARY KEY,
EventUtc datetime2(7) DEFAULT(SYSUTCDATETIME()) NOT NULL,
EventOffsetUtc datetimeoffset(7) DEFAULT(SYSDATETIMEOFFSET()) NOT NULL,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
To spare you hours dealing with this error:
SqlDateTime overflow. Must be between
1/1/1753 12:00:00 AM and 12/31/9999
What you need to do is to use the following mapping for...
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...
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...
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...
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...
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...
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...
New to me: ContentIterator for reading items from large lists.
I’ve been experimenting with Amazon EC2 and SharePoint to better understand how an enterprise architecture would be built on top of it as a platform and, as a part of this exercise, better understand the cost structure. One key number...