Metadata-driven pipelines in Azure Data Factory | Part 2
(2022-May-08) If you happened to read the Part 1 of this blog series, the main message of it was the Azure Data Factory Copy activity was not just a simple...
2022-05-09
16 reads
Rayis Imayev
- Website: http://datanrg.blogspot.com/
Metadata-driven pipelines in Azure Data Factory | Part 1
(2022-Mar-04) Looking in the Oxford dictionary, Metadata can be described as "information that describes other information in order to help you understand or use it", as well as Pipeline is "a series...
2022-03-23 (first published: 2022-03-04)
437 reads
Trusting the Fine Print or connecting Azure Data Factory with Salesforce
(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” - David Eldersveld on Twitter. That puzzled me, but only for a little while, since I...
2022-01-31 (first published: 2022-01-20)
152 reads
Fixing a giant or running a SQL Server project deployment with Temporal tables
(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a 50-foot tall alien robot, whom he eventually befriended, he didn't know about a very special...
2022-01-27
212 reads
Can I create a CI/CD pipeline to deploy Python Function to Azure Function App using Windows self-hosted Azure DevOps agent?
(2022-Jan-10) My short answer to this question is Yes and No. Yes, you can use Windows self-hosted Azure DevOps agent to deploy Python function to the Linux based Azure Function...
2022-01-26 (first published: 2022-01-10)
372 reads
“Could not find the modules: 'Az.Accounts' with Version: ''” error message and a story to remember
(2021-Dec-20) Part of the continuous integration and delivery for Azure Data Factory involves pre-deployment and post-deployment steps. Their main role is to stop triggers before deployment and restart them afterward,...
2021-12-27 (first published: 2021-12-20)
785 reads
Fail activity in Azure Data Factory and Why would I want to Fail
(2021-Nov-30) I heard a story about a young person who was asked why she was always cutting a small piece of meat and putting it aside before cooking a larger...
2021-12-10 (first published: 2021-11-30)
236 reads
Error [IM002] [Microsoft][ODBC Driver Manager] "Data source name not found and no default driver specified" and who do you trust?
(2021-Oct-31) A very short blog post, just a reminder to myself, but if you have ever tried to connect to a PostgreSQL database using ODBC interface (I know, it already...
2021-11-10 (first published: 2021-11-01)
2,074 reads
Lambda Architecture in data systems and possible meaning of this name
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists were asked to explain certain anomalies that were projected on a computer screen. One of...
2021-10-01 (first published: 2021-09-21)
399 reads
Data Modeling at your fingertips
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema is better than a database model communicated by a multitude of data scripting text objects.
Someone...
2021-08-16 (first published: 2021-07-31)
647 reads
Blogs
Daily Coping 17 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Storage Field Day 23 – HammerSpace
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Daily Coping 16 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
can i store hashbyte on field with length smaller than fields i concatenate it?
I work on sql server 2019 i have table have multi column string concatenation...
Migration of Data from one Database to Multiple Databases
Hello, I have a requirement to migrate the data from existing AWS RDS DB...
AWS Beginner questions
I'm having some trouble wrapping my head around the relationship between EC2 instances and...
Ask SSC