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
486 reads
If you ever need to create a credit card like number this stored procedure is for you.Most credit cards contain a check digit, which is the digit at the end of the credit card number. To generate the check digit, the LUHN formula is applied to the number. To validate the credit-card number, the check […]
2002-11-30
4,327 reads
This stored procedure is another monitoring utility that can be executed periodically as a sql server agent job. The procedure checks if there are any open connections, and if there was any recent user activity within a given period of time in a given (or any) database by a given (or any/any except given) login […]
2002-11-30
1,303 reads
This script will remove old versions of DTS packages. It accepts a single parameter which is used as a filter criteria on the package name. It will also remove package log records for the version that is deleted.EXAMPLE: EXEC usp_DelOldDTSPkgVersions @vcrPkgName = 'Devel'This will delete old versions for packages that have 'Devel' in the nameQuestions […]
2002-11-30
1,174 reads
Sometime one needs to perform an operation on all or selected databases on a server/instance. Microsoft provides undocumented store proc sp_MSForEachDb to achieve this. I use it for some clean up process as a SQL Job.
2002-11-30
461 reads
This Procedure is what I use to clean out all the old DTS package version on my server periodically. You just place it in the msdb database and run it as you need to.Note: Although I have never had an issue with it, I do suggest backup msdb database beforehand, just in case you wack […]
2002-11-30
326 reads
A procedure too re-attach a data( MDF ) file when the log file is missing or not recoverable.
2002-11-22
4,862 reads
Here is a script I wrote to automate updating of permission on a database. Often running as sa I forget to set the rights for objects when distributing db objects. It provides the capability to process only certain object types, and whether or not to print and execute the persmissions change or just print out […]
2002-11-22
455 reads
Useful in dev environments when you need to periodically assign execute permissions on all procs in a db (drop/create scripts may have been run without re-assigning permissions)Accepts DB name, ProcLike for matching 'starts with' pattern against proc names in DB, revoke (optional - defaults to 0/True) specifies wheter to GRANT or REVOKE permissions
2002-11-21
402 reads
The following script creates a monitoring utility to find out for how long a sql server was down prior to the latest startup. The script creates one table (tblHeartbeat), four stored procedures (uspFillHeartBeat, uspGetDowntimeSummary, uspCleanHeartbeat, uspAtStartup) and two jobs (FillHeartbeat and CleanHeartbeat).Notes:1. By convention I introduced in my company (UGO Networks, Inc.) all "service" database […]
2002-11-21
852 reads
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
WA:08218154393 Jl. Burangrang No.44, Burangrang, Kec. Lengkong, Kota Bandung, Jawa Barat 40262
WA:08218154393 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
Comments posted to this topic are about the item The SQL Server 2016 Plan
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers