PinnedPublished inTowards AIVibe 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…Apr 24A response icon4Apr 24A response icon4
PinnedPower 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…Dec 9, 2024Dec 9, 2024
PinnedHow 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…Sep 13, 2022Sep 13, 2022
Published inTowards Data EngineeringHow to Automate PDF Imports into SQL— A Step by Step GuideSep 17A response icon1Sep 17A response icon1
Published inGenerative AII Missed the World’s Largest Hackathon, but It Gave Me the Push I NeededA few days ago, The World’s Largest Hackathon organized by Bolt came to an end. A massive global event, the one where they were attempting…Jul 11A response icon2Jul 11A response icon2
Why 1 Beats * in Certain SQL Queries (And When to Use it)“1” might seem like just a simple number, but as we know in any programming language or the computing world, 1 plays a significant role…Feb 24A response icon1Feb 24A response icon1
Data Migration 101: Generate a SQL Script with Table Data in SQL ServerRecently, I found myself in a situation where I needed to migrate data from one table to another on different servers. The tables were…Nov 8, 2024Nov 8, 2024
EASY WAY TO CREATE A VIEW FROM THE TABLE IN SQLI came across a challenge that required creating a view from a very complex table with 30+ columns. The goal was to create a view almost…Jan 26, 2024Jan 26, 2024
SQL COLLATION ISSUESIf you’ve ever encountered the ‘Cannot resolve the collation conflict’ error message while working in SQL Server Management Studio (SSMS)…May 9, 2023A response icon1May 9, 2023A response icon1
SQL function we could use more often — ASCII () function with examplesASCII is an abbreviation for American Standard Code for Information Interchange, and to make things a bit more clear it is a character…Apr 8, 2021Apr 8, 2021
