(2025-Feb-12) I will jump straight to the problem statement without a "boring" introduction, which, in a sense, already feels like an opening statement.Moving data between two or more endpoints is...
2025-02-24 (first published: 2025-02-12)
274 reads
“Alice: Would you tell me, please, which way I ought to go from here?The Cheshire Cat: That depends a good deal on where you want to get to.”— Lewis...
2025-01-24 (first published: 2025-01-13)
330 reads
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly moves forward, with schools starting and kids returning to their routines, the memories of the...
2024-09-27 (first published: 2024-09-13)
142 reads
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks for more than half of my life. I believe it's the most widely used spreadsheet...
2024-03-25 (first published: 2024-03-16)
236 reads
(2024-Mar-08) Software installation typically involves several steps. After accepting the license agreement, you may have an express option to streamline the installation process by accepting all defaults, including the installation...
2024-03-13 (first published: 2024-03-08)
563 reads
(2023-Oct-15) When something important disappears, it's natural to start asking questions and looking for answers, especially when that missing piece has had a significant impact on your life.Similarly, when data...
2023-10-25 (first published: 2023-10-16)
284 reads
(2023-July-15) Let's say you have a collection of Power BI .pbix files stored in a git-based source control system (GitHub, Azure DevOps, or any other system). Among these files, one...
2023-08-07 (first published: 2023-07-15)
532 reads
(2023-Apr-25) It’s not hard to see that many different teams were involved in building Azure Data Factory (ADF) product at Microsoft. It doesn’t have conformed constraints for naming the objects...
2023-05-03 (first published: 2023-04-25)
804 reads
(2023-Apr-10) Yes, Azure Data Factory (ADF) can be used to access and process REST API datasets by retrieving data from web-based applications.To use ADF for this purpose, you can simply...
2023-04-19 (first published: 2023-04-10)
8,363 reads
(2023-Feb-20) The previous posts covered the following areas of Metadata-driven pipelines in Azure Data Factory:Part 1 - Data CopyPart 2 - Feed ConfigurationPart 3 - Column MetadataThese 3 areas suggested that it is...
2023-03-01 (first published: 2023-02-20)
501 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
Hi I have below query and i want Cummulative Total . Total should be...
Everyone seems to be a Newbie with zero points today! Browser = Chrome
We've got upwards of 40 SSIS solutions all stored in one GIT repository in...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers