2006-11-28 (first published: 2006-10-11)
570 reads
Scripts
Remove Exec Permissions To Extended Stored Procs
I created this script to simplify the process of restricting access to high risk extended stored procedures. It will find any user or role which has execute permissions on any of the stored procedures in the "#High_Risk_Stored_Procs" temp table and will generate the relevant revoke statements to remove those permissions.The current list of stored procedures […]
2006-11-27 (first published: 2006-11-07)
688 reads
Kill Connections to Specific Database
Ever needed to drop all connections to a database? Here is an easy way to do it.
2006-11-24 (first published: 2006-11-08)
620 reads
Whose birthday next?
sort employee birthday by on coming order. If the person's birthday is yesterday, s/he should be in the bottom.
2006-11-23 (first published: 2004-12-29)
133 reads
Format Value To Currency
Create SQL Function To Format To Currency(for more scripts goto http://www.siccolo.com/articles.html)
2006-11-21
882 reads
Know the JOBNAME and JOBOWNER
As an administrator it is required sometimes to list out the job owners.This is a simple script that will allow to fetch this information. By applying a filter a specific job owner list can be fetched.
2006-11-21 (first published: 2006-01-30)
154 reads
(Dutch) Elfproef in T-SQL UDF
In The Netherlands we use bankaccountnumbers that need to comply to a test call 'elfproef'. This test evaluates the sum of each number multiplied by the position the number appears in the accountnumber. If the modulos of the sum divided by 11 is zero then the accountnumber is valid. The length of a bankaccountnumber in […]
2006-11-20 (first published: 2004-12-14)
640 reads
Remove multiple whitespace from a string: revise
This is a re-written function that the idea got from yesterday's script. This function used a recursive call to simplify the script.
2006-11-17 (first published: 2004-09-20)
244 reads
Last_Date_Of_Month
Get the Last date of the month for the given month and year In response to a post By: Anonymous - Posted: 2/16/2004 3:31:12 AM (Stored Procedure).... Thought that there should be a more efficient / functional way of doing this. And here it is. Of course, a function would probably be more efficient, and […]
2006-11-16 (first published: 2004-09-30)
143 reads
Merge Wizard
In our environment, we needed to create and drop replication over and over in our test environment and I got realy tired of having to manualy go to each table with an identity column to set its ranges. This sproc will create or drop the publications and/or subscriptions for all or some of the objects […]
2006-11-15 (first published: 2001-09-05)
781 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat BCA KCP Banjaran Adiwerna Telp +62 821-6277-387
Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...
Alamat BCA KCP Kemanggisan Telp +62 821-6277-387
Jl. Kemanggisan Utama Raya No.37, RT.7/RW.8, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus...
Inventory Snapshot for missing Period
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers