2002-12-05
221 reads
Scripts
zPad() - add leading zeros to a number
This user-defined function converts a number to character format and adds leading zeroes to pad the field to a specified length. useful for displaying SSNs or other numeric fields where the leading 0's are significant but the field is stored as numeric.To use:select dbo.zPad(, )make sure your length includes an extra column for the sign. […]
2002-12-05
425 reads
Convert a number to words
This is a handy function that converts a number (integer) into its word format. This might be handy if you need to print a check formatted number in words. Currently it supports an integer but it would be almost nothing to convert to support a bigint or decimal.The components are1) a table named PlaceValue that […]
2002-12-04
365 reads
Create an OLAP Main DateTime table
The Microsoft FoodMart example uses a table of pre-calculated dates and times to join to a main Fact table.Here is a quick script to create such a table with dates from Jan1 2002 to end of December 2019.HTH - BillyWilly
2002-12-04
680 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
962 reads
PACK() user defined function
Convert a decimal number to IBM EBCDIC packed decimal format. If for some reason you need to export a number to IBM systems in native format, you can define a SQL Server field as binary(8) and Pack() your decimal number into it. Then IBM mainframes and COBOL/CICS systems can read the numbers from your data […]
2002-12-04
545 reads
Script to determine backup finish times
SQL Server provides the RESTORE HEADERONLY command which helps users determine backup completion times. What if you have the need to use this completion time for comparison, perhaps to set up a job that only restores the file if it is xx hours old. This script can be used to determine the maximum backup finish […]
2002-12-04
416 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
159 reads
Dependencies on a specific table column
SQL Server provides a built-in stored procedure, sp_depends, that returns object dependencies. Recently, I discovered a need for determining dependencies on a table column, not just the table itself. For example, a table may be referenced by many stored procedures and views, but a specific column in that table may only be referenced in a […]
2002-12-03
3,344 reads
Setting permissions (fix for no dbo users)
fix script from tcartwright@thesystemshop.com (http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=600) for no dbo users
2002-12-02
157 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers