Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days Amazon Web Services AWS Azure Batch code Coders At Work Computer Science cron Data Databases DataScience Django Eda Edsger W. Dijkstra Excel Git Google Hadoop Hellerstein Javascript Jinja Knowledge Transfer Learning MVC Networking Networks Protocols Notes on Structured programming PHP Power Bi Powershell Python Redash Social Skills Software Developer Spark: The Definitive Guide SQL SSH Testing The Elements of Programming Style The humble programmer Traversy Media Understanding Distributed Systems Web Development Yaml

Archives

Category: Others

How to Rename a Git Branch Locally and Remotely

Renaming Git branches can be necessary when adhering to naming conventions or correcting errors. This guide will walk you through the process of renaming a branch locally and remotely. Scenario: You accidentally pushed a branch named old-branch-name to the remote repository but realize it should follow the convention feature/new-branch-name. Steps to Rename the Branch 1.
Read More

Route Summarization and Subnetting

We will walk through the process of subnetting a network and performing route summarization using an example. Subnetting Example Let’s consider the following four subnets: Binary Representation To better understand these subnets, let’s convert the IP addresses to their binary form: Common Bits With a subnet mask of /22, we need to consider the first
Read More

SODA: SSL: CERTIFICATE_VERIFY_FAILED – Solved

When you tried to connect to soda it is possible you find this error: SSL: CERTIFICATE_VERIFY_FAILED. All the message look like similar to this one: This happens because there is a conflict between the permissions your machine have to connect to other places in the network and the usage statistics that SODA does. In fact,
Read More

SODA: Connect SQL Server without Password

When you do your first steps using soda, it is possible you want to connect to an SQL Server database. In that case you can create an specific user and give him the proper rights I wrote about that in the following post: Connect Soda to SQL Server. But, Is it possible to use the
Read More

SODA: Check count distinct elements

Categories in Data Quality When you are doing a quality you’re looking for six levels of knowledge about it. It might change depends on your requirements and what is the usage about it. Because, in general speaking the that not always work in a synchronous way, it’s possible that it could be from outside your
Read More

SODA: Connect to SQL Server

After deciding to install SODA to make your quality check you have to connect the data source to SODA. We are going to see how to connect soda to Microsoft SQL Server. Remember that this is a tutorial in order to use, in an easy way the SODA quality check tool on your machine .
Read More

ASTRONOMER: Install on Windows

Install Astronomer is quite simple In windows you have to follow the following steps: 1 – Install docker Go to the docker’s webpage, download the executable and install it. Installation succeeded 2 – Install Linux on Windows with WSL As you can see on the Microsoft documentation you have to run on PowerShell the following
Read More

What is an ‘Ephemeral cluster’?

When you create a service to compute, for example in HD-Insight you can create a cluster which remains active once it’s created or, in the other hand, stop (will be ‘deleted’) after some amount of innactivities. If you, like me, your first approach was with the Azure Service you’ll notice that the name if the
Read More