[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] The same subset of information that is used to define a table in CREATE TABLE. The table declaration includes column definitions, ...

Dedicated SQL pool (formerly SQL DW) supports the most commonly used data types. For a list of the supported data types, see [data types](/sql/t-sql/statements/create ...

Before you decide on the data types for your database tables, you need to understand where your data comes from, how it is generated, and how it is used. For example, if your data comes from a ...

Last week I was working on a Power BI custom data connector for a customer and I came across a problem that has been bothering me for a while. The “Invoke Custom Function” button is a very powerful ...

This became even easier in SQL Server 2005 with the advent of the XML data type and XQuery. You still need to construct and shred the XML data before you can use it; this is functional but not simple.

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

The SQLite CLI allows you to issue any valid SQL statements you like. To create SQLite database records, simply issue the appropriate SQL insert commands. Similarly, to list the records you simply ...

Like memory-optimized tables, SQL Server generates a DLL for each memory-optimized table type. As is the case for memory-optimized tables, the DLL includes the functions for access indexes and ...