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,716 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
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