May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Best Practices for Securely Storing Passwords

October 20, 2023
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Server Security

This post will explore industry-standard techniques to securely store passwords. Let us learn about Best Practices for Securely Storing Passwords.

Read More
secure passwords

SQL SERVER – Generating Secure Passwords

October 19, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Password, SQL Server Security

We’ll explore industry guidelines for complex passwords and implement them in an SQL Server stored procedure to generate secure passwords.

Read More
complex password

SQL SERVER – Generating Complex Passwords with T-SQL

July 18, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Password

The client needed a robust method for generating complex passwords directly within their SQL Server database. Let us see today.

Read More
password policy

SQL SERVER – Setting up a Robust Password Policy

July 17, 2023
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Server Configuration, SQL Server Security

Today’s topic of Setting up a Password Policy often emerges during my Comprehensive Database Performance Health Check consultations.

Read More
Changing Password

SQL SERVER – Unlocking User Without Changing Password

June 9, 2021
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Scripts, SQL Server, SQL Server Security

If know the answer, I like to answer them. Today we are going to discuss Unlocking User Without Changing Password. Let us learn.

Read More

SQL SERVER – Simple Method to Generate Fixed Digit OTP Code Using Random Function

August 22, 2018
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Random, SQL Scripts, SQL Server

One of my blog readers sent me the following mail after reading my earlier blog posts about Random Function and OTP Code. Before you read the email, you can read those blog posts here, here, and here.

Read More

SQL SERVER – How to Generate Random Password? – Enhanced Version – Part 2

August 15, 2018
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Password, SQL Random, SQL Scripts, SQL Server, SQL Server Security

I have previously written about Random Password before in the blog posts here, here and here. This blog is sent by James Curran, who has created the following generate random password stored procedure keeping the base of the original solution of Tim Cartwright. Thanks to both of this individual SQL Server Expert who has helped me to come up with a more robust solution for a random password. 

Read More
1 2 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version