I spent 14 years on Solaris Unix back in the 80’s and 90’s and then became a windows only developer and engineer. Now almost 20 years later I am back to using it but now with Linux. It is quickly becoming apparent that not only have things changed but now we have a lot of … More Auto-Starting PostgreSQL at Machine Reboot
The idea of this post is to document my journey to building PostgreSQL on a Red Hat Linux server in Microsoft Azure. The post assumes the reader has experience using Microsoft Azure so those steps will not be detailed. A lot of the information came from this Microsoft link. Creating a Linux Virtual Machine From … More Installing a PostgreSQL Cluster in Azure
For most of my projects I was comfortable with rolling my own logging and it became easy to reference this library in new projects. I then found myself wanting to have multiple log files and sending data from different parts of the application to each log for diagnostic purposes. There needed to be some serious … More Integrate Log4Net into an ASP.NET Web API Project
I use window functions a lot however; I often find myself having to remind myself on certain syntaxes or the different outputs between two functions. The following code snippet is used just as a reminder on what is available and is not a complete exhaustive list. The following code consists of three different CTES. Here … More TSQL Tips – Window Functions
There are occasions when testing TSQL that we only need a small amount of input data and do not want to go through the hassle of creating, populating and then deleting tables. A nice quick solution is generating dynamic data through a Common Table Expression (CTE). Take a look at the following code. WITH CTE … More TSQL Tips – VALUES in FROM Clause
If you have a multi-layered application you may want to keep the file and assembly version numbers of all the assemblies the same. This would entail editing each AssemblyInfo.cs file. An alternative is to create a single file holding the versions and referencing it from each projects. Let me show you how. Imagine the following … More Visual Studio – Synchronize a Version Number across Multiple Assemblies
How many times have you just thrown something together, put it in the wild, expecting to never hear from it again and then five years later you get an email with this in it. Oh, just me then. In this instance it was a fix for Excel 2010 and I thought it was not used … More Five year old piece of code suddenly fails.