SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.
2011-11-25
4,497 reads
2011-11-24
32 reads
2011-11-24 (first published: 2010-03-24)
10,589 reads
This article will help to get some basic information from your databases that may help you in different situations.
2011-11-24
5,564 reads
SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.
2011-11-24
4,190 reads
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
2011-11-23
2,321 reads
We're looking to find out more about whether you monitor your databases, and how you do it. If you can spare a moment to complete a short survey, please click here.
2011-11-23
1,962 reads
Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article.
2011-11-22
4,273 reads
2011-11-22 (first published: 2010-03-17)
10,482 reads
There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.
2011-11-22
3,654 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Comments posted to this topic are about the item Writing as an Art and...
Comments posted to this topic are about the item String Similarity II
Comments posted to this topic are about the item Supervised versus Unsupervised Training of...
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers