The author of this article recommends that shrinking the log file is a solution to this issue - but the log file has grown because of transactional activity. Unless...

#3 in your recommendations is incorrect.  If your database is set to full or bulk-logged recovery models - you absolutely need to be running frequent transaction log backups.

If you...

Very true @CozzaroNero. Best to understand the database behaviour and plan for the optimal transaction log  size. Shrink is a quick fix if one gets into trouble.

Thanks for the article.

The photo on licensing caught my attention. The $209 for Standard - CAL. Is that per user? What would constitute a user?

Interesting analogy here. And quite on point. Thanks so much, Steve.

On microservices, some points of view are that traditional RDBMSes do not quite fit into the design pattern. That each...

• This reply was modified 2 years, 10 months ago by  Br. Kenneth Igiri.

I know a former colleague and Linux lover who will laugh me to scorn if he sees this article. 🙂

I must add for integrity sake that I noticed recently that Azure SQL could be way cheaper than Amazon RDS actually.

https://azure.microsoft.com/en-us/services/azure-sql/#features

A few things that might help

1. Remember you might still need Amazon SES when configuring Database Mail
2. Explore Amazon's Calculator to determine what you can save https://calculator.aws/#/

Thanks so much for the feedback and corrects. I have updated it. I'm sure it sill reflect once the changes are approved.

Absolutely profound. I think it also speaks to the difference between buying an asset and buying a liability as often talked about by Robert Kiyosaki. An asset produces generates revenue,...

It's great to see this article!  I'm going to sit this pie fight out though.  Two items I would toss in fwiw:

<li style="list-style-type: none;">

1. The return type of...

Good job!

There is one things that could probably be added to this.  An identity is incremented when an attempt to insert is performed.  Even if the insert fails, the identity...

Plan Guides. I have never used them either. Sounds intriguing.

Thanks Sir for the article.

Thanks for the article. 1 Trillion rows caught my attention. How would you compare and RDBMS row to a NoSQL row. Can I consider a NoSQL "row" as a single...

Inspired to see you never stop learning and teaching new technology, Steve.

When I first used SQL Server on Linux, I noticed SSMS on my machine didn't render the Linux directories...