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
Blog Posts
A Quick Intro to DevOps in Azure
Today, I’d like to discuss DevOps in Azure and tell you why you should consider using DevOps when you start...
2018-09-14
938 reads
How Do Azure Subscriptions Work?
In this Azure Every Day installment, I’d like to talk about your organization’s subscription hierarchy. When working with Azure, it...
2018-09-14 (first published: 2018-08-31)
2,623 reads
Looking at the PASS FY 2019 Budget
I just spent a few more minutes looking at the FY 2019 budget. It is hard to assess whether it’s...
2018-09-14 (first published: 2018-09-04)
1,530 reads
Customer Roadblocks to Azure
When I speak with customers, I often find they share common roadblocks to using Azure. I recently sat down with...
2018-09-13
707 reads
Does The Order Of Index Columns Matter?
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance...
2018-09-13 (first published: 2018-09-04)
5,018 reads
I/O vs Logical I/O
tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two...
2018-09-13 (first published: 2018-09-05)
3,631 reads
SQL Server string functions for Data Munging (Wrangling)
In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server....
2018-09-13
356 reads
Azure Storage – Hot, Cold, Archive
There’s a lot of talk about storage options. When working with customers, I often introduce them to Azure through storage,...
2018-09-12
725 reads
Bulk insert issue with UTF-8 fixed-width file format
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as...
2018-09-12
293 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