Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...

Community driven content discussing all aspects of software development from DevOps to design patterns. Once you’ve installed SQLite, you’ll probably want to learn how to maneuver around the ...

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

The MySQL Workbench main window. How to create tables and add data to MySQL database with MySQL Workbench Your email has been sent The MySQL Workbench GUI is cross-platform, open source, and ...

How to create and populate a table in Microsoft Excel’s Power Query Your email has been sent Updating data in a Microsoft Excel workbook is common, but you will run into cases where you can replace ...