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,917 reads

Blogs

Speaking at SQL Saturday Austin 2025

By

SQL Saturday Austin 2025 is in just a few days. I am honored to...

Updating SSMS is Easy (w/ v21)

By

I’ve been using the SSMS preview for v21. This is the next evolution of...

Execute Fabric Data Pipeline from Azure Data Factory

By

In the blog post Call a Fabric REST API from Azure Data Factory I...

Read the latest Blogs

Forums

importing from PowerQuery... but with multiple powerqueries

By pietlinden

I finally got the PowerQuery source to "show" in SSIS (so I can see...

Third party backup softwares

By ashrukpm

Hi Team, Can you someone suggest a few good third part backup tools, with...

2022 SSIS PackageFormatVersion?

By TG

Recently I upgraded my ssis package from 2016 to 2022, but package format version...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers