Connect to AWS S3 using Python script from Local
Connecting to AWS instances from Local Server using Python programming
2024-05-21 (first published: 2024-05-14)
5 reads
Scripts
Creating a CSV Parser in Apex
Salesforce supports the conversion of only csv files utilizing Apex. However if you use their LWC - js platform that provides wide options to bring in libraries to parse all kinds of file types. Here in this script i would be providing basic idea of functions utilizing the parsing logic along with options to iterate […]
2024-05-21
18 reads
Python script - detect DB of any AWS Service
Python programming script to detect database of any AWS services
2024-05-21 (first published: 2024-05-20)
5 reads
Python script to search through folders and files for a particular text in XML
Python Programming script to search through directories/folders and files for a particular text inside an XML tag
2024-05-21 (first published: 2024-05-14)
2 reads
Truncate tables where Referential Integrity exists
This script can be useful in test and dev environments to quickly clear tables via the truncate command where referential integrity exists.
2024-05-15 (first published: 2024-05-02)
407 reads
Running Mistral AI model on AWS Bedrock using Python
Mistral 7B is the first foundation model from Mistral AI, supporting English text generation tasks with natural coding capabilities.
2024-04-03 (first published: 2024-03-21)
239 reads
Node Script to call Salesforce from external system
Salesforce runs batch jobs in its server which takes resources and time and creates a burden on the overall server. Hence often times there is a need for a mechanism to call Salesforce system from external system. Calling salesforce from external system results in less burden on the salesforce server and faster processing. By leveraging […]
2024-03-21 (first published: 2024-03-19)
50 reads
Python script to dynamically query any database using bedrock generative ai
Any user who has a backend in AWS can leverage python to query the database and generate insights on the data by leveraging bedrock and langchain library
2024-03-21
277 reads
Python script to write SQL using Amazon Bedrock Generative AI
In this script we will leverage the capabilities of Amazon Bedrock's Generative AI service to author SQL statements.
2024-02-03
305 reads
Simple T-SQL implementation for running SSRS subscriptions.
I created this stored procedure to be able to run SSRS subscriptions using T-SQL code instead of adding a component in the SSIS package with the subscription id. Let's say we have a set of report subscriptions named like this: ClientReport1, ClientReport2, ClientReport3. To run them using the stored procedure, all we need is this […]
2023-11-29 (first published: 2023-11-21)
673 reads
Blogs
Planview Portfolios REST API with ADF – Retrieving Actual Data
In the introduction of this blog post series, I explained the use case: extracting...
Planview Portfolios REST API with ADF – Fetching the Access Token
In the introduction of this blog post series, I explained the use case: extracting...
Planview Portfolios REST API with ADF – The OData Feed
In the introduction, I explained the setup of the use case and why we...
Forums
How to set execution timeout in SSMS for SQL Server
I tried to set the execution timeout in SSMS for SQL Server 2017 using...
Implementing Change Data Capture
Comments posted to this topic are about the item Implementing Change Data Capture
What is new in Copilot, the new features available
Comments posted to this topic are about the item What is new in Copilot,...
Question of the Day
Implementing Change Data Capture
I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?
See possible answers