Gopal Krishna Ranjan

Gopal is a passionate Data Engineer and Data Analyst. He has implemented many end to end solutions using Big Data, Machine Learning, OLAP, OLTP, and cloud technologies. He loves to share his experience at https://sqlrelease.com//. Connect with Gopal on LinkedIn at https://www.linkedin.com/in/ergkranjan/.

ASP.NET Core MVC Entity Framework Web App for CRUD operations

In this post, we will demonstrate how easily we can create a web application with CRUD functionality using ASP.NET Core, MVC, and Entity Framework. ASP.NET core is a part of the .NET Core framework which is an open-source framework for Windows, macOS, and Linux operating systems. It provides a cross-platform development environment for the developers. […]

ASP.NET Core MVC Entity Framework Web App for CRUD operations Read More »

Access git repository using SSH key in PyCharm on Windows and Mac machine

In this post, we are going to discuss how we can set up git bash, SSH keys, and PyCharam IDE to access a git repository using the command line on a Windows or Mac machine. First, we will set it up on a Windows machine followed by a Mac machine. The setup process is very

Access git repository using SSH key in PyCharm on Windows and Mac machine Read More »

Continuous Integration and Continuous Deployment (CI/CD) – SQL Server Database testing using tSQLt – Part 4

In the previous posts, we have created a Continuous integration and a Conntinuous Deployment pipeline for a SQL Server database using the Azure DevOps server. Also, we have demonstrated how we can set up the cross-database dependency for a SQL Server database project in the Azure DevOps pipeline. Below are the links in case you

Continuous Integration and Continuous Deployment (CI/CD) – SQL Server Database testing using tSQLt – Part 4 Read More »

Continuous Integration and Continuous Deployment (CI/CD) – SQL Server Database project dependency – Part 3

Previously, we have created an Azure DevOps Continuous Integration (CI) and Continuous deployment (CD) pipelines to independently deploy a SQL Server database project. However, in an enterprise data warehouse environment, the databases are mostly dependent on other databases. Because, in DWH, we access objects from multiple databases (like accessing the staging layer objects into the

Continuous Integration and Continuous Deployment (CI/CD) – SQL Server Database project dependency – Part 3 Read More »

Continuous Integration and Continuous Deployment (CI/CD) – SQL Server Database CD – Part 2

In the previous post, we have created a CI (Continous Integration) pipeline for a SQL Server database project. For this demo, as like our previous demo, we will be using a SQL Server instance running on an on-prem machine along with a locally installed Azure DevOps Server. Please note that we are not using the

Continuous Integration and Continuous Deployment (CI/CD) – SQL Server Database CD – Part 2 Read More »

Continuous Integration and Continuous Deployment (CI/CD) – SQL Server Database CI – Part 1

In this post, we are going to discuss how we can enable continuous integration and continuous deployment for a SQL Server Database project using Azure DevOps Server. For this demo, we will be using a SQL Server instance running on-prem along with a locally installed Azure DevOps Server. Continuous integration and continuous delivery (in short

Continuous Integration and Continuous Deployment (CI/CD) – SQL Server Database CI – Part 1 Read More »

Cleanup historical data in Temporal table using Retention Policy

Temporal tables were introduced by Microsoft in SQL Server 2016. From SQL Server 2016 onwards, temporal tables can be used to capture DML changes on a table without writing a single line of code. We have already discussed temporal tables in multiple blogs which can help us to understand it in more detail: Temporal Table

Cleanup historical data in Temporal table using Retention Policy Read More »

Audit created and modified by user in temporal table (without trigger)

Microsoft introduced Temporal tables in SQL Server 2016. Temporal tables are system versioned tables that have built-in support for row-level change tracking. We can create a new table as a temporal table or we can convert an existing table into a temporal table. The temporal tables keep the current data into the main table and

Audit created and modified by user in temporal table (without trigger) Read More »

An Introduction to mssql-cli – Cross platform Interactive command line tool for SQL Server

In this post, we are going to discuss a new cross-platform and interactive command-line query tool that can be used to communicate with Microsoft SQL Server. Unlike sqlcmd command-line utility, mssql-cli supports cross-platform and can be used on Windows, macOS, Linux, Ubuntu, Debian, CentOS, Fedora, and etc. This is an open-source tool and it supports

An Introduction to mssql-cli – Cross platform Interactive command line tool for SQL Server Read More »

Relationship between Binomial and Poisson distributions

In this post, we are going to discuss the Relationship between Binomial and Poisson distributions. We know that Poisson distribution is a limit of Binomial distribution for a large n (number of trials) and small p (independent probability for each trial) values. A large number of trials n with very small probability p indicates a

Relationship between Binomial and Poisson distributions Read More »