The Effectiveness of Solar Estimation
We added a solar system to the ranch as a way to hedge against future costs as well as require less energy from the utility. I don’t plan to,...
2022-07-08 (first published: 2022-06-24)
235 reads
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-07-11 (first published: 2022-06-24)
525 reads
Daily Coping 24 Jun 2022
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-06-24
20 reads
When is a mouse not a mouse?
This is the first in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this...
2022-07-08 (first published: 2022-06-24)
343 reads
Shutting down nodes in Azure Kubernetes Service
A while back I wrote a post on Adjusting Pod Eviction Timings in Kubernetes. To test the changes made in that post I had to shut down nodes in...
2022-07-04 (first published: 2022-06-24)
214 reads
What is causing my constraint to be untrusted?
The problem
In this scenario, you have discovered that one of your Check constraints or Foreign keys is not trusted.
Maybe you’ve detected it with a sp_Blitz, dbachecks or out of...
2022-07-06 (first published: 2022-06-24)
368 reads
Daily Coping 23 Jun 2022
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-06-23
21 reads
Daily Coping 22 Jun 2022
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-06-22
48 reads
Log in to Power BI Desktop as an External (B2B) User
I noticed Adam Saxton post a tip on the Guy in a Cube YouTube channel about publishing reports from Power BI Desktop for external users. According to Microsoft Docs...
2022-07-06 (first published: 2022-06-22)
285 reads
Daily Coping 21 June 2022
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-06-21
45 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 Kantor Bank BCA KCU MALANG WA {08218154393}
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
Alamat Kontak Bank BCA KCP Bantul WA {08218154393}
WA:08218154393 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
Alamat Kantor BCA KCP Bantul WA(082144477715)
WhatsApp:0821-4447-7715 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
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