Category Archives: Editorial

Nested Transactions

Posted on March 6, 2023 by way0utwest

One of the very common expectations from many SQL developers involves transactions. Many developers (database or application developers) think they can open a transaction, do something, open an inner transaction (nested), and then commit or rollback the inner transaction separate … Continue reading →

Posted in Editorial | Tagged | Comments Off on Nested Transactions

The Top SQL Server Engine Errors

Posted on March 4, 2023 by way0utwest

For many of us, SQL Server just works. We might get some syntax errors if we mistype things, but for the most part, SQL Server runs smoothly in many environments. However, there are some common situations that do occur regularly, … Continue reading →

Posted in Editorial | Tagged , , | 1 Comment

Stale Data Causes Security Issues

Posted on March 1, 2023 by way0utwest

Security has become better and better in many organizations. At the same time, hackers and malicious actors are doing a better and better job of finding new ways to attack systems. Some work to target specific individuals, often because of … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Stale Data Causes Security Issues

Will ChatGPT Write Our Queries?

Posted on February 27, 2023 by way0utwest

The short answer is no. The longer answer is it depends, and perhaps to be more complete, ChatGPT likely will help us produce the simple, tedious queries with much less effort. There has been a lot of news about AI … Continue reading →

Posted in Editorial | Tagged | 1 Comment