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 …
After a thoroughly action packed 2018 where I’ve learnt many different new technologies (AngularJS, Gulp and more) along with some more protocol-esque things (SWIFT, you and your MT103s and friends, …
Things I've had open in tabs to read, some of which may be of interest to you!
Nick Craver - Stack Overflow: How We Do Monitoring - 2018 Edition
Seriously, read it. There's a lot you can take away …
There are more than a few different libraries out there which can be used to pretty up HTML tables in various different ways. One that I've recently spotted is Tabulator. In order to have a play …
I've been looking at automating the patching of some servers that aren't domain joined, and one of the tools that I've spotted that may come in handy is the PSWindowsUpdate module. Once it's …
Monitoring. You know it's important, I know it's important, Everyone knows it's important, but,... it's often not given the focus that it so justly deserves.
If you're in a position where you don' …
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 …
In the first post in this series I put together a holding page that uses Azure Storage to write "call me back" details to Table Storage (so it doesn't rely on anything other than Azure), in the …