Piyush Tripathi

Hi, I am Piyush Tripathi, a Software Engineer (San Francisco) and expert in micro service base API design and development. 

Technical Article

Extract parts of the strings from the SQL results directly by using SQL's substring-extraction API functions

If you need to extract a substring or create a longer string by combining multiple strings, there are a few methods you can use. To extract a specific portion of a string, you can utilize a substring-extraction function.

You rated this post out of 5. Change rating

2023-05-09 (first published: )

286 reads

Technical Article

Python 3 Script for Generating SQL Insert Statements from CSV Data

This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.

You rated this post out of 5. Change rating

2023-05-08 (first published: )

4,895 reads

Blogs

A New Word: Amoransia

By

amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...

The Data API Builder Start and Add Extensions in VS Code

By

One of the things that I like about the Data API Builder (DAB) is...

Using OneLake for Excel Files in Microsoft Fabric

By

Hey data friends! This blog is to discuss an edge case I’ve run into...

Read the latest Blogs

Forums

DbDefence - how does work this tool?

By Oleg-461731

How it is implemented?  I have installed, tried, it is free for dbs <=30...

Technical Pain Behaviors

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Technical Pain Behaviors

trying to call powershell from TSQL statement

By Siten0308

Hello, trying to call a powershell file I created, locally on the server, but...

Visit the forum

Question of the Day

Counting Bits

What does the BIT_COUNT function do in SQL Server?

See possible answers