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: )

198 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: )

2,139 reads

Blogs

You should be running on SQL Server 2022

By

It’s me again with my apparently semi-annual blog post. This time we’re going to...

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Read the latest Blogs

Forums

"A Journey Through Unforgettable Destinations"

By VjGian15

Welcome to Trikago, your ultimate Travel, Travel Guide companion on a journey to explore the...

A Partial Count

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Partial Count

The Stagnant Career

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Stagnant Career

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers