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

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

5,259 reads

Blogs

Speaking at the NYC Lunch and Learn DevOps Devour Hour

By

This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

Read the latest Blogs

Forums

Deadlocks and Backups - Need help

By Mike-342950

Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...

Does Version Control Scare You

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Does Version Control Scare You

Unlimited Text

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Unlimited Text

Visit the forum

Question of the Day

Unlimited Text

If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?

See possible answers