Bulk Insert Permissions
In order to be able to execute bulk operations you need to certain level of privilege both on the database...
2010-10-28
32,959 reads
Blog Posts
Creating Analysis Services Partitions Using BIDS
As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one...
2010-10-28
3,359 reads
Fundamentals of Storage Systems, Understanding Reliability and Performance
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
827 reads
Fundamentals of Storage Systems, Understanding Reliability and Performance of Solid State Storage
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
1,136 reads
Last Call for PASSMN Board of Directors
As I mentioned a couple weeks ago, we are looking for nominations for the 2011 PASSMN Board of Directors. PASSMN...
2010-10-28
496 reads
Overwhelmed, Stress, and Planning
It’s been a bit hectic this year. In fact, it feels crazy most weeks as I try to manage work,...
2010-10-28
787 reads
PASS Summit Blogging
During the PASS Summit I have again been given the opportunity to keep my laptop plugged in… as long as...
2010-10-28
767 reads
SQL Rally: Performance Tuning Abstract
I get the call, you get the call, everyone gets the call. “Hey, my app/procedure/query/report is running slow.” Now what...
2010-10-28
714 reads
SQLSaturday#59 Speaker Interview #13 – with Mark Kromer
SQLSaturday #59 Speaker Interview #13 – with Mark Kromer
Today, coming in from Philadelphia, PA, we are talking with Mark Kromer, who...
2010-10-28
795 reads
Vote for the Pre-Con’s You’d Pay to Attend
If you read this blog you probably already know about the PASS SQLRally and that we are doing things a little...
2010-10-28
379 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 BCA KCU TEBING TINGGI TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Jend. Sudirman No. 225-227-229-231, Badak Bejuang, Kec. Tebing Tinggi Kota,...
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08217555651
TLP/CS 08217555651 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera Utara...
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