I don't know if this is the right place for this question or not but I'm hoping someone can point me in the right direction. I have a project in mind that requires a database and I would like to begin ...

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

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

We're generating a few reports for a client's existing MS Access database. In the "subscribers" table, which is the one I'm using for this report, they store all state/province data as foreign-key IDs ...

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

LibreOffice contains a very powerful database tool that is actually quite user friendly. Here’s how to create a database query using the Design View tool. We may ...

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

A step-by-step guide to using SAN-less failover clustering software to support SQL Server’s Always On Failover Clustering in the public cloud The thing about clouds is that they can change shape even ...