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
Enabling TDE is simple to do, but it can be more complex when you look to remove the feature from SQL Server. Steve Perry brings you a procedure you can use to help you.
2011-11-03
33,192 reads
2011-10-31 (first published: 2011-10-19)
2,269 reads
2011-07-22
2,041 reads
We're pretty confident that we have locked down and encrypted our financial data, but a lot of our customer's PII (Personally Identifiable Information) data is still held in unencrypted form. This data is able to be selected directly by read only business users on many of our downstream reporting, datawarehouse and standby servers. The rise of identity theft makes protecting this data imperative. DBAs are the custodians of this information and must protect it like we protect our own personal information. Recent publicity over the theft of Sony PSN data underscores both the economic and ethical importance of protecting personal data.
2011-07-14
2,864 reads
Arshad Ali examines the different types and different layers of security that SQL Server Service Broker provides during communication and while accessing Service Broker objects.
2011-07-04
1,810 reads
I'm trying to set up SQL Server and I know that I'm not supposed to use an account that's an administrator on the system, as per best practices. I see that the System account is a possibility, but I've been advised not to use it. Why not? Check out this tip to learn more.
2011-06-07
5,306 reads
2011-05-30
2,469 reads
Query Active Directory to get information on user logins.
2013-01-18 (first published: 2011-05-16)
3,864 reads
View login information for all accounts that use SQL authentication.
2011-05-12 (first published: 2011-05-09)
2,945 reads
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers