blog
My blog of techy stuff, ranging around SQL (SQL Server, that is), C# and .net, JavaScript and a smattering of stuff about the Orchard CMS (that powers my site) as I get more familiar with it. There's the occasional non-technical post when something is of interest to me that I feel is worth sharing, but they should be few and far between
-
End of 2018 link dump
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 …
-
Using the Tabulator javascript library to prettify tables
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 …
-
Using the PSWindowsUpdate module to interrogate Windows Update
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 …
-
Setting up OpServer, the awesome monitoring solution from Stack Exchange
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' …
-
Using SQL Server to generate ranges and group data into them
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:
From
To
Quantity
Value
0
250
3
125.52
250
500
8
3, …
-
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 …
-
Using Azure Traffic Manager to divert to a holding page for a site that's not available
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 …
-
Using Azure App Services to host a holding page for a site that's not available
In the first post of this series I put together a .NET Core application that uses Azure Storage (in table form) to keep records of "call me back" requests from customers, so that when the main site …
-
Using Azure to provide a holding page for a site that's not available
One of the fantastic things about Azure is how quickly you can spin up, and down, services as and when you need them. In a world where not everything's been migrated to the cloud yet this can be …
-
Running an ASP.NET project yellow screens with "Could not find a part of the path 'D:\Path\To\Project\bin\roslyn\csc.exe'"
I recently had to pull a project onto a different PC and for some reason even after running a NuGet package restore and building the solution, running the project failed with an error as the roslyn …