My post earlier this year on enabling query folding when using SQL queries as a data source in Power Query provoked a lot of interest. This post adds one more useful detail: how to preserve 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 blogged about ...

In this post, we will go step by step into several aspects of Change Data Capture, a feature that is available on the Azure SQL Managed Instance and Microsoft SQL Server. The focus will be on the ...

Sometimes we need to change the data type of a column in a table. We can do this by using Modify keyword with ALTER command. Syntax: To change the data type of a column in a table, use the following ...

change column data type. NB! mostly it means a full table re-write so be wary. ALTER TABLE staging_data ALTER COLUMN extra_info TYPE varchar(500); A significant performance tweaking option for tables ...

Learn how to use the xsd:type and sql ... Some data types require additional conversions. The following table lists the conversions that are used for various xsd:type values. id/idref/idrefs id-prefix ...