This project is a Streamlit-based web application that uses LangChain and Groq's Llama 3.1 model to generate SQL queries from natural language questions, run those queries on a connected SQL database, ...

Since I wrote about the Snowflake query tags generated by Power BI earlier this year, one important piece of functionality ...

SQL Query Explorer is a professional web application designed for business users to securely write, save, and execute SQL queries against a SQL Server database directly from their browser. The app ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, ...

Agoda started utilizing ChatGPT to optimize SQL stored procedures (SP) as part of their CI/CD process. After introducing the ...

A few days ago I was tagged on a thread on Twitter: my old pal Mim was upset to find that he couldn’t use a SQL query with a Common Table Expression as the source of a table in DirectQuery mode. He ...

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...