You thought SQL Server ate up memory…
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially....
2009-04-11
1,425 reads
No Opening Day
For the second year in a row I didn’t purchase opening day Rockies tickets. I had a nice streak of...
2009-04-10
796 reads
Book Review: Red Lightning
Back in December 2008 I wrote up a quick review of Red Thunder, and then received Red Lightning as a...
2009-04-09
284 reads
My Kingdom for a Port
A Port, a Port! My Kingdom for a Port!!
One of the steps in setting up database mirroring is to assign...
2009-04-09
1,073 reads
NULL is not = to anything
One of the fun facts about SQL Server and the relation model is the
whole concept of three valued logic. Now...
2009-04-09
1,108 reads
Activity Monitor in SQL Server 2008: an Embedded Optimisation Gizmo for the Thrifty DBA
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,789 reads
Prius Repair Update
We decided to let the pros replace the seat belts and do the other repairs and file a claim on...
2009-04-09
371 reads
PASS Summit 2009 Call For Speakers Extended - And Why
Please consider this a not quite official announcement, look for that on the sqlpass.org site today or tomorrow.
You may have...
2009-04-09
1,212 reads
My Mini Identity Protection
Last week, on April Fool’s Day, I woke up to find quite a few birthday congratulations in my email. I...
2009-04-09
385 reads
Animation in Presentations
I've never been a fan of animation in Powerpoint presentations, and as a result almost never use them in my...
2009-04-08
418 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