What Does It Look Like When Everything Is Okay?
I'm a big believer in looking at systems when everything is okay. I'm not the only one, as Joe Richards, a...
2010-02-22
876 reads
What’s up with the reads?
So the other day I read Andrew Kelly’s article, Do You Have Hidden Cache Problems, in the latest electronic edition...
2010-02-22
371 reads
When Should You Start Speaking?
I know it’s daunting and a little intimidating, but there are so many people with knowledge to share. I see...
2010-02-22
937 reads
City of Orlando Switches to Google Email
This happened earlier in the year, finally getting around to writing some notes on it – you can read more here....
2010-02-22
734 reads
Experiments with Data Compression in SQL Server 2008
Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use...
2010-02-22
2,113 reads
I’m givin’ ‘er all she’s got!
Or am I?
As I proceed down the path on a consolidation project, I have taken time to pause and ponder...
2010-02-21
667 reads
SQL Server 2005 CLR execution error after restore
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the...
2010-02-21
1,181 reads
New iSCSI Performance Benchmark from Microsoft and Intel
The Windows Server Division blog has a post up trumpeting a very impressive iSCSI benchmarking result achieved with Intel hardware...
2010-02-21
938 reads
Problem Using the Aggregate Function with Calculated Measures
Recently, I was working with a client we were working on a calculated measure using the aggregate function to rollup...
2010-02-21
675 reads
Measure Properties Explained
When configuring measures in SSAS, you want to make sure you address a few important properties. They are show in...
2010-02-21
1,101 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