If you have excel data, or user-entered data, you have likely experienced frustration from repeatedly seeing the error message below upon hitting “Close & Apply” or refreshing your data...
2022-08-10 (first published: 2022-07-19)
249 reads
I mentioned in my New Database Job – The 90 Day Plan blog how I have a trick for storing index usage stats up until close to the next reboot...
2022-08-10 (first published: 2022-07-19)
445 reads
It is that time again. This time coming to you from a Mcdonald’s so my son can get out some energy, and it is 105 degrees outside. This will...
2022-07-19
45 reads
I honestly don’t know when or how I met Wendy Pastrick, but I’m so happy I did. Wendy and I have been friends for a very long time. Thank...
2022-07-19
23 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-19
13 reads
When I’m sharing code one of the things I hate most is having a scroll bar along the bottom. I ... Continue reading
2022-07-19
111 reads
At the most basic level, Snowflake has 3 important components. The Cloud services layer, centralised storage layer and the compute layer. Cloud services – they call this the “brains”...
2022-07-19
29 reads
SQL Saturday is coming back in-person to Los Angeles. I’ve been to this event a few times, and was sad when the pandemic pushed it virtual. However, 2022 is...
2022-07-18
12 reads
I learned something new recently. I can search in SQL Monitor for a database name, not just a server or instance name. I tested this over at monitor.red-gate.com recently...
2022-07-18
32 reads
Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...
2022-07-18
7 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Hub Cs: 08217555651 Jl. Jend. Sudirman No. 225-227-229-231, Badak Bejuang, Kec. Tebing Tinggi Kota,...
Hub Cs: 08217555651 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
TLP/CS 08217555651 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera Utara...
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