HackerNoon

How to Query Data the Professional Way in SQL Server: A Performance-First Guide for Beginners

If you've just started writing SQL Server queries, there's a good chance you probably wrote a query, saw it return the right ...

The time I trusted AI with SQL aggregation and my boss pointed out the mistake

It all started with my usual monthly aggregation.I asked AI to write the SQL for aggregating sales by customer.I needed to aggregate sales by customer for my monthly report. As usual, I told ChatGPT, ...
HackerNoon

How MySQL Implicit Type Conversion Turned an Indexed Query Into a 7M-Row Scan

A missing quote made MySQL scan 7.2 million rows. Here's how EXPLAIN exposed the problem and what it taught us about safe ...
TechRepublic

SQL Server 2022: Here’s what you need to know

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

Breaking Through the Limits of Text-to-SQL: Building a Hallucination-Free 'Conversational Data Platform' with dbt MetricFlow and LLMs

"Every time I ask ChatGPT to pull internal data using SQL, it returns a different CAC (Customer Acquisition Cost)."If you are ...