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 […]

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. […]

Zoning out with Moment Timezone

I’ve recently been heavily embedded in implementing time zone sensitivity into a web application and I thought I’d share my first experiences on handling this from the perspective of the browser. A great little library for handling this kind of tricky number can be found in the form of Moment Timezone, which sits proudly beside […]

T-SQL Grouping Set Showcase

Greetings all, In the interim, whilst I juggle my time to get more in-depth posts rolled out (like the one surrounding Alexa skills), I back-tracked once again to look at overlooked features from the distant past of SQL 2008. I’ve chosen the topic of GROUPING SETS as the basis of this post; which basically boils […]

Coding Snippets in SSMS (Microsoft SQL Server)

Hi all, Continuing on with the idea of coding snippets, here’s a follow up showing the (very similar) procedure for creating snippets in SQL Server Management Studio (SSMS). As before, you’ll need a file with the ‘.snippet’ extension to begin, which contains a snippet in an XML format. A basic example is shown below for […]

Groovy JavaScript Regex Name Capitalisation Handling

Greetings! A tidbit found by a friend of mine online, forming the basis for a small piece of work I’ve done this week surrounding name capitalisation. This was pulled from a stack overflow article so credit where credit is due for starters: js-regex-for-human-names This is fairly robust, covering Mc, Mac, O’s and double-barrelled, hyphenated names. […]

Developer Testing Hints and Tips

Howdy happy campers. I want to discuss a piece, somewhat divergent from the topic of physical coding, although still a facet of development that is close to my heart (and easy to overlook in many respects when constantly mashing keys and churning out code); developer testing. More specifically, I want to provide a set of […]