This post will explore industry-standard techniques to securely store passwords. Let us learn about Best Practices for Securely Storing Passwords.
SQL SERVER – Generating Secure Passwords
We’ll explore industry guidelines for complex passwords and implement them in an SQL Server stored procedure to generate secure passwords.
SQL SERVER – Login Experience with DEFAULT_DATABASE and MUST_CHANGE
DEFAULT_DATABASE and MUST_CHANGE shape the login experience. Tested on SQL Server 2025: the syntax that fails, and how the two lock a user out.
SQL SERVER – Ins and Outs of Online Index Operations
I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.
SQL SERVER 2022 – Oldest Compatibility Level Supported
What is the oldest compatibility level supported by SQL Server 2022? It goes back to SQL Server 2005, and here is why that backward compatibility matters.
Data Binning in T-SQL: Fixed Width, NTILE, CASE, DATE_BUCKET
Data binning turns a column of numbers into a few groups you can count and chart. This post runs four T-SQL methods on the same orders on SQL Server 2025: fixed width, NTILE, CASE ranges and DATE_BUCKET. It shows what each method tells you and one trap with BETWEEN.
Histogram Buckets in T-SQL: Counting Values per Range
Create histogram buckets in T-SQL with fixed widths or explicit ranges, retain empty buckets, and display scaled text bars.