Who did what?
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)
4,257 reads
Scripts
Display row value as a TABLE column using SQL select statement
Display row value as a TABLE column using SQL select statement
2012-01-12 (first published: 2007-10-26)
4,753 reads
2012-01-11 (first published: 2008-04-16)
5,186 reads
Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
5,470 reads
2012-01-09 (first published: 2007-11-13)
4,940 reads
2012-01-06 (first published: 2008-02-15)
7,331 reads
2012-01-05 (first published: 2011-12-09)
2,606 reads
Restore database from a device containing multiple backups
Script to restore the LATEST full and differential backups from a SQL Server 2008 R2 backup device.
2012-01-04 (first published: 2011-12-13)
2,217 reads
Quick check SQL connection and process details with current SQL text
This script will be useful to quickly check incase of any blocking or log wait occurs
2011-12-30 (first published: 2011-12-05)
1,550 reads
SQL Agent Jobs Summary
The following script can be used to determine the list of enabled SQL Agent Jobs, their start time, average run duration and next run date.
2011-12-29 (first published: 2011-11-30)
2,198 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
LAYANAN BCA KCU PRABUMULIH Telp/Wa 08388333589
Jl. Jenderal Sudirman No.14, Muara Dua, Kec. Prabumulih Tim., Kota Prabumulih, Sumatera Selatan 31121
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...
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