A login with no database user is not automatically unused. Build the report, compare by SID, and check server roles before you touch anything.
SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server
A PowerShell way to get a list of fixed hard drives and free space on server: MVP Ravikanth’s short script with Get-WmiObject and Win32_LogicalDisk.
SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function
Readers found five ways to simulate LEAD() and LAG() without the SQL Server 2012 analytic functions. This post shows each solution with its author, runs all five on SQL Server 2025 and compares the rows with the real functions. Four return the same ten rows and one adds a rule of its own.
SQL SERVER – Introduction to PERCENTILE_DISC() – Analytic Functions Introduced in SQL Server 2012
An introduction to PERCENTILE_DISC, the SQL Server 2012 analytic function that returns an actual value from your data at a given percentile.
SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example
Win a print book: explain the value of PERCENTILE_CONT with a simple example, and learn this SQL Server 2012 function even on an earlier version.
SQL SERVER – Introduction to PERCENTILE_CONT() – Analytic Functions Introduced in SQL Server 2012
An introduction to PERCENTILE_CONT, the SQL Server 2012 analytic function that finds a percentile on a continuous distribution, much like a median.
SQL SERVER – Introduction to PERCENT_RANK() – Analytic Functions Introduced in SQL Server 2012
An introduction to PERCENT_RANK, a SQL Server 2012 analytic function that returns the relative standing of a value in a result set, shown next to RANK.