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-11-30
49 reads
Rayis Imayev
- Website: http://datanrg.blogspot.com/
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)
262 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)
382 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)
594 reads
Executing Azure Data Factory pipelines by Power App / Automate Flow
(2021-Jun-30) One of my university professors liked to tell us a quote, “The Sleep of Reason Produces Monsters”, in a way to help us, his students, to stay active in...
2021-07-14 (first published: 2021-06-30)
668 reads
New Azure Data Factory home page, what's in it for me?
(2021-July-07) Back in the late 90s when I was a college student intern at a local power supply company, I was invited to a social event of our IT department....
2021-07-07
88 reads
Azure Function Drain mode
(2021-Jun-16) Recently, Google started to notify me that my blog website (http://datanrg.blogspot.com/) had been experiencing some ‘Server (5xx)’ errors. Nothing has been changed on my side, and I’m not sure how...
2021-06-23 (first published: 2021-06-16)
435 reads
Blog post about Copying Azure files to SharePoint, comparing Logic App and Power Automate Flow for this, and Trust No One
(2021-May-31) Recently, I created a prototype solution for one of the projects, that would copy data files from Azure to SharePoint location. The task is trivial, doesn't require a lot...
2021-06-14 (first published: 2021-05-31)
184 reads
Creating a generic (template) pipeline in Azure Data Factory to send email messages with attached files from Azure Storage account
(2021-May-17) It took some time to come up with a final title for this blog post in my attempt to encapsulate its several major ideas: Azure Data Factory (ADF) pipeline,...
2021-05-26 (first published: 2021-05-17)
397 reads
Using Logic App to send multiple attachments from Azure Storage Account
(2021-Apr-23) Memory is an interesting thing, you may not remember all events from your past, but some sparking moments keep extending their bright beams of light. With the growing time...
2021-05-05 (first published: 2021-04-23)
209 reads
Blogs
Amazon RDS Custom for SQL Server – A new beginning
By AnupWarrier
Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was...
Getting Started with the Advent of Code as a #SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Your next step in the cloud
Over the last nine months I’ve presented (virtually) eleven times on a variety of...
Forums
Issue when joining 3 temp tables
Hey everyone, I have an issue joining 3 temp tables. I have such tables...
Row limit for Updates before transaction log fills up
Hello SSC, I hope everyone is staying safe and healthy. I am using SQL...
Changing the Excel Rendering format???
JHi I was wondering if anyone knew how I can change the Excel rendering...
Ask SSC