SQLGear

Often we are given task of creating new login. And when you are creating a login you are supposed to give a strong password as per the company policy. Few characteristic of a strong password are: it contains special characters and numbers. it contains a mix of upper and lower case letters. it has a minimum length of 10 characters. it cannot be guessed easily based on user information (birthdate, postal code, phone number etc.) Credits awyu322 If you give a password which is strong but you are using it every time while creating the login then it is known across the floor that if a new hire comes his first password is same as the one which you might have got. But every time one cannot think of something which is not easy to be guessed and meaningless. I have a small stored procedure which might help to generate a random word with caps and small letter and includes number as well and you can use them as password. You can pass the length of the password as the parameter, if you...

Searching in the haystack. Creadits Perry McKenna I recently had to do a work which was easy but required to be done faster. I had to find all the occurrences of a particular text string which could have been stored  any column of any table in any user databases of all the servers. I already had a script which would create a stored procedure named "SearchAllTables". You can create this stored procedure in any database you want and call it from the database you want to search in that instance. Say if you have created this stored procedure in master database and want to search in database named "model" you have to execute following after creating the stored procedure: USE model; GO EXEC master.dbo.SearchAllTables 'TextToSearch'; GO But here as I said we had to search all the user databases of every SQL Server instance. So I modified the create store procedure script in such a way that you have to execute is just once on a SQL server instance OR you can...