Powershell script to generate SQL server Inventory in CSV format
This script is used to generate the output file as CSV format for list of server.
2025-11-03 (first published: 2025-10-20)
536 reads
Srinivas Merugu
- Skills: SQL DBA, PostgreSQL,Azure
AlwaysON health check alerts
The script gets the database health check whether synchronized or not from the primary or secondary. This code needs to scheduled through as a job to get alerts.
2025-10-20 (first published: 2025-10-13)
421 reads
Bat and SQL script to generate DB user permissions for all Databases in SQL server
Get a list of all user permissions in a database
2025-10-15 (first published: 2025-10-13)
1,812 reads
Cleanup backup file folder future 7 days
Two PowerShell scripts to create backup folders and clean up old files.
2025-08-29 (first published: 2025-08-16)
272 reads
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
346 reads
2025-05-06
682 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
785 reads
Blogs
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Forums
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The Challenge of AI
Comments posted to this topic are about the item The Challenge of AI, which...
Deprecated Feature Tracking
Comments posted to this topic are about the item Deprecated Feature Tracking
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers