CHARINDEX SQL Server: T-SQL Function Reference, Syntax, and
CHARINDEX is a T-SQL function that returns the 1-based starting position of a substring within a string, enabling efficient string parsing and data extraction i
Welcome! I’m Thomas Heinrich, a software engineer and system administrator with a deep passion for the Command Line Interface (CLI). With years of experience navigating the terminal, building backend architectures, and automating server deployments, I created this space to share practical, real-world terminal knowledge.
Whether you are a beginner taking your first steps in a Linux environment or a seasoned DevOps engineer looking to optimize your deployment scripts, you will find actionable solutions here. My goal is to help you ditch the mouse, speed up your workflow, and harness the full power of the command line.
CHARINDEX is a T-SQL function that returns the 1-based starting position of a substring within a string, enabling efficient string parsing and data extraction i
Master tcpdump in Linux with this authoritative reference. Learn installation, packet capture, filters, output analysis, troubleshooting, and advanced options f
python shebang linux is a syntax convention (#!) placed at the very top of a Python script on Unix-like systems, defining which interpreter (e.g., /usr/bin/pyth
Learn to delete local commits in Git using reset, reflog, and force push. Keep or discard changes with --soft and --hard options. Safe recovery methods included
DHCP option 43 enables lightweight APs to discover WLC management IP addresses. This guide covers Cisco IOS, Microsoft DHCP, hex encoding, and troubleshooting.
Master Test-Connection in PowerShell: syntax, flags, real-world examples, exit codes, and troubleshooting for ICMP, TCP port, and traceroute connectivity testin
Master the Linux nc command (netcat) for port scanning, file transfers, and TCP/UDP debugging. Full syntax, options, examples, and troubleshooting.
Run batch files from Windows CMD using cmd /c or cmd /k. Learn syntax, flags, exit codes, troubleshooting, and cloud automation equivalents.
Master Bash string contains: wildcard, case, =~ regex, grep -q. Compare performance across all four methods. Practical examples, exit codes, and troubleshooting
Dst
Mounts source and destination as PSDrives with explicit credentials