Steven Burns

Overcoming the OPENQUERY Record Limit for AD

Sometimes you have to pull more than 50,000 records. A script to do that inside the 1000 record limit.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(22)

You rated this post out of 5. Change rating

2014-11-13

8,177 reads

“Don’t aim to have others like you; aim to have them respect you.” –...

Many years ago, before I joined Oracle, I was working on a major modernisation...

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...

Comments posted to this topic are about the item Is Fabric a Reliable Service...

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 3;