Handling technical debt in any system is a constant challenge. Where I see the most debt in open source is the non code related issues of design and usability.

We have...

Ah the visual studio shell.

When we finally migrated to SQL Server 2012, Microsoft told us that the eliminated the MDI interface forcing me to use a tabbed interface for the...

A history page would be a welcome resource as well

Does that mean you wouldn't take a government job either?

The price of all the houses in Allegheny County are published on their website. Furthermore Zillow publishes the sale price of a good chunk of all the houses in America.

Most government jobs have published salaries.

This is for Illinois teachers:

http://www.familytaxpayers.org/ftf/ftf_salaries.php

I found a spreadsheet for the city of Pittsburgh at:

https://docs.google.com/spreadsheets/d/1AgIDIpQ4B-u0C2RrnYFEgdnpJKlWH0qyBGkhRTiOK9A/edit?pli=1#gid=0

Is it good security to lose customers?

I realize the <sarcasm> tags should have been on the last couple of comments, but a 50,000 foot view of security costs and savings would be meaningful.

I spent 20 minutes...

We use that here too. Its a challenge to get some things updated and answered, but for the most part the system works well.

I wish I could port/merge/organize things between...

Which wiki do you use?

Risk Management tends to focus on the people who have a lot of assets to manage. I rarely see an assessment with the cost of current risk avoidance methods,...

I'm not sure this happened in this case, but small organizations often pay for the developers to construct things in a technically sophisticated way, when there are are other ways...

What is the cost of the audit, and what are the alternatives? The cost aren't just IT costs, but lost business or operations. I'd like to see a switch that...

It looks like a BINARY(9) works

this doesn't work

CASE WHEN [Entered_Dttm] IS NULL THEN 'NULL' ELSE 'CONVERT(DATETIME2, ' + master.sys.fn_varbintohexstr (CONVERT(BINARY(8), [Entered_Dttm])) + ')' END + ', ' +

this does

...

I'm struggling with the datetime2 format.

I get this message:

Msg 8152, Level 16, State 17, Line 1

String or binary data would be truncated.

from this line:

CASE WHEN [Entered_Dttm] IS NULL THEN...