Home » Archives for Sergio Lauriano Junior

Author Archives: Sergio Lauriano Junior

Sergio is graduated in Software Development in the University City of São Paulo (UNICID). During his career, he get involved in a large number of projects such as telecommunications, billing, data processing, health and financial services. Currently, he works in financial area using mainly Java and IBM technologies.

Install Python on Mac OS

In this article, we’re going to install Python on Mac OS using the software pyenv. Also, we’ll see some configurations to set our Python version and run an example. 1. Introduction 1.1 Pre-requisites For this article, it’s recommended to install the package manager Homebrew. It’s an open-source package management system that makes simpler the installation of software on a macOS ...

Read More »

Download and Install SQL Server Management Studio

In this article, we’re going to the steps to download and install the Microsoft SQL Server Management Studio (SSMS). 1. SSMS System Requirements SQL Server Management Studio (SSMS) is a powerful application maintained and distributed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server. The application was first launched with Microsoft SQL Server 2005 ...

Read More »

How to Learn Python for Data Science

In this article, we’re going to discuss Data Science with Python. The way to start your studies, the necessary stuff, and why you should learn Python. 1. Why Learn Python For Data Science? I’m a big fan of the phrase “all knowledge is valid”. That means, everything you study can bring something to add to your life as well to ...

Read More »

How to Download and Install MySQL

In this article, we’re going to see how to download and install MySQL using the default installer. Also, we’ll set up the server using the auto start package and do some examples. 1. Download MySQL Installer As Linux/macOS-based system user, I commonly use a package manager like Home Brew and APT in the terminal to install software that I need. ...

Read More »

SQL SUBSTRING Function

In this article, we’re going to explain the SUBSTRING function in SQL. 1. Introduction The SUBSTRING function is available in SQL Server (from 2008 edition) and MySQL (from version 4.0) as a part of String functions. Using this function we’re able to manipulate strings directly with a SQL query. Also, in combination with other functions and procedures, the SUBSTRING function ...

Read More »

SQL is null – SQL is not null

In this article, we’re going to see how to test null values in an SQL database. 1. What is a NULL Value? Basically, a field with a NULL value in a SQL table is a field without value. When creating a table, we can mark a column that accepts null values when inserting data into the table. A null value ...

Read More »

SQL Server Versions

In this article, we’re going to see several Microsoft SQL Server versions and editions and how to identify them. 1. Introduction On MSSQL Server we need to determine the version and edition to troubleshoot some issues or to know if feature support is available. To do that, MSSQL Server introduces some procedures to identify the version and edition which we’re ...

Read More »

Java Runtime Environment Tutorial

In this article, we’re going to discuss Java Runtime Environment, the bundle used to run Java applications and libraries. 1. What is a runtime environment? The runtime environment is the environment in which a program or application is executed. As soon as a software program is executed, it is in a runtime state. Java Runtime Environment (JRE) is the software ...

Read More »

ctypes in Python

This article will show how to use the built-in “ctypes” module in Python to use external C language libraries. 1. Introduction As developers, we can work with a lot of programming languages during our careers. Sometimes, we need to extend external libraries from another application, like a legacy system or even a shared OS library (.dll, .so, and so on…). ...

Read More »

Build a REST API with Spring and Java Config

In this article we’ll see how to build a REST API using Spring Boot and Java Config. 1. Introduction Spring is a diversified framework and we can build basically any kind of application using its tools. Also, a majority of applications today use Spring Boot as the background of web services to connect and create a Server-Client solution. In the ...

Read More »