Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2010-02-24 (first published: 2010-02-09)
1,213 reads
Scripts
See the compile time
Useful if you think a SQL statement, Function, or SPROC is taking too long to compile.
2010-02-23 (first published: 2010-02-04)
990 reads
Serial ID Auto Generation
Scripts used to create the functionality to auto-generate your very own customized serial IDs.
2010-02-22 (first published: 2010-02-04)
1,863 reads
Fix users for SQL 7 thru 2008
This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.
2010-02-19 (first published: 2010-02-04)
2,296 reads
2010-02-15 (first published: 2010-01-18)
24,252 reads
Database Users And Associated Database Roles
This script basically retreives all database users thier database roles for a database.
2010-02-10 (first published: 2010-01-20)
3,522 reads
2010-02-08 (first published: 2010-01-13)
4,181 reads
2010-02-05 (first published: 2010-01-18)
1,107 reads
Script Table or View structure
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,251 reads
Listing Subscribed SSRS Reports including Parameters & their Values
This script will allow user to analysis their Subscribed Reports.
2010-02-01 (first published: 2010-01-11)
2,323 reads
Blogs
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....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
Alamat Telp BCA KCP Pedurungan (+62) 838-4945-0961
Wa:083849450961 Jl. Brigjen Sudiarto No.294, Palebon, Kec. Pedurungan, Kota Semarang, Jawa Tengah 50273
Alamat Telp BCA KCP Mranggen (+62) 838-4945-0961
Wa:083849450961 Jl. Raya Bandungrejo No.102, Bandung, Bandungrejo, Kec. Mranggen, Kabupaten Demak, Jawa Tengah 59567
BCA KCU THAMRIN Telp/Wa 083809967178
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota Jakarta...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers