In my previous tutorial, we talked about SQL Server views, how they work, how to create them, and why they’re useful for simplifying complex queries....

If you’re working with Microsoft SQL Server, chances are you’ve come across the concept of views. A view is essentially a saved query that you...

While we are waiting for Microsoft to fix all the issues (and there are many) with license reports in Lifecycle Services (LCS), D365F&O itself, and...

When I first started working with SQL Server, one of the things that confused me was performance. Why do some queries return results almost instantly,...

In this post, I’ll show you how to truncate tables in Microsoft Fabric in three different ways: directly in the Lakehouse, in the Warehouse, and...