The Bible series are a good overview of the platform. That being said, SQL Server 2016 changed how the platform works dramatically, so I don't know that I'd pay much...

You can add a columnstore index to a table with a rowstore index. It's just another index.

I've had to do this in the past for an app. Here's what I did:

• find out the data being written. dup this table structure in a small admin db...

I think the key words there are performance. If we've improved performance with an OVER(), then yes, we ought to refactor older code. If we've changed from an IF statement...

I get less concerned over the formatting of code. These days we have products like SQL Prompt and other tools that can reformat things as we need them. I do...

Indeed. Part of what I wanted to convey is that you need to look at the problem and decide if it's a nail or screw.

I think most people get using...

LA

This is something where the question itself is kind of nonsensical, like what is better eating a steak or watching a good TV show.  There might be some overlap...

I prefer to use Powershell, and Invoke-DbaQuery from within my Powershell scripts for things that require T-SQL. The source of all scripts is then in my Powershell library, instead...

Btreieve, wow, I remember that on Novell. Not a fan.

Great advice. Similar to what I've heard from other sources

Glad you liked it. I thought it was a good post on a topic that many of us spend minimal time thinking about.

And as you can see, I replied under the test account, which I logged into with an email that is different from the user name

FWIW, I wouldn't ever install SSMS 2014 or anything below the current SSMS v18, which works with all instances of SQL Server.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Be good to post the link you got for others.