Last week we laid out the foundation for how SQL Server executes queries. I have also already talked here a little bit about pages that are buffers of 8kb....
2022-02-11 (first published: 2022-01-31)
806 reads
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...
2022-01-31
41 reads
I am looking forward to presenting to the Ohio North Database Training User Group this Tuesday, February 1st, starting at 4:00pm CST. It is exciting for me to kickoff...
2022-01-29
41 reads
Have you ever had to find the number of rows in a user table, and then wrote a little “SELECT COUNT(*) FROM tblWhatever” and hit execute…and waited…and waited…and waited...
2022-01-28
312 reads
Heraflux Technologies was invited to co-present on an “Ask the Experts” webinar with Pavilion Data featuring Costa Hasapopulous, Pavilion Data’s Chief Field Technology Officer, and myself! RSVP for this...
2022-01-28
17 reads
I got a note this week from the organizers of VS Live. They let me know the March event in Las Vegas was being cancelled. That was disappointing to...
2022-01-28
12 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-01-28
36 reads
As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share
2022-01-28
312 reads
Today's post describes SQL queries to get the following information about the processors of a SQL Server instance: 1. The total number of ph
2022-01-28
187 reads
This article will demonstrate the method to store comma-separated values into different columns using SQL Server(T-SQL) query.
2022-01-28
498 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