Database administrators often encounter scenarios where they need to terminate all user sessions or processes (SPIDs) in a specific database. This may be necessary during maintenance tasks, troubleshooting (dropping a database), or other critical database operations. In this blog post, […]
SQL Server Script: Estimating Database Backup and Restore Times
In this post, you will find a SQL script designed to provide estimated completion times and detailed process information for ongoing database backups and restores in SQL Server. Database backups can be time-consuming, influenced by various factors that affect completion […]
SQL Server Script: Show Database Growth Events
Explore this script designed to reveal database and log file growth events within a SQL Server instance. This resource proves invaluable for administrators overseeing SQL Servers that only come into focus during troubleshooting scenarios. Even without the luxury of proactivity, […]
SQL Server Script: Get Database Sizes and Free Space
Maintaining visibility of database file sizes and available space in SQL Server is essential for Database Administrators (DBAs) to effectively manage databases. Monitoring the availability of free space in both data and log files is crucial for ensuring the longevity […]
SQL Server Script: User Permissions Audit
As a Database Administrator (DBA), managing and auditing user permissions is a crucial aspect of ensuring the security and integrity of a SQL Server environment. Having a script to check a user’s permissions quickly is key to day-to-day support as […]