Things that are, or should be Best Practice
In the world of software development, the terms “Agile” and “Scrum” are often used interchangeably. However, it’s crucial to understand that while all Scrum practices are Agile, not all Agile practices are Scrum. Let’s explore the differences between Agile and Scrum and why practicing Agile doesn’t necessarily mean […]
Because I have previously written 2 articles with my own code for working with CSV files, I thought it was time I did a comparison between my own simple code and the most common Nuget package, CsvHelper. The articles I have previously written are What is CsvHelper CsvHelper […]
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 […]
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 […]