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,408 reads
Joseph Gama
Get size in bytes of SP, View, Trigger, UDF or Rul
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
103 reads
Decrypt Stored Procedures, Views and Triggers
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,990 reads
123 TSQL functions
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,031 reads
Find SA password with public role-perm test DBA
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
961 reads
Text to Speech + Convert Numbers to Words in 4 languages
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
156 reads
TSQL Encryption TEA, RC4, Vigenere, Caesar, XOR
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
466 reads
Blogs
T-SQL Tuesday #193 - Notes to Self
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
Forums
What is the PRODUCT
Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers