One of my recently discovered activities that I’m falling in love with is indoor rock climbing (though I suppose I may try outdoor rock climbing and bouldering one day, too). In a weird way, it’s the ultimate thinking person’s type...
Eric Brechner came up with one of my favorite acronyms of all time in software development: FOCKED. I want to add an alternate: Failure to Orchestrate Collective Knowledge Effectively for Delivery. Successful delivery of software requires that different members of...
One of the lessons I’ve been mulling about the past few weeks is the importance of scope when delivering software. Delivery of software can be thought of as a balancing act between three buckets: Time – this is the schedule...
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,...
In the wake of the Apple iCloud debacle, there has been a lot of discussion on what Apple has done wrong, what it could do better, and how this could have been prevented. This is not a blog post about...
In SharePoint, if you host a custom WCF service in a claims-enabled application, the authentication via NTLM is actually quite tricky if you are attempting to invoke it from a console application, for example. There are various articles and Stackoverflow...
Came across a great definition while reading up on release 4.0 of WordPress: A release lead, if anyone is curious, determines all important parameters for a release, like schedule, deadlines, which feature plugins are merged, and more generally, scope and...
I’m working with a library that I have been fighting with for the better part of three days now to try to get it to work. The previous version of this library was actually very well written from an API...
I recently had to track down a performance issue with one of our Cypher queries that was taking an obscenely long amount of time to run (15 seconds!) given the simplistic nature of the query. Can you spot the problem?...
So you’d like your SQL entry to have a system generated date/time, eh? Here is a sample table:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
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, EntityContextUid uniqueidentifier, EntityContextName nvarchar(256), EntityContextType varchar(128), UserLogin nvarchar(128), EventName varchar(128), AppContext varchar(64), EventData nvarchar(max), ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
To spare you hours dealing with this error:
|
1 2 3 4 |
System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. |
What you need to do is to use the following mapping for...