(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)
538 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)
893 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,706 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)
540 reads
(2022-Aug-28) Going on a family vacation road trip always fills me with a myriad of happy emotions and expectations to explore new places, see new people and essentially be led...
2022-09-07 (first published: 2022-08-29)
173 reads
(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets, building your data model and enriching it with interactive and engaging visualizations. Now you are...
2022-08-22 (first published: 2022-08-08)
1,477 reads
(2022-July-25) I really liked reading printed PC Magazines (https://www.pcmag.com/) or Computerworld newspapers (https://www.computerworld.com/) when I was in school. Those magazines pictured IT System or Database Admins as a special group...
2022-08-01 (first published: 2022-07-25)
2,995 reads
(2022-Jun-20) As it takes a village to raise a child, it also takes a team to develop a good SQL Server database project. Previous efforts to maintain manual or custom SQL...
2022-07-13 (first published: 2022-06-20)
1,161 reads
(2022-Jun-06) This blog post is a collaborative effort of several people, some of them I currently work with, and others' contributions came from their writing, so it’s more than natural...
2022-06-22 (first published: 2022-06-07)
538 reads
(2022-May-31)
Personal notes of one of the recent ADF JSON pipeline development to remember how to use it next time.
Requirements:
Sourcing data comes from a SQL Server database
The destination is a...
2022-06-15 (first published: 2022-05-31)
677 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Comments posted to this topic are about the item The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers