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,040 reads
Scripts
Windows Group Membership Checker
A script to reveal which logins have access to your sql server via windows groups.
2010-12-09 (first published: 2010-08-26)
2,431 reads
2010-12-08 (first published: 2010-12-03)
1,984 reads
2010-12-07 (first published: 2010-11-30)
2,191 reads
2010-12-06 (first published: 2010-11-22)
2,618 reads
2010-12-03 (first published: 2010-11-22)
1,712 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,684 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,223 reads
2010-11-26 (first published: 2010-11-04)
582 reads
2010-11-18 (first published: 2009-07-20)
2,950 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kantor BCA KCU HARAPAN INDAH Telp:082144477715
WA:0821-4447-7715 Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No. 1, RT.10/RW.8, Pusaka...
Alamat Kantor BCA KCU CIREBON Telp:08218154398
WhatsApp:0821-8154-398 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
Alamat Kantor BCA KCP Kalimalang Telp:08218154398
WhatsApp:0821-8154-398 Jl. Inspeksi Kav. PTB Blok A 2 No. 2 C-D, RT.1/RW.4, Pd. Klp.,...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers