Explanation: sys.databases contains information about all databases on the SQL Server instance. • HAS_DBACCESS(name) = 1 filters out the databases you dont have access to. •ORDER BY name sorts the result alphabetically.
2025-03-04
67 reads
This script will help to get the Database mdf & ldf files size, used space, Free space in MB.
2025-02-27 (first published: 2025-02-25)
65 reads
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-29 (first published: 2025-01-20)
571 reads
This procedure gets current table and index sizes of particular database and stores it to tables.
2025-01-07
156 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)
418 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)
752 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
348 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,816 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)
791 reads
2024-05-30 (first published: 2009-07-13)
391 reads
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Hi I have a task in my SSIS package that moves files from source...
We are migrating our environments to Azure, it will be a mix of SQL...
Comments posted to this topic are about the item The Inefficiencies of Kubernetes
How do I calculate the amount of space needed for I/O buffers during a backup operation?
See possible answers