A Summit Contest for registering by Sept 22
If you haven’t registered for the 2018 PASS Summit and plan to go, you might press to get registration done...
2018-09-17
871 reads
Blog Posts
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of...
2018-09-17 (first published: 2018-09-05)
2,543 reads
Deleting a User that Owns a Schema
This was an interesting question I saw posted recently. Through SQL Server 2000, trying to delete a user that owned...
2018-09-17
35,118 reads
How do I grant permissions to view users and their permissions?
tl;dr; VIEW DEFINITION
Every now and again you’ll have a user that needs to be able to see what permissions other...
2018-09-17
340 reads
Interview Query – 1
Somewhere on internet i found this question. Thought to share it with you all.
We have two tables, school_students and Class_student.
...
2018-09-17 (first published: 2018-09-04)
2,479 reads
Learn about SQL Source Control in Redgate University
I love the SQL Source Control product from Redgate. It’s not perfect, and it can be slow to run at...
2018-09-17
240 reads
Query Store and Log Backups
A question that came up recently around Query Store is what happens when there are log backups in use on...
2018-09-17
220 reads
SQL Substring function in SQL Server
The requirement of data refactoring is very common and vital in data mining operations. In the previous article, you’ll learn...
2018-09-17
270 reads
Batching data manipulation is great as long as you do it correctly
As Sinatra was fond of singing, “regrets, I’ve had a few.” And one of those came this week immediately after my presentation. This isn’t to say the presentation didn’t...
2018-09-15
16 reads
New Pluralsight Course – Provisioning Microsoft Azure Virtual Machines
My new course “Provisioning Microsoft Azure Virtual Machines” in now available on Pluralsight here! If you want to learn about the course, check...
2018-09-15
309 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 BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
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