2024-05-30 (first published: 2009-07-13)
37 reads
Scripts
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)
30 reads
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
27 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)
15 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)
19 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)
451 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)
283 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)
55 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
384 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
350 reads
Blogs
Async stats update causing blocking
By Zikato
I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...
Level Up Your SQL Skills: The Best Intermediate to Advanced Courses
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...
Query deadlock info in Azure SQL DB
A couple of weeks ago, a developer came to me and wanted to know...
Forums
SQL SSRS license info
hello, i am trying to find where SSRS edition and product key information...
Baseball Everywhere
Comments posted to this topic are about the item Baseball Everywhere
How to run custom python module on SQL Server?
I am working on a small test script on SQL server 2022 using python...
Question of the Day
Sensitivity Ranks
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
dbo.sales.discount
WITH (
LABEL = 'Highly Confidential',
INFORMATION_TYPE = 'Financial',
RANK = 'INTERNAL ONLY'
); See possible answers