Denver Code Monkey

The Writings of a Code Monkey

Entries for the ‘SQL’ Category

.NET Connection Strings – To Encrypt or Not to Encrypt

Recently I was tasked with researching connection string best practices, and employing them at the day job. We want a better way to manage all of the connection strings. I suggested moving the connection strings into the machine.config unencrypted. This will accomplish multiple things. Centralizes connection strings to one area for all projects residing on [...]

Simple SQL Pivot with Example

A colleague was interested in solving a reporting problem for our business users.  And as many times go, I ask him what he wants the end result to be, so that I can figure out how I would tackle the problem.  He explains that he wants the following: License # #1 #2 #3 0001 2000 [...]