This a script which creates stored procedures that can be executed adhoc or set as sql agent jobs to check the recovery status and generate full, differential or transaction log backupf for each database if the database recovery status is set to full. We have terabytes of data and set all production databases […]
2003-06-06
944 reads
I had recent request for a script to list all the views for a database along with the associated tables the columns depend on. It is a rather simple script but as I have not seen a similar one, I thought I would share it with my fellow dbas. It returns information about views specific […]
2003-01-23
465 reads
This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]
2001-08-27
3,132 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
BCA KCU MANGGA DUA RAYA Telpon/wa.085373737699.Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5,...
Telp/WA.0821°3111°179 Jl. Gunung Krakatau No.51 F-G, Glugur Darat II, Kec. Medan Tim., Kota Medan,...
Jl. Glugur Jl. Gatot Subroto No.11-12, Petisah Tengah, Kec. Medan Petisah, Kota Medan, Sumatera...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers