Free space today cannot tell you when the drive fills up. Save daily file sizes and let a short query turn the growth into a date.
SQL SERVER – What is Instance Hiding? How to do it?
In this blog post, I’ll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients.
SQL SERVER – Troubleshooting Common CSV Import Issues
Let us explore Troubleshooting Common CSV Import Issues. Importing data from CSV files into SQL Server is a common task.
SQL SERVER – Stored Procedures to Check for Pythagorean Triples
I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.
Masking Functions in SQL Server: What Each One Shows
Dynamic data masking hides values at query time, and the masking functions decide what a reader still sees. This post tests default, email, partial, random and datetime on SQL Server 2025 and shows what each one returns. It also covers adding and dropping a mask on an existing column.
Running Distinct Counts: Working Around COUNT(DISTINCT) OVER
Your report wants unique customers so far, and SQL Server refuses COUNT(DISTINCT) over a window. Flag each first appearance and add up the flags instead.
Schema-Level Permissions: Granting on a Schema, Not Each Object
Apply schema-level permissions to a database role, include future tables automatically, separate internal data, and review grants.