Script to grant exec permission to all sps in a db
Script to grant exec permission to all sps in a db
2010-12-13 (first published: 2010-12-09)
1,751 reads
Scripts
How to get all MSSQL database columns names, data types and length
know all database columns names and data types and lenght with the minimum effort
2010-12-09 (first published: 2010-12-06)
3,055 reads
2010-12-08 (first published: 2010-12-03)
2,004 reads
2010-12-07 (first published: 2010-11-30)
2,212 reads
2010-12-06 (first published: 2010-11-22)
2,639 reads
2010-12-03 (first published: 2010-11-22)
1,725 reads
Average Page Life Expectancy
A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.
2010-12-01 (first published: 2010-11-16)
1,717 reads
SQL Function to Split Comma Separated Values and Insert into Table
SQL Function to Split Comma Separated Values and Insert into Table
2010-11-30 (first published: 2010-11-07)
4,236 reads
2010-11-26 (first published: 2010-11-04)
597 reads
2010-11-24 (first published: 2010-11-02)
3,553 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
Layanan Resmi BCA KCU BEKASI Telp:0817°82°5533
Telp/Wa 62817825533 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks,...
Layanan Resmi BCA KCU GARUT Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Ciledug No.162, Kota Kulon, Kec. Garut Kota, Kabupaten Garut, Jawa Barat...
Layanan Resmi BCA KCU SUBANG Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
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