Archives
-
Styling the Orchard Tag Cloud so it looks like a cloud, not a list
I've had a tag cloud sat on the right-hand side of my blg (or down the bottom for those viewing on mobile devices, or computers with tiny screens) pretty much since I set it up on Orchard. The tag …
-
My "Hit Refresh" moment - twelve months on
Yeah - it's the cat, again.
Twelve months ago Dona Sarkar encouraged me to write about My Hit Refresh moment. Quite a lot's changed since then so I thought it'd be good to write a retrospective, …
-
SQL Operations Studio is now Azure Data Studio, with added Azure Resource Explorer
In true Microsoft fashion, SQL Operations Studio has undergone a re-brand and is now Azure Data Studio (you can download it here). Along with the reccent re-brand of Visual Studio Team Services (the …
-
'Application cannot be started' running SQL Server Reporting Services Report Builder
SQL Server Reporting Services delivers its Report Builder as a click-once application when you click on the 'Report Builder' icon in the toolbar of the web application, unfortunately sometimes it " …
-
TIL: You can mark due dates on Trello cards as complete
I use Trello at work to keep track of support requests from the business in lieu of a full ticketing system (though that's something that's in the works!). As a stop-gap measure to make sure we can …
-
SQL Operations Studio, what is it and why should I use it?
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 …
-
Resolving the error "'bobj' is undefined" with Crystal Reports
Every couple of months the Crystal Reports installed in an application here stops working (reports don't display) after the server that hosts it has been Windows Update'd with the wonderfully …
-
Converting a simple solution/project to .NET Core
I have a very small project I started writing back in 2015 for parsing responses from DNS servers, more because I was interested in how to do so than any real need. Because this mostly pre-dates . …
-
Setting up SQL Server Reporting Services to use HTTPS/SSL
By default SQL Server Reporting Services (SSRS) sets itself up to respond to requests over HTTP made to the name of the machine that it's been installed on. Changing this up so that it can be …
-
Have you ever created a SQL Server login and left 'Enforce password policy' checked by mistake?
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 …
-
A custom model binder for XML content that produces IEnumerable<T>'s
In a previous post (A custom model binder for XML content) I showed code for a custom MVC Model Binder that takes an XML filled string passed to an action and transforms it to an XDocument. The …
-
Link Dump
I haven't had cause to drop one of these since November last year, probably at least in part because Edge seems to have a nasty habit of eating tabs! In no particular order, and likely of more use to …
-
Running a local npm repository on Windows Server using Verdaccio
I've recently had cause to build a local NPM repository server, for a couple of reasons (Edit: I started this post about 6 months ago and came back to it now, so if there's any parts where the …
-
Using robots.txt to block indexing isn't always right, and how to fix it with Orchard CMS
Since Google started revamping their webmaster tools recently it's made seeing some of the issues they consider my site to have more apparent. One of these is "Indexed, though blocked by robots.txt" …
-
Creating a template for 'dotnet new' for Microsoft.Build.Traversal
In a recent post I described using Microsoft.Build.Traversal in lieu of solutions for building your projects, with steps to create a sample solution and the Traversal project using the .NET Core …
-
Hiding empty years in the Orchard blog archive list
Because I had a bit of a stop/start relationship with my blog for the best part of a decade there are a lot of years where there aren't any posts. This kinda filled up the "Archives" list I've got …
-
Using Microsoft.Build.Traversal in lieu of solutions for building your projects
Somewhere recently I came across a reference to the Microsoft.Build.Traversal SDK which has been sat in an open tab in my browser ever since. Traversal:
Supports creating traversal projects which …
-
Fixing up the archive counts in Orchard
For reasons best known to itself, sometimes Orchard gets a little count happy with the number of posts in a given archive year/month and over exaggerates the number of posts present. Fortunately …
-
Don't use 'SET DATEFORMAT' and don't manipulate dates as strings
There are two things that're a bad idea when it comes to dates and SQL Server (that I'm blogging about right now, there are surely many more than that!), using 'SET DATEFORMAT' to alter the default …
-
Using the new Microsoft Library Manager to Bootstrap a project
The latest release of Visual Studio 2017 (15.8) comes with Microsoft Library Manager, or LibMan for short, there's also a CLI available and if you want to read about it from the horses mouth …
-
Using Common Table Expressions to explode recipes - Part 2 - Getting the ingredients
A Brief Recap
In the last part of this article I showed a table structure for recipes and their ingredients. There are two kinds of ingredients that a recipe can contain, raw ingredients (e.g. …
-
Using Common Table Expressions to explode recipes - Part 1 - The CTE
A lot of the examples that you see for using Common Table Expressions (CTEs) in SQL Server, particularly recursive ones use examples that are around user hierarchies - showing ways to find all the …
-
Using Sequence Numbers in SQL Server
Microsoft introduced the concept of Sequence Numbers in SQL Server 2012 which are:
... a user-defined schema-bound object that generates a sequence of numeric values according to the specification …