Select the last error in the job selected
The job will send an HTML email with the latest error at specific job.
2012-03-15 (first published: 2012-03-05)
953 reads
Scripts
Fix SSRS Subscription Owners
Stored procedure to update SSRS Subscription owners to avoid email errors.
2012-03-13 (first published: 2012-02-28)
1,496 reads
Get Top Queries Taxing SQL Server CPUs
Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.
2012-03-10
2,904 reads
Generate INSERT for table with IDENTITY column
Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.
2012-03-09 (first published: 2008-01-07)
4,269 reads
Testing all procs before upgrading to Compatibility Level 90
You can use this script to check if any procs will break under compatibility level 90.
2012-03-08 (first published: 2008-01-29)
4,395 reads
Shrink all databases
Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).
2012-03-07 (first published: 2008-01-14)
3,951 reads
Sending Job Failed Information Through E-Mail Using T-SQL
Sending Job Failed Information Through E-Mail Using T-SQL.
2012-03-06 (first published: 2012-02-13)
2,337 reads
Check Table Size and DB Size
Two simple scripts to check table and database sizes. The scripts use temporary tables and the sp_msforeachdb/sp_msforeachtable stored procedures to present the output neatly.
2012-03-05 (first published: 2012-02-19)
2,720 reads
Server-Side Trace Pack
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-02 (first published: 2012-02-21)
1,158 reads
Generate consecutive numbers
TSQL code that generates numbers (tally table) from 1 to N without using any tables
2012-03-01 (first published: 2012-02-21)
1,841 reads
Blogs
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...
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
Forums
Alamat Telp BCA KCP Siliwangi (+62) 838-4945-0961
Wa:083849450961 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141
Alamat Telp BCA KCU SIDOARJO (+62) 838-4945-0961
Wa:083849450961 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Layanan BCA KCU TASIKMALAYA Telp:0817°82°5533
Telp/Wa 62817825533 Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kota Tasikmalaya, Jawa Barat 46124
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