Joseph Gama

Technical Article

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 […]

1 (2)

You rated this post out of 5. Change rating


1,415 reads

Technical Article

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, […]

You rated this post out of 5. Change rating


983 reads

Technical Article

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 […]

You rated this post out of 5. Change rating


953 reads


Executing One Line in VSCode–#SQLNewBlogger


I wrote about arrays in PowerShell last week, but I realized one of the...

Friday Flyway Tips–Comparison Options


Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights


giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Read the latest Blogs


Lake Database Performance Optimization

By kobinarashid

I recently created a synapse link for Dataverse. The resultant Lake Database in Synapse...

Selecting from a view, base table has a DENY on a column

By pveilleux

This is something I've never seen before and I can't think of the right...

JSON data with Pivoted

By Tava

Hi All, I need some assistance and not sure how to achieve the expected...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers