Changing the column name is not a trivial operation especially if the column is referenced in Views, Stored Procedures etc. To execute the rename of a column, there is the sp_rename system Stored ...

To replicate setup an incremental model. Setup the your table to include a column like Varchar (50), alter the column to include varchar (5000) sql below Run your model, which will trigger the ...

It’s surprisingly easy to stop query folding happening in Power Query by changing the data type of a column. This is mentioned in the docs here, and it’s something several people have b… ...

Unlike the XML support in SQL Server, JSON support does not include a JSON data type -- you just store JSON objects in a character column (probably defined as VarChar (max)).