Hi, I’m Rayka!
This blog is where I share some of my ramblings about coding. Whether it’s problem-solving, tips, or insights from my journey as a developer, I hope you find something useful, or at least entertaining. Feel free to explore, and thanks for dropping by!
Recent blog posts
-
Why Your PowerShell Script Produces Mojibake (And How to Fix It)
If you’ve ever written a PowerShell script that produces a file containing non-ASCII characters, like an → (arrow), a ≈ (approximately equal), or characters from a non-English alphabet, you may have run into one of the more confusing encoding bugs in the Windows ecosystem. The bug shows up most often when the script was generated…
-
How Scammers Fake Emails: Understanding Email Spoofing & Sextortion Scams
When I recently received an email that appeared to come from my own email address, I was intrigued rather than alarmed. The email claimed that my devices had been hacked, that a hacker had full access to my data, and that they would expose me unless I paid a ransom. Of course, this was a…
-
Recursive CTEs: Handling Hierarchical Data with T-SQL
When dealing with hierarchical data, like organizational charts or directory structures, Recursive Common Table Expressions (CTEs) in SQL Server offer a powerful way to traverse these relationships efficiently. Let’s walk through a structured approach to mastering Recursive CTEs in T-SQL. We’ll cover use cases, break down performance tips, and test our solution to highlight the…