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 […]
On occasions I have received the error ‘Maximum request length exceeded.’ when trying deploy an SSRS report. The Cause The problem comes from the report being too big for the size allowed by SSRS. The report probably has embedded objects like images or PDFs. The Solution Try and […]
I have been working with Microsoft.AspNetCore.Authentication.AzureAD.UI for authenticating with Azure AD. I noticed however that in a recent project it is now deprecated. So I thought I’d spend some time learning the new way of integrating with Azure AD using the Microsoft Identity Platform. I was pleasantly surprised […]
I recently got this message when trying to open a project created by another developer… I was surprised because everything on my PC was up to date.I tried installing the runtime but it told me that it was already installed.I checked the registry and that confirmed that I […]
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 […]
I received the error ‘The string was not recognized as a valid DateTime. There is an unknown word starting at index 17’ on a server when trying to convert a Date and Time string to a DateTime, but I had no such error in development or testing. The […]