How Safe are Your Passwords?
How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords.
2002-12-10
7,393 reads
How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords.
2002-12-10
7,393 reads
This UDF and its equivalent stored procedure will return the size of a stored procedure, view, rule or user defined function in bytes .
2002-12-07
97 reads
This SP will decrypt Stored Procedures, Views or Triggers that were encrypted using "with encryption" There are 2 versions: one for SP's only and the other one for SP's, triggers and views version 1: INPUT: object name (stored procedure, view or trigger) version 2: INPUT: object name (stored procedure, view or trigger), object type('T'-trigger, 'P'-stored […]
2002-12-06
1,832 reads
This is a collection of 123 TSQL functions for professional, academic or learning purposes. There are many conversions hexadecimal/octal/binary/Roman numerals, mathematical functions such as hyperbolic, logic and trigonometric. Combinatorial functions such as combinations, permutations (factorial), arrangements. Other interesting functions include turning a number into plain English, Morse code, EBCDIC and vice-versa, Levenshtein Distance (linguistics), encryption, […]
2002-12-05
1,021 reads
Find SA Password (Brute Force) with Public RoleFindSApublic is a brute-force password cracker that requires only public role.Possibilities returns how many different passwords are possible with 1 up to c characters from a universe of n different characters.Usage:FindSApublic nN is an integer which is the maximum length of the password to attempt cracking.Acknowledgmentsoriginal idea: David […]
2002-12-04
957 reads
These are functions and stored procedures to convert numbers to words, in three languages: English, Portuguese and Spanish. There is also a function to convert text to speech.
2002-12-04
149 reads
Encrypt fields with these stored procedures and functions: TEA (new variant), TEA, RC4, Vigenere, Caesar, XOR, XOR8 for SQL Server This is a collection of stored procedures and encryption functions (UDF's) in TSQL.
2002-12-02
456 reads
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Comments posted to this topic are about the item Can You Ask for a...
Comments posted to this topic are about the item Stored Procedure Generation Script
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers