Is Low-Code viable for developers?
Low-code platforms are often praised for their ease of use and understandability by business users however some developers may not be too excited by this prospect. What if there is an alternative to low-code that follows coding principles? Will such an interface feel more natural for developers? Before asking that question, we must ask, is low-code a viable solution for developers?
What are APIs? The basics
APIs are everywhere. It is one of those terms that no one can go without knowing. If you’ve ever used a website or an app, you’ve probably interacted with an API without realising it. API stands for Application Programming Interface, and it’s a way for different applications to communicate. So, what exactly is an API? At a high level, an API is a set of protocols, routines, and tools for building software and applications. It defines how different software components should interact with each other, making it easier to build complex applications by breaking them down into smaller, more manageable parts (sometimes). An API is essentially a way for different applications or pieces of software to interact with each other. It’s a way to share data and functionality. If you think of software as a human body, an API is likely the hands. Basic concepts I came across a meme…
Azure Data Studio – Cool Snippets
Some cool Azure Data Studio Snippets
API vs Webhook – What’s the difference?
In this post we look at the difference between APIs and Webhooks. We will also take a deeper look into APIs. Spoiler alert: a webhook is just a reverse API.
Regex – Cheat Sheet – Basic – Anchors
All the examples below have been tested in Notepad++. Notepad++ can be found here. These examples can also work in other platforms with some minor syntax changes to them. Anchors Types Of Anchors ^ used to denotate the start of a string or line $ used to denote the end of a string or line Use Case for ^ Let’s say we have the list below and we want to add the letter G to the start of all the strings below. Press Ctrl + H to bring up the replace window in Notepad++ or your set shortcut key for it. In order for this to work you have to set the following: Ensure that the text cursor is at the start of the list or that all the text is selected (by using Ctrl + A). ^ in Find what section. G in Replace with section. Ensure that the…
5 Quick tips for MSSQL Management Studio
We take a look at 5 quick tips and tricks Microsoft SQL Management Studio that is sure to save your time and will enhance your productivity
Azure Data Studio My New Muse (Part 1)
What you can expect Brief explanation of Azure Data Studio followed by some tips and tricks to optimize your coding experience in Azure Data Studio. What is Azure Data Studio Azure Data Studio is Microsoft new SQL Server Management studio that is solely focused on development. Azure Data Studio does not have all the functions of SQL Server Management studio and it does not seem like they are going to change that at the time of writing this. However, the features and tools it provides are amazing. We are going to look at some of them in this post. SQL Snippets These functions are similar to SSMS (SQL Server management Studio) Boost’s auto replacements and are quite easy to setup. In Azure Data Studio hit Ctrl + Sift + P and type snippets Now type SQL to select the SQL option You will end up here To create a snippet,…
SQL – CTE – Basics
Brief explanation of what a CTE is and how to use them to optimize your queries.
SQL Loopidy loops… A case for TSQL loops
What will I read: In this post we will look at TSQL Loops, what they can be used for and at a practical example. This is applicable to MS SQL but I believe it also holds value for other databases.
ETL, what? Why?
What will I read: In this post we will look at the absolute basics of ETL. We will look at a small example and the practical uses of it.