As a SQL Server DBA and blogger, creating a test database with data often needed for preparing tests and demos. You might also need this for testing a SQL Server feature or script before rolling out to Production. The SQL […]
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 Guide: How to a Rename SQL Server
When undertaking the task of changing the hostname for a SQL Server-enabled computer, it’s imperative to seamlessly update system metadata to avoid disruptions in remote connections and application functionalities. This post serves as a comprehensive guide on efficiently managing MS […]
SQL Server Script: Show Database Backup History
Explore this guide to retrieve crucial information on the last backup dates and times for all databases on your SQL Server instance. Database backups are pivotal for safeguarding your server’s integrity, especially when faced with potential data corruption or accidental […]
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, […]
Automating Service Restarts on Multiple Servers with PowerShell
In this tutorial, we’ll guide you through the process of automating service restarts on multiple servers using PowerShell. This efficient solution is ideal for system administrators looking to streamline maintenance processes or troubleshoot issues that necessitate restarting services across multiple […]