Database Weekly Week
I used to build the Database Weekly newsletter and write the editorial every week. It was a chore, and it’s...
2010-02-23
801 reads
Viewing Missing Indexes in Management Studio 2005
If you’ve used SQL Server 2008 Management Studio (SSMS 2008), you may have noticed that Microsoft added a pretty neat...
2010-02-23
766 reads
MVP Summit Review
I was lucky enough to attend the MVP Summit held last week in Redmond and Bellevue. I attended the Summit...
2010-02-23
852 reads
Day 1 - Pragmatic Works Webinar Series
WOW – what a great turnout for our webinar series today. We had two sessions on Monday, looking for some great...
2010-02-23
585 reads
Why doesn’t my Intellisense work?
After yesterdays’ webinar, we got a lot of great feedback and questions. Once of the more common questions was around...
2010-02-23
455 reads
IntelliSense Slow to Refresh
IntelliSense in SQL Server 2008 can sometimes not be very intelligent. It’s there to help you can sometimes cause more...
2010-02-23
7,496 reads
Quest POTW Webcast on SQL Injection Now Available
Back a couple of weeks ago I had the privilege of participating in a Pain of the Week webcast with Kevin...
2010-02-23
1,377 reads
What Would You Do? Management Scenario #1
I’m in the early stages of a book on managing and I’m starting to look for situations that might trigger...
2010-02-23
1,101 reads
Cross Database RI Issues
I had an issue with a user recently. Actually it has been going on over a few weeks, due to...
2010-02-23
962 reads
Why Do I Need All These Servers?
Introduction
I am frequently getting requests for a new server to do this or that. Running through the usual questions to...
2010-02-23
470 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