Tag Archives: sql server

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

The Growth of T-SQL

Posted on February 13, 2023 by way0utwest

I saw this tweet recently, where Richie Rump asked what has changed in T-SQL since the SQL Server 2012 version. A few people from Microsoft responded that there were changes in all versions, and while I think some versions have … Continue reading →

Posted in Editorial | Tagged , | 3 Comments

CPU Upgrades

Posted on December 21, 2022 by way0utwest

I expected this to be an article from Glenn Berry. He often tries to convince me to upgrade. I think so he can justify buying his own new hardware. In this case, however, this is a note from Tom’s Hardware … Continue reading →

Posted in Editorial | Tagged , | Comments Off on CPU Upgrades