This post was sponsored by Trendos. The opinions expressed in this article are the sponsor’s own. Are my competitors running ChatGPT ads? Is there an ad library for ChatGPT sponsored results? How do I ...

The “Conversion failed when converting date and/or time from character string” error in SQL Server appears when SQL Server cannot interpret a text value as a ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

SQL-Mongo Converter is a lightweight Python library for converting SQL queries into MongoDB query dictionaries and converting MongoDB query dictionaries into SQL statements. It is designed for ...

Recently, I faced a challenge at work where a SMALLINT column in our database was no longer sufficient due to increasing data. To ensure scalability, we needed to convert it to INT. Since this process ...

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

Databricks Lakehouse Platform combines cost-effective data storage with machine learning and data analytics, and it's available on AWS, Azure, and GCP. Could it be an affordable alternative for your ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...

When you build a Power Apps canvas app there are many different data sources you can choose to use such as SharePoint, Microsoft Dataverse, SQL (on-premises), Azure SQL (online), Excel, and others ...

In this article, I'll guide you on how to convert ROW data into COLUMN data. I'll demonstrate how it is done in Oracle and SQL-Server using PIVOT functions. In OLTP system, the Sales Data will be ...