People Who Code | Blog: June 2022

Create a component with a button that will show and hide text by clicking

SQL Server — Core Concepts with examples

Data Definition Language (DDL) : CREATE , ALTER , DROP (tables, views, procedures, triggers). Data Manipulation Language (DML) : SELECT ,...

Best for you

Useful VS Code Extensions / Packages

Name What it does Why helpful for checking commits / trees GitLens Enhances built‑in Git support: inline blame, commit graph, file history...
using SQL Server, and you want to import 20+ tables from Production into UAT in one go, here’s a streamlined process using SQL Server Management Studio (SSMS).

Goal: Import All Tables from Production into UAT (One Time) 🔧 Method 1: Generate Scripts (Schema + Data) This is the cleanest way to ex...
experiencing caching issues when deploying an Angular build to an IIS server, where the changes are not reflected immediately, and you need to refresh multiple times. This is a common issue, and here are some steps

1. Disable Caching for Development Mode Browser Caching : Browsers tend to cache assets like JavaScript and CSS files aggressively. In deve...
How To find the maximum number in an array javascript

You can use the Math.max function along with the spread operator. Here's a simple example: javascript code : const numbers = [3, 5, 7, 2...
commonly used in modern ASP.NET Core apps more examples using fetch + Blob in JavaScript to download files PDF, Excel

Let’s explore real-world examples using the fetch + blob pattern, targeting different file types and scenarios. ✅ 1. Download Static PD...
To solve this problem, we need to calculate the success rate of posts that immediately follow a failed post for each user. The success rate is defined as the percentage of such posts that are successful

Approach Problem Analysis : The task involves analyzing the sequence of posts made by each user to determine the success rate of posts tha...
Errors in the logs during the Angular SSR (Server-Side Rendering)

Error Handling : If there are errors that aren't properly handled, it can cause delays during the server-side rendering process. The s...
Breakdown Web Tokens

the context of JWT (JSON Web Tokens) and token-based authentication, the term "both parties shared secret key" refers to a symmet...
Difference between “==” and “===” operators

Both are comparison operators. The difference between both the operators is that,“==” is used to compare values whereas, “ === “ is used t...
To solve this problem, we need to reverse a singly linked list. The goal is to reverse the direction of the pointers in the list such that the last node becomes the first node, and the first node becomes the last node.

Approach The approach involves iterating through the linked list while reversing the pointers of each node. Here’s a step-by-step breakdow...