Contents tagged with sql
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 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, …
Since the availability of a preview version of SQL Operations Studio (SOS, for short) was announced in November last year, It's been forever on my to-do list to download and take a look. Like …
There are three little checkboxes that are ticked by default when creating a user through the SQL Server Management Studio user interface:
Enforce password policy
Enforce password expiration …