Contents tagged with sql server
We've recently had reports that some scheduled reports that are emailed out haven't been sent/received, looking at SSRS the error that was showing was:
Failure sending mail: The report server has …
This is almost certainly something a lot of other people know, but I've somehow managed to not learn it in the many (many!) years of using SQL Server that I have under my belt...
You can use the …
I answered a question on Stackoverflow today that was looking to cater for having parameters to the query that aren't always required, i.e.
The report has three parameters, Sales Id, Start Date and …
One of the reporting requests I see from time to time is to have output grouped into ranges, or bands if you prefer, e.g:
Conditional totals for groups of rows, based on the value of a given column, in SQL Server Reporting Services
SQL Server Reporting Services seems like a bit of a dark art at times (trying to look at the markup behind an RDL file definitely is!), for 90% of report based requirements it can be used to quickly …
Unfortunately (and annoyingly, at times!) it's not possible to persuade a SQL Server User-Defined Function to throw, though I've managed to find (more by luck thank judgement!) a way to get the …
SQL Server Reporting Services is a great tool for building reports quickly, except for the horrendously hard to maintain XML format that the report definitions get persisted in. Recently I was …
In two recent posts I've been looking at ASP.NET Core Identity, first changing it up so that the data-type for the Id fields in Integer rather than a stringified GUID and then separating out the …
In a recent post I described how to change the data type that ASP.NET Core Identity uses for the generated id's for users. Before I go much further I want to split this out into a separate library, …
I've been working on an ASP.NET Core web project using the built-in ASP.NET Core Identity solution. All the project scaffolding was done by choosing to create a new ASP.NET Core Web Application, …