2008-01-29 (first published: 2007-11-23)
1,970 reads
Scripts
2008-01-28 (first published: 2007-12-03)
1,705 reads
Server Login/Role And DB User/Role Script
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,794 reads
2008-01-24
1,236 reads
Locate specific columns used in procs
SP to find object and line number that references column(s) of interest.
2008-01-24 (first published: 2007-11-21)
1,025 reads
2005 Database Monitor RDL for Management Studio
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2008-01-18 (first published: 2007-09-25)
2,695 reads
Check Availability Window - SQL2k
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,084 reads
Making a table out of a list
Sometimes you are given a list of values in a stored procedure that you want to use in an "IN" clause. This is a common in Reporting Services multi value parameters.
2008-01-15 (first published: 2007-11-15)
1,005 reads
2008-01-14
990 reads
Generating number sequences
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
925 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 Bank BCA KCP Lomanis Telp:08218154393
WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa...
Alamat Kantor Bank BCA KCU CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
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