Technical Article

UDF Random Password Generator

UDF Random Password GeneratorYou can not use the RAND function directly from a User Defined Function. So the UDF I wrote "fn_RandomPassword" uses the view "view_RandomPassword8" to get the random charaters.Having the random password generator is useful if you need to insert a large number of users into a table with random passwords assigned.For example […]

5 (2)

You rated this post out of 5. Change rating

2003-08-07

374 reads

Technical Article

Convert Interger to Binary String for Bit Masks

The three functions here can be used to store Bit Masks as Integers.These are functions to convert an integer into a binary string. This can be useful if you store Bit Masks in your database as integers.For example .. '00000000000011111001001001110011' to 1020531Each Bit could represent an ON or OFF value. One integer columncould be equivalent […]

5 (1)

You rated this post out of 5. Change rating

2003-03-21

3,887 reads

Blogs

March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios

By

If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...

SQL Saturday Atlanta BI Recap

By

https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...

Mistakes IT Shops Without a DBA Make

By

We get it. There’s no budget for a DBA on staff, or even a...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

SQL 2017 server keeps locking up

By karenhallard

I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...

Alternatiives to Junk Dimensions

By Lord Slaagh

Hello SSC, I am not sure if I posted this in the right spot,...

Visit the forum

Question of the Day

Partial Backups II

What is a partial backup for a read-write database?

See possible answers