Howard

Ever wanted to know how to view available space in your database files? This script will give you the answer.

Uncomment out the last line to just view the log file.

SELECT * FROM users WHERE age > 30;

USE HDNet
GO

SELECT 
    @@Servername AS instance_name,
    sd.name AS db_name, 
    sd.recovery_model_desc AS recovery_model,
    sdf.physical_name AS filename,
    sdf.name AS logical_name,
    (FILEPROPERTY(sdf.name, 'IsPrimaryFile')) AS primary_file,
    (FILEPROPERTY(sdf.name, 'IsLogFile')) AS is_log_file,
    CONVERT(DECIMAL(10,2), size/128.0/1024)AS size_GB,
    CONVERT(DECIMAL(10,2), FILEPROPERTY(sdf.name, 'SpaceUsed')/128.0/1024) AS space_used,
    CONVERT(DECIMAL(10,2), size/128.0/1024-(FILEPROPERTY(sdf.name, 'SpaceUsed')/128.0/1024)) AS space_availabile,
    CONVERT(DECIMAL(10,2), (FILEPROPERTY(sdf.name, 'SpaceUsed')/(size/128.0))/128.0*100) AS pct_used,
    sd.log_reuse_wait_desc
FROM sys.database_files AS sdf
CROSS APPLY
(
    SELECT * FROM sys.databases AS sdf
    WHERE name = DB_NAME()
) AS sd








--WHERE (FILEPROPERTY(sdf.name, 'IsLogFile')) = 1

space here

SELECT * FROM users WHERE age > 30;

USE HDNet
GO

SELECT 
    @@Servername AS instance_name,
    sd.name AS db_name, 
    sd.recovery_model_desc AS recovery_model,
    sdf.physical_name AS filename,
    sdf.name AS logical_name,
    (FILEPROPERTY(sdf.name, 'IsPrimaryFile')) AS primary_file,
    (FILEPROPERTY(sdf.name, 'IsLogFile')) AS is_log_file,
    CONVERT(DECIMAL(10,2), size/128.0/1024)AS size_GB,
    CONVERT(DECIMAL(10,2), FILEPROPERTY(sdf.name, 'SpaceUsed')/128.0/1024) AS space_used,
    CONVERT(DECIMAL(10,2), size/128.0/1024-(FILEPROPERTY(sdf.name, 'SpaceUsed')/128.0/1024)) AS space_availabile,
    CONVERT(DECIMAL(10,2), (FILEPROPERTY(sdf.name, 'SpaceUsed')/(size/128.0))/128.0*100) AS pct_used,
    sd.log_reuse_wait_desc
FROM sys.database_files AS sdf
CROSS APPLY
(
    SELECT * FROM sys.databases AS sdf
    WHERE name = DB_NAME()
) AS sd










--WHERE (FILEPROPERTY(sdf.name, 'IsLogFile')) = 1

Introduction

I previously managed a blog hosted on a WordPress installation running on Amazon Lightsail. While the setup worked well, maintaining WordPress required significant effort—keeping it updated, securing the installation, and managing comments. Looking for a more efficient and low-cost solution, I began exploring static site generators like Jekyll and Hugo, alongside free or inexpensive hosting options.

I chose Cloudflare Pages as my hosting platform because it allowed me to deploy directly from a private GitHub repository—something not all free hosting solutions support. I was already using Cloudflare for DNS management, so keeping everything within the same ecosystem made sense. As for the static site generator, I opted for Hugo largely out of personal preference. It’s fast, easy to set up, and doesn’t require the Ruby toolchain that Jekyll depends on..