Using GitHub Actions (missteps included)

Fresh off the back of the excellent Microsoft Build I wanted to try out the CICD capabilities directly inside GitHub; aka GitHub Actions (although ‘Actions’ aren’t specifically limited to this area). Getting started is absolutely free, with 2000 workflow minutes per month available right off of the bat (increasing based on your account type). The […]

DataTables Helper Module Creation

I’ve been adventuring, not for the first time, into the world of Datatables. I’ve worked with this library in the past and, through recent work, ended up deciding it was high time I put together a small, re-usable utility module. There were a number of underlying use cases to cover: The module needed to configure […]

Execution Plans via T-SQL – Super Simple

I recently had to do a very quick ‘rip and tear’ (high fives for the ‘Doom’ reference!) of stored execution plans for a bit of exploratory work I was involved with. It seems like a simple, shareable piece so here it is for you to grab, use and modify as and when you need it. […]

SQL FOR JSON Tour

I’ve worked on numerous occasions with the various flavours of the FOR XML clause within SQL Server. Taking that a step further, this seemed like as good a time as ever to check out how to work with the FOR JSON clause. This clause can, simply put, be used to boil down data retrieved via […]

Going Up…or…Going Down? OOP Inheritance!

A completely trivial subject coming up next…triggered by a really interesting debate I was involved with the other day. When dealing with class hierarchies and chaining constructor arguments through this hierarchy, what’s our mindset as to the direction of travel? Do we think of passing arguments ‘up’ or ‘down’ the hierarchy of objects (initially anyway, […]

SQL Identity Column Monitoring Script

I recently found myself in a position whereby I needed to know how the identity columns within a given database where configured. The information I was hunting for was as follows: Identity column name and table the column belonged to. The column Data Type The last seed value used. The difference between the maximum value […]

A Couple of Hours with Azure Maps

I’m having a random ‘pick a Channel 9 video and blog from there’ session; the subject of the day is Azure Maps and the inspiration came in the form of this video. The plan is to see what I can achieve in an hour or two, so here’s my quick rundown to wet your whistle. […]