In this article, I am going to discuss how to raise errors explicitly in SQL Server with examples along with we will also discuss the different options that we can ...

Once installed, the macro functions provided by the extension can be used just like built-in functions. DuckDB SQL is awesome and full of great functions. ClickHouse SQL is awesome and full of great ...

In SQL Server, I frequently need to combine IDs, names, or other values into a single, comma-separated string—whether for debugging, logging, or sharing data ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

There are a couple of nice new features to do with table joins (or merges as they are known in M) and query folding in Power Query in the April release of Power BI Desktop that I want to highlight.

Calculating percentages is a common task when dealing with data analysis. In SQL, the process of calculating percentage may differ based on the database management system being used. In this article, ...

Some good news for those of you using DirectQuery mode in Power BI: the ApproximateDistinctCount DAX function, which returns an estimate of the number of the distinct values in a column and which can ...

WHEN CHARINDEX('Memory Manager', object_name) > 0 THEN 'Memory Manager' WHEN CHARINDEX('Buffer Manager', object_name) > 0 THEN 'Buffer Manager' WHEN CHARINDEX('Plan ...