More Snapshot Backups
I got some more feedback from my Connect item on allowing snapshot backups. They took notice, but I heard the...
2010-02-26
1,558 reads
Suncoast Technology Forum Tech Fest Event 2010
I presented a 30 minute session at Suncoast Technology Forum Tech Fest on Windows Scripting Automation with Powershell: "This session will...
2010-02-26
1,756 reads
Speaking in Cambridge, England March 24, 2010
If you are near Cambridge, England, I will be speaking at the Cambridge SQL Server Users Group on Wednesday, March...
2010-02-25
1,542 reads
SQLBits 6 to Be Held in London, April 16, 2010
The upcoming SQLBits 6, to be held Friday, April 16, 2010, will be held at the Church House Conference Centre...
2010-02-25
1,616 reads
Why Do My SQL 2008 Compressed Backups Shrink?
Introduction
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing...
2010-02-25
422 reads
Editorial - “Dude, Your Fly Is Open”
In case you don’t subscribe to the SQL Server Central daily newsletter, check out the editorial I wrote entitled “Dude,...
2010-02-25
600 reads
Renaming a Standalone Instance of SQL Server
I needed to upgrade the underlying IO subsystem of one of my IO intensive SQL Servers. After some discussion with...
2010-02-25
2,194 reads
I’m Attending the South Florida Code Camp on February 27, 2010
I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and...
2010-02-25
524 reads
Day 4 - Pragmatic Works Webinar Series
Hey gang !
I’m presenting today at 1pm on Zero to Cube in 60 minutes. We’re going to build an analysis...
2010-02-25
418 reads
The Journey from Smart to Good
“It’s easier to be smart than good.”
I heard that quote in a recent sermon at church and it is one...
2010-02-25
761 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