The stored procedure sp_alter_column is able to alter a column with dependencies in your SQL database - segovoni/sp_alter_column ...

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 ...

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.