Insert Commas Into Number String
Function to take a number as a string and return it with commas separating thousands, millions, etc.
2013-06-07 (first published: 2009-03-31)
2,434 reads
Scripts
2013-06-06 (first published: 2009-03-16)
2,649 reads
What got restored from where, by who and when
Ever wondered what got restored, who did the restore and where the backup came from that did the restore?
2013-06-04 (first published: 2012-08-23)
2,033 reads
Get Rid of All Those Pesky 1 MB File Growth DB Files
Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.
2013-05-31 (first published: 2012-11-10)
1,464 reads
Search all stored procedures on all databases
Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.
2013-05-30 (first published: 2013-05-22)
1,751 reads
Find Blocked SQL and Blocked By Information.
This is a stored procedure which can be used to find which processes are been blocked by each other. This Procedure will also provide SQL information associated with the blocked SPID.
2013-05-23 (first published: 2009-06-15)
2,849 reads
To Check for Orphaned Users in a Database
This script is helpful to identify the orphaned users in a database, useful when we restore a database from a different location.
2013-05-22 (first published: 2008-07-20)
2,694 reads
SSIS Synchronize Remote FTP Directory
Get a distinct list of file names from a table into an ArrayList and compare against a remote FTP server. Retrieve only the files that have not already been processed into the database.
2013-05-17 (first published: 2008-09-11)
2,889 reads
Custom Maintenance Plans - the T-SQL way
The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.
2013-05-16 (first published: 2009-05-07)
4,397 reads
Generate a random password
If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.
2013-05-15 (first published: 2008-09-24)
3,366 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU BOGOR Tlp:08217555651
WA CS 628217555651 Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota...
Alamat Kantor BCA KCU Sukabumi Tlp:08217555651
WA CS 628217555651 Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat...
Alamat Kantor BCA KCU Karawang Tlp:08217555651
WA CS 628217555651 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang,...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers