Tag: SQL Server Database Files
-
Understanding Log Space Usage in SQL Server
In a SQL Server environment, monitoring database log space usage is crucial for maintaining database performance and ensuring…
-
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…
-
Moving Temp DB in SQL Server
A common best practice in SQL Server, is to have your Temp TB files stored on a separate…
-
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.…
-
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…
-
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…
Most Viewed
Blog Categories
- Other (7)
- PowerShell (29)
- SQL Server (62)
- WSL (11)