TechSug

TechSug Building scalable software systems & teaching the next generation of developers.

Specializing in cross-platform app development, C #, .NET, Flutter, and modern web solutions. 🚀 {}

17/09/2026

āĻāĻ•āĻŸāĻž āĻ›ā§‹āĻŸā§āĻŸ SQL mistakeâ€Ļ āĻ†āĻ° query āĻĨāĻžāĻŽāĻ¤ā§‡āĻ‡ āĻšāĻžā§Ÿ āĻ¨āĻž! 😱

āĻāĻ‡ short video-āĻ¤ā§‡ āĻĻā§‡āĻ–āĻžāĻ¨ā§‹ āĻšā§Ÿā§‡āĻ›ā§‡ āĻ•ā§€āĻ­āĻžāĻŦā§‡ āĻāĻ•āĻŸāĻŋ **missing increment** āĻ†āĻĒāĻ¨āĻžāĻ° `WHILE` loop-āĻ•ā§‡ **infinite loop** āĻŦāĻžāĻ¨āĻŋā§Ÿā§‡ āĻĻāĻŋāĻ¤ā§‡ āĻĒāĻžāĻ°ā§‡āĨ¤

āĻĒā§āĻ°āĻĨāĻŽā§‡ āĻ¸āĻŦāĻ•āĻŋāĻ›ā§ perfectly fine āĻŽāĻ¨ā§‡ āĻšāĻŦā§‡ —
✅ No error
✅ Query executing
✅ Green success vibe 😎

āĻ•āĻŋāĻ¨ā§āĻ¤ā§ āĻ•ā§Ÿā§‡āĻ• āĻ¸ā§‡āĻ•ā§‡āĻ¨ā§āĻĄ āĻĒāĻ°ā§‡āĻ‡â€Ļ

đŸ”Ĩ CPU 100%
đŸ’ģ SSMS freeze
📱 Server alert
😰 “Who ran that?”

The real problem? **One missing increment.**

Safe coding-āĻāĻ° basic rule:
👉 Always define a **clear exit condition**
👉 Make sure the loop variable actually changes
👉 Never assume “No error” means “Everything is safe”

āĻļā§‡āĻˇā§‡ āĻ†āĻĒāĻ¨āĻžāĻ° choice āĻ•ā§‹āĻ¨āĻŸāĻž?

🅰ī¸ Clear exit condition add āĻ•āĻ°āĻŦ
🅱ī¸ Process kill āĻ•āĻ°ā§‡ āĻĒāĻžāĻ˛āĻžāĻŦ
🅲ī¸ Network-āĻ•ā§‡ blame āĻ•āĻ°āĻŦ
đŸ…ŗī¸ “It worked on my machine” 😂

**Comment A, B, C or D 👇**

16/09/2026

āĻ­āĻžāĻŦā§āĻ¨ āĻ¤ā§‹...

āĻ†āĻĒāĻ¨āĻŋ āĻļā§āĻ§ā§ **āĻāĻ•āĻœāĻ¨ Employee-āĻāĻ° Salary Update** āĻ•āĻ°āĻ¤ā§‡ āĻšā§‡āĻ¯āĻŧā§‡āĻ›āĻŋāĻ˛ā§‡āĻ¨āĨ¤ 😎

āĻ•āĻŋāĻ¨ā§āĻ¤ā§ āĻāĻ•āĻŸāĻž āĻ›ā§‹āĻŸ āĻ­ā§āĻ˛...

`UPDATE Employees SET Salary = 70000`

**WHERE clause āĻ¨ā§‡āĻ‡!**

Result? 😭

āĻĒā§āĻ°ā§‹ āĻ•ā§‹āĻŽā§āĻĒāĻžāĻ¨āĻŋāĻ° āĻ¸āĻŦāĻžāĻ° Salary āĻāĻ•āĻ¸āĻžāĻĨā§‡ Change āĻšāĻ¯āĻŧā§‡ āĻ—ā§‡āĻ˛!

āĻāĻ‡ 30-second **SQL Server T-SQL Shorts**-āĻ āĻĻā§‡āĻ–ā§āĻ¨ āĻ•ā§€āĻ­āĻžāĻŦā§‡ āĻāĻ•āĻŸāĻž āĻ›ā§‹āĻŸ mistake Production-āĻ āĻŦāĻĄāĻŧ Disaster āĻšāĻ¯āĻŧā§‡ āĻ¯ā§‡āĻ¤ā§‡ āĻĒāĻžāĻ°ā§‡, āĻ†āĻ° āĻ•ā§‡āĻ¨ **BEGIN TRANSACTION + ROLLBACK** āĻ†āĻĒāĻ¨āĻžāĻ° life saver āĻšāĻ¤ā§‡ āĻĒāĻžāĻ°ā§‡āĨ¤

# # 🚨 What would YOU do?

🅰ī¸ Use `BEGIN TRANSACTION`

🅱ī¸ Press `ROLLBACK`

🅲ī¸ Restore Backup

đŸ…ŗī¸ HR-āĻ•ā§‡ āĻŦāĻ˛āĻŋ "āĻāĻŸāĻž bonus āĻ›āĻŋāĻ˛!" 😂

👇 Comment āĻ•āĻ°ā§āĻ¨ **A, B, C, or D!**

15/09/2026

One wrong command...

`git push origin main`

The code went live, the homepage broke, and the team chat exploded. 😭

This 30-second developer short recreates one of the most common Git mistakes—pushing unfinished code directly to the **main** branch instead of using a feature branch and Pull Request.

# # What would YOU do?

🅰ī¸ Revert the commit

🅱ī¸ Create a hotfix

🅲ī¸ Say "It was a test"

đŸ…ŗī¸ Hide offline forever 😂

👇 Comment A, B, C, or D!

14/09/2026

Ever created an **infinite loop** by accident? 😭

One missing `count++` turned a simple test into a laptop-freezing disaster. The terminal wouldn't stop, the fan hit maximum speed, and panic took over.

This 30-second developer short recreates one of the most common programming mistakes every coder makes at least once.

# # What would YOU do first?

🅰ī¸ Press `Ctrl + C`

🅱ī¸ Restart the laptop

🅲ī¸ Pretend it's compiling

đŸ…ŗī¸ Buy a new computer 😂

👇 Comment A, B, C, or D!

13/09/2026

Ever seen this SQL Server error?

> **"Incorrect syntax near 'WITH'"**

The query looks perfect... but one missing semicolon (`;`) before a CTE (`WITH`) can break everything.

In this 30-second SQL Shorts video, you'll see one of the most common SQL Server mistakes and the tiny fix that solves it instantly.

# # # What would YOU do first?

🅰ī¸ Add `;` before `WITH`

🅱ī¸ Restart SSMS

🅲ī¸ Blame SQL Server

đŸ…ŗī¸ Copy from Stack Overflow

👇 Comment A, B, C, or D!

12/09/2026

Every developer has heard this rule...

**đŸšĢ Never deploy on Friday.**

But what happens when you ignore it?

A quick `git push`, a failed deployment, nonstop calls from the client, and suddenly your weekend disappears. 😭

This 30-second developer short recreates one of the most relatable programming moments ever.

# # What would YOU do?

🅰ī¸ Roll back immediately

🅱ī¸ Debug all night

🅲ī¸ Pretend you never deployed

đŸ…ŗī¸ Start applying for new jobs

👇 Comment A, B, C, or D!

08/09/2026

Every programmer has said this at least once...

> "But it worked on my machine."

The code passed locally. The deploy looked successful. Then production crashed with a **500 Internal Server Error**. 😭

This 30-second developer short recreates one of the most relatable programming moments ever.

**What would YOU say next?**

🅰ī¸ It works on my machine.
🅱ī¸ Clear your cache.
🅲ī¸ Install Node first.
đŸ…ŗī¸ I'm updating my rÊsumÊ.

👇 Comment A, B, C, or D!

07/09/2026

Ever typed `DELETE FROM Customers` without a `WHERE` clause? 😭

One click. Zero rows. Instant panic.

This 30-second developer short recreates one of the most terrifying SQL mistakes—accidentally deleting an entire production database. Watch the disaster unfold and tell me...

**What would YOU do?**

🅰ī¸ Restore yesterday's backup
🅱ī¸ Use transactions next time
🅲ī¸ Blame the system
đŸ…ŗī¸ Close the laptop forever

👇 Comment A, B, C, or D!

07/02/2026

"GeoAttend" - āĻœāĻŋāĻ“āĻĢā§‡āĻ¨ā§āĻ¸ āĻ­āĻŋāĻ¤ā§āĻ¤āĻŋāĻ• āĻ¸ā§āĻŽāĻžāĻ°ā§āĻŸ āĻ…ā§āĻ¯āĻžāĻŸā§‡āĻ¨ā§āĻĄā§‡āĻ¨ā§āĻ¸ āĻ¸āĻŋāĻ¸ā§āĻŸā§‡āĻŽ!

📍 āĻ…āĻĢāĻŋāĻ¸ā§‡ āĻĸā§āĻ•āĻ˛ā§‡āĻ‡ āĻ…āĻŸā§‹ āĻšā§‡āĻ•-āĻ‡āĻ¨ ✅
📍 āĻŦā§‡āĻ° āĻšāĻ˛ā§‡āĻ‡ āĻ…āĻŸā§‹ āĻšā§‡āĻ•-āĻ†āĻ‰āĻŸ đŸšĒ
📍 āĻ…ā§āĻ¯āĻžāĻĄāĻŽāĻŋāĻ¨ āĻĻā§‡āĻ–āĻ¤ā§‡ āĻĒāĻžāĻ°āĻŦā§‡ āĻ•ā§‡ āĻ•ā§‹āĻĨāĻžāĻ¯āĻŧ āĻ†āĻ›ā§‡ đŸ—ēī¸

āĻ¤āĻŋāĻ¨āĻŸāĻŋ āĻ…āĻ‚āĻļ āĻāĻ•āĻ¸āĻžāĻĨā§‡ āĻŦāĻžāĻ¨āĻŋāĻ¯āĻŧā§‡āĻ›āĻŋ:
🔹 Backend API
🔹 Admin Web Dashboard
🔹 Android & iOS App

āĻŽā§āĻ¯āĻžāĻ¨ā§āĻ¯āĻŧāĻžāĻ˛ āĻ…ā§āĻ¯āĻžāĻŸā§‡āĻ¨ā§āĻĄā§‡āĻ¨ā§āĻ¸ā§‡āĻ° āĻĻāĻŋāĻ¨ āĻļā§‡āĻˇ!

07/02/2026

đŸ”Ĩ GeoAttend - āĻœāĻŋāĻ“āĻĢā§‡āĻ¨ā§āĻ¸ āĻ­āĻŋāĻ¤ā§āĻ¤āĻŋāĻ• āĻ¸ā§āĻŽāĻžāĻ°ā§āĻŸ āĻ…ā§āĻ¯āĻžāĻŸā§‡āĻ¨ā§āĻĄā§‡āĻ¨ā§āĻ¸ āĻ¸āĻŋāĻ¸ā§āĻŸā§‡āĻŽ!

āĻ†āĻĒāĻ¨āĻžāĻ° āĻ…āĻĢāĻŋāĻ¸ā§‡āĻ° āĻ…ā§āĻ¯āĻžāĻŸā§‡āĻ¨ā§āĻĄā§‡āĻ¨ā§āĻ¸ āĻŽā§āĻ¯āĻžāĻ¨ā§‡āĻœāĻŽā§‡āĻ¨ā§āĻŸ āĻāĻ–āĻ¨ āĻ¸āĻŽā§āĻĒā§‚āĻ°ā§āĻŖ āĻ…āĻŸā§‹āĻŽā§‡āĻŸā§‡āĻĄ!
āĻ†āĻ° āĻŽā§āĻ¯āĻžāĻ¨ā§āĻ¯āĻŧāĻžāĻ˛ āĻšāĻžāĻœāĻŋāĻ°āĻž āĻ–āĻžāĻ¤āĻž āĻŦāĻž āĻĢāĻŋāĻ™ā§āĻ—āĻžāĻ°āĻĒā§āĻ°āĻŋāĻ¨ā§āĻŸ āĻŽā§‡āĻļāĻŋāĻ¨ā§‡āĻ° āĻāĻžāĻŽā§‡āĻ˛āĻž āĻ¨ā§‡āĻ‡āĨ¤

📍 āĻāĻ‡ āĻĒā§āĻ°āĻœā§‡āĻ•ā§āĻŸā§‡ āĻ¯āĻž āĻ¯āĻž āĻ†āĻ›ā§‡:

🔹 āĻœāĻŋāĻ“āĻĢā§‡āĻ¨ā§āĻ¸ āĻŸā§‡āĻ•āĻ¨ā§‹āĻ˛āĻœāĻŋ - āĻ…āĻĢāĻŋāĻ¸ āĻāĻ°āĻŋāĻ¯āĻŧāĻžāĻ¯āĻŧ āĻĸā§āĻ•āĻ˛ā§‡āĻ‡ āĻ…āĻŸā§‹ āĻšā§‡āĻ•-āĻ‡āĻ¨,
āĻŦā§‡āĻ° āĻšāĻ˛ā§‡āĻ‡ āĻ…āĻŸā§‹ āĻšā§‡āĻ•-āĻ†āĻ‰āĻŸ
🔹 āĻ°āĻŋāĻ¯āĻŧā§‡āĻ˛-āĻŸāĻžāĻ‡āĻŽ āĻ˛ā§‹āĻ•ā§‡āĻļāĻ¨ āĻŸā§āĻ°ā§āĻ¯āĻžāĻ•āĻŋāĻ‚ - āĻāĻŽāĻĒā§āĻ˛āĻ¯āĻŧāĻŋ āĻ…āĻĢāĻŋāĻ¸ā§‡ āĻ†āĻ›ā§‡ āĻ•āĻŋāĻ¨āĻž
āĻ˛āĻžāĻ‡āĻ­ āĻŽāĻ¨āĻŋāĻŸāĻ°āĻŋāĻ‚
🔹 āĻ¤āĻŋāĻ¨āĻŸāĻŋ āĻŽāĻĄāĻŋāĻ‰āĻ˛ āĻāĻ•āĻ¸āĻžāĻĨā§‡:
✅ REST API (Backend)
✅ Admin Web Application (āĻĄā§āĻ¯āĻžāĻļāĻŦā§‹āĻ°ā§āĻĄ + āĻ°āĻŋāĻĒā§‹āĻ°ā§āĻŸāĻŋāĻ‚)
✅ Mobile App (Android & iOS)

🛠ī¸ āĻŦā§āĻ¯āĻŦāĻšā§ƒāĻ¤ āĻŸā§‡āĻ•āĻ¨ā§‹āĻ˛āĻœāĻŋ:
â€ĸ Backend API
â€ĸ Admin Panel
â€ĸ Mobile App
â€ĸ Maps & Geofencing - Google Maps API
â€ĸ Real-time Tracking


Address

Kolabagan, Panthopath
Dhaka
1205

Website

, ,

Alerts

Be the first to know and let us send you an email when TechSug posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category