PinnedInTowards AIbyBiljana Jelić·Apr 24, 2025Vibe Coding: A Hobby Today, the Future of Development Tomorrow?Vibe coding has become my latest hobby, and I must admit, it’s pretty addictive — unlocking a whole new level of technical creativity for…A response icon4A response icon4
PinnedBiljana Jelić·Dec 9, 2024Power BI x Smartsheet: How to Build Dynamic Issue Tracking ReportsThe goal of this article is to inspire you to take your Smartsheet data and transform it into a dynamic, interactive report. Smartsheet is…
PinnedBiljana Jelić·Sep 13, 2022How to delete duplicate rows from a table using the ROW_NUMBER function in SQL?ROW_NUMBER()is one of the SQL’s most useful functions which can be leveraged for many advanced scenarios and use cases. Some of those…
InTowards Data EngineeringbyBiljana Jelić·Oct 30SQL reserved keywordsCan you use them as column names?A response icon1A response icon1
Biljana Jelić·Sep 30Trying to keep with AILast day of September, everyone is fully back, and summer is fading and becoming a memory. This was the first summer when I noticed that…
Biljana Jelić·Apr 27The Silent SQL Trap: LEFT JOIN WHERE vs ONLet’s talk about another SQL behaviour that looks harmless until it quietly changes your results. You write what feels like a simple query…
Biljana Jelić·Mar 183 small SQL tasks I let AI handleAI has become a great help in assisting us with all kinds of tasks, and programming is no exception. Writing queries, suggesting better…A response icon1A response icon1
Biljana Jelić·Feb 25The NOT IN + NULL Trap: Why Your SQL Query Returns No RowsContinuing in the same spirit as my previous article, “Silent SQL Bugs,” I wanted to keep the series going with another one from the same…
InLearning SQLbyBiljana Jelić·Jan 21The Silent SQL Bug : When An Invalid Column Name Doesn’t Throw an errorTL;DR: SQL Server may silently convert an invalid column in a subquery into a correlated reference, meaning your query runs without errors…