On bias
Last week saw the second month of my employment at Microsoft. I admit that I’m enjoying my job, and I can’t deny that the reduced amount of time I’ve...
2022-03-30
24 reads
Blog Posts
Passed a CosmosDB Exam
I took the beta exam for Cosmos DB a few months back. I did this as part of the MVP program, as they were asking people to evaluate the...
2022-03-30
35 reads
Azure AD Automatic Provisioning for Snowflake
Azure AD application provisioning refers to automatically creating user identities, groups and roles in the applications that users need access to for accounts created in(more...)
The post Azure AD Automatic...
2022-03-29
118 reads
Book Review – Azure Data Factory by Example
I just finished the book Azure Data Factory by Example: Practical Implementation for Data Engineers by Richard Swinbank. The book was not exactly what I was expecting, but that’s...
2022-03-29
59 reads
Daily Coping 29 Mar 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-03-29
24 reads
Daily Coping 28 Mar 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-03-28
12 reads
Parsing JSON in SQL Server with OPENJSON
Recently I had a piece of JSON of which I needed to extract data from to put into a table in Azure SQL DB. Unfortunately, the structure of the...
2022-03-28
90 reads
Shift calculations (or same time every day)
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. ... Continue reading
2022-03-28 (first published: 2022-03-15)
326 reads
Using Azure Blob Storage in Power Automate
In this video, Devin you will learn how to setup an Azure Blob Storage account and then use it in Power Automate. With Power Automate
2022-03-28 (first published: 2022-03-11)
580 reads
An Amazing Live SQL Bits in 2022
I was lucky to travel to London last week and attend SQL Bits 2022. This was the first live SQL Bits I’ve been to in 4 or 5 years,...
2022-03-25 (first published: 2022-03-15)
274 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers