---
title: "The Noid (@thenoid) | Hashnode"
description: "SYSTEMS DON'T SLEEP. NEITHER DO I. Read the latest articles by The Noid on Hashnode."
url: "https://hashnode.com/@thenoid"
---

@thenoid

# The Noid

@thenoid · Pune, India · Joined June 2026

SYSTEMS DON'T SLEEP. NEITHER DO I.

### [HOW I SET UP A LINUX LAB & SSH ON MY LAPTOP TO PRACTICE PRODUCTION COMMANDS](https://blagos.hashnode.dev/how-i-set-up-a-linux-lab-ssh-on-my-laptop-to-practice-production-commands?utm_source=hashnode&utm_medium=feed)

WHY I REQUIRE A LAB ? When I first started working in production support, I quickly realized that Linux commands are a part of the job. We use them to look at logs, check processes, see how much disk

14 min read · [blagos.hashnode.dev](https://blagos.hashnode.dev/how-i-set-up-a-linux-lab-ssh-on-my-laptop-to-practice-production-commands?utm_source=hashnode&utm_medium=feed)

[Aug 13](https://hashnode.com/posts/how-i-set-up-a-linux-lab-ssh-on-my-laptop-to-practice-production-commands/6a7de327231a346a505f04b0)

### [SQL - TRUNCATE VS DELETE DIFFERENCE](https://blagos.hashnode.dev/sql-truncate-vs-delete-difference?utm_source=hashnode&utm_medium=feed)

TRUNCATEDELETEIt is DDL command.It is DML command.It does not support where clause.It is support where clause.It is permanent delete.It is temporary deletion.It delete all table but keeps it's structu

1 min read · [blagos.hashnode.dev](https://blagos.hashnode.dev/sql-truncate-vs-delete-difference?utm_source=hashnode&utm_medium=feed)

[Aug 10](https://hashnode.com/posts/sql-truncate-vs-delete-difference/6a7a33c13625acf6fc42c7e0)

### [SQL - WHERE VS HAVING DIFFERENCE](https://blagos.hashnode.dev/sql-where-vs-having-difference?utm_source=hashnode&utm_medium=feed)

WHERE HAVING Where clause applied to single row. Having clause applied to groups. Where clause filter the records before grouping the data. ( pre -filer ) Having filter the records after grouping

1 min read · [blagos.hashnode.dev](https://blagos.hashnode.dev/sql-where-vs-having-difference?utm_source=hashnode&utm_medium=feed)

[Aug 10](https://hashnode.com/posts/sql-where-vs-having-difference/6a7a3053291b8d75535e3ea6)

### [SQL INDEXES](https://blagos.hashnode.dev/sql-indexes?utm_source=hashnode&utm_medium=feed)

It is a database object which is used to retrieve data from the database more quickly. WHY WE USE INDEX : To retrieve data from the database quickly. To improve the performance of SELECT queries. T

1 min read · [blagos.hashnode.dev](https://blagos.hashnode.dev/sql-indexes?utm_source=hashnode&utm_medium=feed)

[Aug 10](https://hashnode.com/posts/sql-indexes/6a7a2bb83b9dc113cc6b6270)

### [SQL VIEWS](https://blagos.hashnode.dev/sql-views?utm_source=hashnode&utm_medium=feed)

It is a database object. It is a logical or virtual table in the database . A VIEW does not store data physically. VIEWS TYPES : Simple View Complex View Only Read With View With Check Option View

3 min read · [blagos.hashnode.dev](https://blagos.hashnode.dev/sql-views?utm_source=hashnode&utm_medium=feed)

[Aug 10](https://hashnode.com/posts/sql-views/6a7a2694d18ff6d1adc1d2a5)
