In PowerApps a Choice field always shows as a dropdown, even when you select the ‘Checkboxes (allow multiple selections)’ option. This article is about how to change the default dropdown to a list of checkboxes. I have seen several ways of creating checkbox multivalued lists, but this way […]
I had a requirement to add a disclaimer message to a report that the user needs to agree to before they can see the report. My initial idea was to simply add it as a parameter, but the message was quite long and it looked terrible, so this […]
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 […]
In the previous article I talked about using savepoints for nested transactions. In this article will talk about how to handle rollbacks, and what to do when the Stored Procedures you use have their own transaction handling. There was a quote that I read once, I can’t remember […]
Transactions are a great way to group statements together in an all or nothing batch.However, nesting transactions is where things get a little messy, some people even call them evil. I note here that a big part of the reason people don’t like nested transactions is because they […]