Last month we looked at the upcoming MS SQL Server 2005 Beta 2. In this version, the programmability of SQL Server is not anymore restricted only to SQL statements. You can now create solutions in ...

My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure SQL DB and Synapse) ...

Output from the “STRING_SPLIT” built-in function 2. To Split the String, Create a User-Defined Table-Valued Function. When functions like STRING_SPLIT can’t handle complex separators or keep the order ...