How to Select Specific Columns in SQL?
When working with databases, you rarely need to retrieve every column from a table. Instead, you often select specific columns to get only the data...
D365FO Dual-Write Initial Sync: Error Handling
Recently I started building some app using Microsoft PowerApps and I noticed that I’m missing some D365FO tables in Dataverse. In this post, I will...
Limit Results on SQL Server: Using the SQL TOP Statement
When working with large datasets in Microsoft SQL Server, you don’t always need the entire result set. Sometimes, you only want a part of the...
Understanding the Software Integration Process: Custom Development, Add-Ons, and External Systems
As businesses grow and evolve, their software systems often need to adapt. This adaptation might include adding new features, improving functionality, or enabling new workflows...
Sorting Data in SQL: A Guide to the SQL ORDER BY Statement
When you need to organize query results in SQL, the SQL ORDER BY statement is the tool for the job. Whether you’re sorting products by...