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

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

Like other ‘easy steps’ books, this is a short book that makes use of bright colours, short chapters, and lots of step-by-step instructions with the aim of providing a simple, straightforward ...

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

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

When you interview for a SQL database administrator job, the interviewer will likely ask a number of questions related to optimizing SQL databases. Be prepared to discuss the different factors that ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...

Regardless of the size of your organization, there's always a wide variety of items to keep track of in database systems like SQL Server -- user logins, data access, security protections and more.

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...

This is third in a series of articles covering eConnect for Microsoft Dynamics GP. Part 1 explained that the business logic for eConnect exists in stored procedures within the Dynamics GP company ...