sp_whoindb
Modified the sp_who2 proc provided by Microsoft. This proc takes a dbname or dbid for input, and lists current processes in that database. If no database is provided, the current database is used.
2003-03-28
212 reads
Load Backup History from Backup File
This script creates a stored proc to verify all backups in a media set and load their history into MSDB. I use this frequently when I get backup files from clients and want to use Enterprise Manager's intelligent restore selection to quickly get the database restored on a test machine.
2003-03-11
333 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat Telp BCA KCP Soreang +62 838-4945-0961
Wa:083849450961 No. 1-A, Jl. Raya Soreang, Pamekaran, Kec. Soreang, Kabupaten Bandung, Jawa Barat 40912
Alamat Telp BCA KCP Indramayu +62 838-4945-0961
Wa:083849450961 Jl. Di Panjaitan No.69, Karanganyar, Kec. Indramayu, Kabupaten Indramayu, Jawa Barat 45212
Training the next generation
Comments posted to this topic are about the item Training the next generation
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers