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.
SQL SERVER – Simple Method to Generate Fixed Digit OTP Code Using Random Function
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.
SQL SERVER – How to Generate Random Password? – Enhanced Version – Part 2
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.Â
SQL SERVER – How to Generate Random Password? – Enhanced Version
Earlier last month, I posted an interview question – How to Generate Random Passwords in SQL Server? – Interview Question of the Week #181. Though, my efforts were honest my answer was not complete in that blog post. Thankfully, SQL Server Expert Tim Cartwright noticed the error in the blog post and decided to send me to follow up email with the accurate script to generate a random password.
SQL SERVER – Transfer Logins Error: Msg 15021: Invalid Value Given for Parameter Password
One of my existing clients contacted me for assistance in fixing an error. Sometimes, if the error is easy and it doesn’t take more than 10-15 minute, I give them the benefit of being my existing customer and I give free consulting (not always though). They informed me that they need moving SQL logins (username and password) from one server to another. To achieve that they were using sp_help_revlogin. Here are the steps: