Log4Net has become somewhat a de facto standard for logging in .Net applications, and I personally have used it in nearly every application I’ve written for quite some time. Although .Net Core does have some baked in logging, if you prefer to use Log4Net (or need to), then […]
In this article I will run through a problem I overcame where I needed to query a JSON array of attributes for each a record. I was working on a Stored Procedure that was querying JSON using REPLACE, SUBSTRING and a number of CHARINDEX‘s for every attribute. This […]
My Problem I had a problem today when I worked on a Power Apps Form for applying for Training, Accommodation, and or Travel (any or all of these). There was a Purpose field in the form which the user can enter one to many possible options (Training, Accommodation, […]
This article was written for SQL 2014 Summary If you have an SSRS subscription that emails out a report, but there is a requirement to only send that report if there is data, then that should be easy enough to do, shouldn’t it? From what I’ve found so […]
I have found that I have been using the same error handled transaction quite a lot recently. So I wanted created this snippet to have the script easily accessible. My main goal with this snippet was to have it easily and quickly accessible, with only a few keystrokes. […]
I recently found that a Tomcat server was running out of memory, I did give the service more, but I believe the problem to be a memory leak, so more memory is only a short term solution. Fixing the memory leak is obviously the best solution, but I’m […]
One of the applications I work with has more than 900 tables, so as you can imagine trying to determine where the data lives can sometimes be difficult. This script shows me which tables were updated by the last transaction. Add the database name in the USE and […]
Even though SQL Server 2016 has been out for a while now, and I’m sure there are plenty of articles on the new features that are available, I thought that I would write about are the features that I particularly like. Note that the outputs shown below are […]
Being sick of the difference between date formats in different systems, I decided to always format my dates in YYYY-MM-DD, Nobody’s going to get that screwed up, are they? I ran a query in an enterprise system today to retrieve everything since ‘2014-11-03’, it didn’t work???It turns out […]