Monitor Any Linked Server From SQL 2005
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005
2011-12-19 (first published: 2008-06-03)
3,314 reads
Scripts
2011-12-16 (first published: 2007-12-27)
4,093 reads
Check Instance Info
Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.
2011-12-15 (first published: 2007-10-11)
3,598 reads
2011-12-14
362 reads
Select from stored procedure
This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.
2011-12-14 (first published: 2008-03-04)
4,159 reads
SQL 2005 Restore Script Generator
This script will generate a restore statement with supporting MOVE operations to a new directory structure.
2011-12-13 (first published: 2008-05-29)
3,906 reads
Report SQL SERVER 2005 Permissions
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,969 reads
Clear database - delete all records from a database (updated)
The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').
2011-12-09 (first published: 2008-01-31)
4,197 reads
2011-12-08 (first published: 2011-11-23)
1,146 reads
Disk space alert per drive
This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.
2011-12-06 (first published: 2011-10-28)
4,064 reads
Blogs
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Forums
Alamat Kantor BCA KCU Daan Mogot Telp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan,...
Alamat Kantor BCA KCU Kuningan Telp:08218154374
Hub Via Wa:628218154374 Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Jl....
Alamat Kantor BCA KCU Puri Indah Telp:08218154374
Hub Via Wa:628218154374 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers