Scripts

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: 2024-10-24)

494 reads

Discuss

Concatenating Multiple Row Values into a Single Comma-Separated List

by Sukhdevsinh Dhummad

SQLServerCentral

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: 2024-10-23)

964 reads

Discuss

While Loop in T-SQL

by Sukhdevsinh Dhummad

SQLServerCentral

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

431 reads

Discuss

Comprehensive SQL Performance Monitoring and Optimisation Script

by Jonathan Roberts

SQLServerCentral

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: 2024-07-11)

1,959 reads

Discuss

SQL Server Admin Role Alert Script

by Edward Pochinski

SQLServerCentral

The below code will send an email alert when someone is added to the SYSADMIN Role on your SQL Server

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2024-07-26 (first published: 2024-07-16)

868 reads

Discuss

Suspected Database

by Yousaf Khan

SQLServerCentral.com

Database Recovery

How Recover a suspecte database by rebuilding the log.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2024-05-30 (first published: 2009-07-13)

506 reads

Discuss

Connect to AWS S3 using Python script from Local

by Rohit Alladi

SQLServerCentral

Connecting to AWS instances from Local Server using Python programming

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (1)

You rated this post out of 5. Change rating

2024-05-21 (first published: 2024-05-14)

7,729 reads

Discuss

Creating a CSV Parser in Apex

by Rohit Alladi

SQLServerCentral

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