In a SQL Server environment, monitoring database log space usage is crucial for maintaining database performance and ensuring data integrity. Insufficient log space can lead to transactional failures, database downtime, and even data loss. In this blog post, we’ll share […]
Get Database FileNames and Paths in SQL Server
This post shares a SQL Script to retrieve filenames, paths and other information for all databases on a SQL Server instance. As well as this, I share SQL for parsing filenames from paths which may be useful to you for […]
Moving Temp DB in SQL Server
A common best practice in SQL Server, is to have your Temp TB files stored on a separate drive, especially ensuring it’s not on the C:\ drive, sharing with the Windows OS. This is because the SQL Server Temp database […]
Adding a Filegroup in SQL Server
In this post, we’ll demonstrate the process of adding a new filegroup to a database in SQL Server. While many databases function efficiently with a single data/log file, there are scenarios where adding a filegroup proves beneficial. Filegroups, as outlined […]
Create a Test Database in SQL Server
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: 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, […]