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 ...

How to Create a MySQL 8 Database User With Remote Access Your email has been sent At some point, you're going to need to connect to a MySQL 8 database remotely to manage your databases. Here's how to ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...

Four key considerations to keep in mind when you need a database designed for analytical queries of vast quantities of time series data. SQL often struggles when it comes to managing massive amounts ...