How the Resource Governor Helped Our Report Server
Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.
2010-06-28
5,693 reads
Roy Ernest
Ask for something and when you get it no one uses it
There was a time when almost every Chapter leader were asking PASS to find a place where the leaders can...
2010-05-21
399 reads
My experience while writing for SQL Server Standard magazine
It all started with Grant Fritchey (Twitter @GFritchey) posting on THE THREAD asking everyone if they are interested in writing...
2010-05-07
826 reads
Powershell- Is it easy as everyone claims?
Where ever you read, people claim that power shell is so easy that even a dummy can do it. Really?...
2010-03-08
625 reads
First International speaker for our User Group
I am a nervous wreck today. Tomorrow we will have the first International speaker for our user group. Jimmy may...
2010-02-17
737 reads
Jimmy May coming to our Local Chapter meeting
This is wonderful news to our new chapter. Jimmy May has agreed to come to give a presentation at our...
2010-01-26
691 reads
My first presentation for User Group
Yesterday was the first time I gave a presentation to a group of professional who knows SQL Server. I was...
2009-12-04
797 reads
A good way to learn
I have noticed that one of the best way to learn about a certain topic is to write an article...
2009-11-25
699 reads
To Grant or Not to grant
It is said that you should not give direct table access (even select permission) to a user or group. But...
2009-11-25
530 reads
Starting up a Pass Chapter
I am on my way in setting up a Pass chapter on our tiny Caribbean island. I had no clue...
2009-06-17
601 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 Kontak Bank BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
Alamat Kontak Bank BCA KCP Maluku Telp:08218154393
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
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