Pre-requisites: Microsoft SQL Server, some knowledge of SQL, and a sample database, Northwind. You can find Northwind sample databses from this webpage https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs Criteria From time...
Continue reading...SQL – Concatenate Names and get totals
In this short blog post, I’ll show you how to concatenate an employee firstname and last name, then get the total orders made under that employee....
Continue reading...Interviewing a Deaf/Hard of hearing candidates
Are you interviewing a deaf/hard of hearing candidate online? Deaf people can communicate by speech, sign language or both. Before the interview starts, check if they...
Continue reading...How to get podcasts auto-captioned on your TV (Windows 10)
Overview This is a guide showing you how to get podcasts auto-captioned on your TV. What you need is: Your PC/laptop must have ability to screen-cast...
Continue reading...Use Trello to organise your Job Hunting
Trello is a really useful tool for organising for your personal or professional projects. It can also be useful to organise your job hunting.
If you never used Trello before, you can get 10 free boards. You can use those boards for any projects you’re working on. Trello uses some Kanban concepts which allows you to monitor progress of your tasks.
Continue reading...Don’t Delete Records. DeleteFlag instead
If you have a process which can delete records from the database, it would be best to DeleteFlag them instead. You should add a few columns...
Continue reading...Batch Insert Records
If you need to insert multiple records at the same time. Writing out those SQL insert queries can be laborious. Setting the same fields and then...
Continue reading...Create a Stored Procedure with a series of stored procedures
We’re going to cover on how to write a stored procedure with a series of stored procedures. That means running a number of stored procedures within...
Continue reading...Deafness – Being Inclusive
As part of Deaf Awarness week, I’m writing small guides on deafness. If you have a deaf colleague, it’s important you make your deaf colleague inclusive in all things such as discussions or video calls.
Continue reading...Deafness – Video Calls
As part of Deaf Awareness Week, I have written this a wee guide if you have a deaf colleague and they are required to attend a...
Continue reading...
Recent Comments