This T-SQL script helps you monitor the size and status of all databases on your SQL Server instance, providing insights into space usage and performance.
2025-01-22 (first published: 2025-01-20)
18 reads
This procedure gets current table and index sizes of particular database and stores it to tables.
2025-01-07
52 reads
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.
2024-11-13 (first published: 2024-10-24)
345 reads
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.
2024-11-11 (first published: 2024-10-23)
597 reads
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, […]
2024-10-15
245 reads
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.
2024-07-29 (first published: 2024-07-11)
1,574 reads
The below code will send an email alert when someone is added to the SYSADMIN Role on your SQL Server
2024-07-26 (first published: 2024-07-16)
699 reads
2024-05-30 (first published: 2009-07-13)
327 reads
Connecting to AWS instances from Local Server using Python programming
2024-05-21 (first published: 2024-05-14)
7,677 reads
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 […]
2024-05-21
8,232 reads
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Hi, i have a requirement that involves visiting multiple folders in AD for active,...
I know this, but I do not remember it. I have scoured by saved...
At work we have quite a few databases that I'm frequently browsing. This is...
What are the restrictions for defaults on columns declared as sparse?
See possible answers