Perfection is a goal and it can be very far away. Incremental shorter goals can be used to get to "perfection" in more manageable chunks.

I have seen software that was...

On 20August the 2020 list became available... SQL Injection is still #6 (https://cwe.mitre.org/top25/archive/2020/2020_cwe_top25.html).

Pinal Dave found it was not very efficient... as always... it depends... test in your environment to be sure it works like you want...

https://blog.sqlauthority.com/2019/12/11/sql-server-approx_count_distinct-not-always-efficient/

Along with the other suggestions, sometimes putting the logic in a .bat or .cmd and calling that file in the job step will help.

Specifying servername requires uppercase S "-S", specifying separator is lowercase s "-s". -i is for a sql file, usually used instead of -Q or -q.

Ola has me covered...  (@Databases = 'USER_DATABASES', @ChangeBackupType = 'Y' ) is one of my favorite features of his scripts... even if I am making DIFFerentials, it will make a...

Have you tried using msdb.dbo.agent_datetime?

SQL Server installs are already a 5-10 minute process...using a ConfigurationFile.ini makes it very easy to apply a standardized template to multiple instances.

You could import each line into a single row/record. Then you could parse the single row into the multiple columns you want to use/keep... using SUBSTRING() and the offset you...

If your index changes are not put into a script and attached to a change request, how can you put a database back to the same state if you later...

If you don't want to enable xp_cmdshell, you can put the WMIC command in a job step that can capture the output to a file that you can bulk insert...

You can use the lowercase s option from the command-line (-s",") or the SQLCMDCOLSEP variable (set SQLCMDCOLSEP=,)

You need to be careful how you specify options in .BAT/.CMD because comma can...

Last I heard, Azure does not support extended properties. So this may only be an on-premises solution.