SQL is not a Programming Language
SQL is not a Programming Language. You’ve probably heard someone say “I know SQL” when asked about programming languages. Or maybe you’ve seen job ads listing SQL next to Python, Java, or C#. Technically, they’re wrong. SQL is not a programming language.It’s a query language, and that difference is its greatest strength. Let me explain…
Read MoreWindows Command Prompt Part 3
Windows Command Prompt Part 3: Rename, Wildcards ?, Search Subfolders, and saving Output to FilesWelcome to the final chapter (for now!) of my Command Prompt series. In Part 1 we covered navigation (CD) and listing (DIR with * wildcards).Part 2 showed copying, moving, and deleting. Today: renaming files, the ? wildcard, searching subfolders, and saving…
Read MoreWindows Command Prompt part 2
Windows Command Prompt part 2: Copy, Move, XCopy, and Delete files & folders safely In Part 1 we covered navigation (CD) and listing (DIR with wildcards).Today: copying, moving, and deleting files and folders, the commands I use most for cleaning up and organizing.All screenshots from my Windows 11 laptop. COPY – Copy Files COPY is…
Read MoreWindows Command Prompt basics
Windows Command Prompt basics: CD, DIR, and Wildcards (like the old green screen days). I grew up with massive CRT monitors and glowing green letters on black screens. Typing DIR and watching files scroll by felt like magic. Today, the Windows Command Prompt (CMD) looks different, black background, white text, but the core commands are…
Read MoreWindows 11 App Permissions
The insane list Microsoft hides (and how to lock it down) Windows 11 has a massive section called App permissions buried in Settings > Privacy & security. It controls what apps can access on your PC, camera, microphone, location, files, contacts, and many more. The list is long. Really long. And many of these permissions…
Read MoreMonitoring PostgreSQL activity
Monitoring PostgreSQL activity with pg_stat_activity.PostgreSQL is incredibly powerful, but like any database, it needs occasional monitoring to stay healthy. One of the simplest and most useful tools for this is the built-in view pg_stat_activity. What Is pg_stat_activity?It is a system view that shows real-time information about every current connection to your PostgreSQL server. Run this…
Read More