Career

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.

Backend

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 amending the values. You can batch insert several records with one INSERT command and add new values on each line as many you like.

Backend

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 one stored procedure. You might do this for effiency and to avoid duplicating your SELECT/INSERT queries. We will create Stored Procedures to return primary keys to be subsequently used… Continue reading Create a Stored Procedure with a series of stored procedures