Script-Drop Orphan users from SQL Server Database
This script will help to find orphan users on all databases and will remove them.
2025-05-20
706 reads
Scripts
2025-05-06
1,196 reads
SQL Server Heath Check Script
This script runs a SQL server Health check for services, databases, Always On, replication, CDC job status.
2025-05-05
1,510 reads
fetch an execution plan from SQL Server's buffer cache
To fetch an execution plan from SQL Server's buffer cache (i.e., the in-memory cache of execution plans), you can query the dynamic management views (DMVs) that SQL Server exposes.
2025-04-30
374 reads
List the Databases To Which You Have Access
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
460 reads
Database mdf & ldf files size, used space, Free space in MB
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)
521 reads
T-SQL Script for Monitoring Database Size in SQL Server
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)
1,153 reads
Table Index Size
This procedure gets current table and index sizes of particular database and stores it to tables.
2025-01-07
391 reads
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.
2024-11-13 (first published: 2024-10-24)
785 reads
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.
2024-11-11 (first published: 2024-10-23)
1,910 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers