Post

Test-Driven Development (TDD)

Test-Driven Development (TDD)

“Test-driven development (TDD) is a software development process that relies on the repetition of a very short development cycle: requirements are turned into very specific test cases, then the software is improved to pass the new tests, only. This is opposed to software development that allows software to be added that is not proven to meet requirements.”, from TDD - Wikipedia Why TDD and testing? Few things you should think about when writing code:
REST Calls with Postman

REST Calls with Postman

How to set up Postman In order to test REST calls one tool has emerged over the last few years: Postman The following 2-minute-video is great, great summary of how to set it up quickly: I do not want do get into the details. If you need them, you can find them here: https://blog.jongallant.com/2017/11/azure-rest-apis-postman/ REST calls in Azure Personally I have been working on some Azure stuff.
SQL Server Advanced

SQL Server Advanced

Sometimes you have a series of stored procedures that themselves are managed by another master stored procedure like so. This usually just means a series of EXEC statements after each other. It is quite handy to create a login event after each stored procedure call in order to check its progress. Logging with try-catch CREATE PROCEDURE loging AS BEGIN DECLARE @LogText nvarchar(max) EXEC Staging.SpVV_logIns 'procedure_name_to_log', 'START', null, 'I' BEGIN TRY begin tran --sql code commit EXEC Staging.
Azure Functions

Azure Functions

This blogpost will demonstrate how to set up Azure Functions with some Python code. More precisely, it will show how to call an Azure Function, add a parameter that specifies the name of the file that we want to read from and store that information in a database. Between reading and storing we have the chance to execute any python code we want. As long as it stays below the 30 min threshold :)
RStudio Addin

RStudio Addin

How to write your own Rstudio Addin If you want to create your own RStudio addins, all you need to do is: Create an R package Create some R functions Create a file at inst/rstudio/addins.dcf Links https://rstudio.github.io/rstudioaddins/ https://github.com/rstudio/addinexamples devtools::install_github("rstudio/addinexamples") 1. Create am R Package Set up tools for package development library(devtools) library(roxygen2) # getwd() # setwd("path/to/repo") Create Package I am mainly following: https://hilaryparker.com/2014/04/29/writing-an-r-package-from-scratch/ create("rstudio_addin") This creates the following files and folder structure: