2009-11-17 (first published: 2009-11-06)
1,017 reads
Scripts
Search in your T-SQL objects
This procedure searches for your criteria not only in code, but also in objectnames
2009-11-16 (first published: 2009-10-20)
1,120 reads
View Errors in the Default Trace
Returns records with errors from the default trace ordered by most recent first
2009-11-12 (first published: 2009-10-29)
726 reads
Wait for Mirror treshold
This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.
2009-11-10 (first published: 2009-10-23)
516 reads
Using a function to parse/return the Nth field of a delimited column
A useful SQL function to parse a single string with delimited values for the "N"th occurrence
2009-11-06 (first published: 2009-10-15)
1,476 reads
Custom cleanup procedure for backup files
There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.
2009-11-05 (first published: 2009-10-09)
1,579 reads
Retrieve consecutive records from the table based the value difference
Retrieve consecutive records from the table based the value difference
2009-11-04 (first published: 2009-10-06)
970 reads
2009-11-03 (first published: 2009-10-06)
1,970 reads
Generating Rollback Proc with CDC
This will generate a rollback procedure for any table with CDC enabled for all columns
2009-11-02 (first published: 2009-10-08)
1,094 reads
Ultimate Alter Script generator
In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you.
2009-10-30 (first published: 2009-10-01)
1,389 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
BCA KCU BOGOR Telp/Wa 085111887254
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCU LUBUK LINGGAU Telp/Wa 082371291690
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Alamat Telp BCA KCP Sulawesi (+62) 838-4945-0961
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers