Scripts

Technical Article

Real-Time SQL Server to BigQuery Streaming ETL using CDC

CDC Changes: The script queries the CDC tables in SQL Server to retrieve the changes (inserts, updates, deletes) since the last sync. Each change is processed with a mapped operation type (INSERT, UPDATE, DELETE).
Real-Time Streaming to BigQuery: The captured changes are streamed directly to BigQuery using its real-time insert_rows_json method, avoiding the need for batch uploads via Google Cloud Storage.
Tracking Last Sync Time: The script tracks the last synchronization time and updates it after every successful sync, ensuring no data is missed.
Low Latency: By continuously querying the CDC tables and streaming the changes, the script achieves near real-time data synchronization.

5 (1)

You rated this post out of 5. Change rating

2024-11-13 (first published: )

505 reads

Technical Article

Concatenating Multiple Row Values into a Single Comma-Separated List

In scenarios where you need to consolidate multiple rows into a single, comma-separated value, you can achieve this using FOR XML PATH. This script demonstrates how to retrieve volunteer data and display the days they have selected for participation.

You rated this post out of 5. Change rating

2024-11-11 (first published: )

1,012 reads

Technical Article

While Loop in T-SQL

Often, we encounter situations where we need to loop through a dataset to process or update records iteratively. In such cases, I use WHILE loop like below. The example below demonstrates how a WHILE loop can be used to iterate Sales records. This approach is particularly effective when working with a numerical or date column, […]

3 (2)

You rated this post out of 5. Change rating

2024-10-15

441 reads

Technical Article

Comprehensive SQL Performance Monitoring and Optimisation Script

This script monitors and reports the execution statistics of SQL statements over a specified period, capturing metrics such as execution counts, CPU time, I/O operations, and elapsed time. It provides a comprehensive view of query performance, aiding in the diagnosis of performance issues and identifying problematic SQL queries in the database.

5 (1)

You rated this post out of 5. Change rating

2024-07-29 (first published: )

1,990 reads

Technical Article

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 […]

5 (1)

You rated this post out of 5. Change rating

2024-05-21

8,460 reads

Blogs

Speaking Engagements 2025

By

It’s been a minute since I’ve gotten out to speak at events, but the...

PASS Summit on Tour in New York City

By

The PASS Summit goes on tour this year, with an August stop in New...

SQL Server Errorlog: Not Just for Errors!

By

A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get...

Read the latest Blogs

Forums

Own Your Mistakes

By Grant Fritchey

Comments posted to this topic are about the item Own Your Mistakes

Automating SQL Server Inventory Collection with SQLInventory

By Deepam Ghosh

Comments posted to this topic are about the item Automating SQL Server Inventory Collection...

Independence Day

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers