How to Do Mathematical Operations in SQL?
When working with Microsoft SQL Server, you’ll quickly find that it’s not just about storing and retrieving data. You also have to learn how to...
How to Import Excel into Fabric?
Recently, I had a situation where I needed to combine some data from an Excel file with the tables I already had inside a lakehouse....
How to Use Date Functions in SQL
In this post, I’ll show you how to use date functions in SQL with practical examples. When working with Microsoft SQL Server, you’ll often need...
How to Use String Functions in SQL?
When working with Microsoft SQL Server, you’ll often need to work with text, whether it’s combining names, cleaning up messy data, or pulling out one...
Power BI Error: Microsoft SQL: Integrated Security not supported.
In one of my previous blog posts, I created a Microsoft Fabric Data Warehouse. Now, when I want to connect to the same data warehouse,...