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 – Generating Complex Passwords with T-SQL
The client needed a robust method for generating complex passwords directly within their SQL Server database. Let us see today.
SQL SERVER – Setting up a Robust Password Policy
Today’s topic of Setting up a Password Policy often emerges during my Comprehensive Database Performance Health Check consultations.
SQL SERVER – Unlocking User Without Changing Password
If know the answer, I like to answer them. Today we are going to discuss Unlocking User Without Changing Password. Let us learn.
CHECK_POLICY and CHECK_EXPIRATION for SQL Logins
Audit CHECK_POLICY and password expiration for SQL logins, inspect LOGINPROPERTY evidence, and plan safe service-account exceptions.
SQL SERVER – Simple Method to Generate Fixed Digit OTP Code Using Random Function
A reader wanted a six digit OTP for app sign-ups. Here is a simple way to generate a fixed digit OTP code in SQL Server with the RAND() random function.