CASE, ISNULL and COALESCE are all an integral part of SQL Server and follow its general syntax.  It's because IIF is so unlike other other functions and expressions in...

There are uses for IIF - just the same as CHOOSE and other shortcut features that...

Here is an alternative that doesn't require the use of CASE or IIF:

Declare @testTable Table (var1Title varchar(30), var1Topic varchar(30), var1Name varchar(30));
 Insert Into @testTable (var1Title, var1Topic, var1Name)
...

--===== Create and populate the test table
   DROP TABLE IF EXISTS #TestTable;
 CREATE TABLE #TestTable 
        (begin_time...

Look at using OUTPUT instead of a SELECT/INSERT method (https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-ver15)

If you keep this line 'SET TRANSACTION...

There is a schema change report - it might contain that information if the trace data is still available.  I would check there first - right-click on the database in...

If tempdb is growing every time you run this package - that indicates another process somewhere that is shrinking the files.  You should not be shrinking the files...reset the size...

If you remove a database from the AG - and then that database back before a new transaction log backup has been run, then SQL Server can synchronize that database...

I'm not a fan of PowerShell. I use it very infrequently, and as a...

What is the code in D:\MyFile.sql?

The 'Select' needs to select one of the available columns in $recordData - which will be defined by the query in D:\MyFile.sql.  If you query...

I think you really need to look at SYNONYMS and use them in your code/refactoring processes.  If you have been good about schema qualifying your objects - it would be...

To import xlsx files (in both 2015 and 2017), you need to install the ACE drivers. Ideally, you should install both the 32- and 64-bit versions. This link...

The reason your Powershell script didn't work as expected - is because you did not include the necessary items in the command:

$recordData = Invoke-SqlCommand -ServerInstance {your server...

If you reread what I wrote, you would see that I don't agree with creating a view for future proofing.

I stated that using a view for refactoring is acceptable and...