My August Christmas Card
Do you ever get the Christmas card that features a beautiful picture of a family on the front, and a letter catching you up on their year on the...
2020-08-28 (first published: 2020-08-18)
231 reads
Blog Posts
The value of mentoring
I’ve spent my whole career working with databases which is over 20 years and counting. I work for a great company and I love what I do. The job...
2020-08-28 (first published: 2020-08-17)
203 reads
A Quick SQL Change Automation Build
I was going through a few of the Redgate products with a customer recently and they wanted to perform some validation of the build and release process with SQL...
2020-08-27 (first published: 2020-08-19)
531 reads
As a DBA, am I a gatekeeper?
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading
2020-08-27
188 reads
Azure SQL Database Automatic Tuning
I really like the automatic tuning aspect of Azure SQL Database. This post is not a full explanation and demo. Instead, I want to point out a small point...
2020-08-27 (first published: 2020-08-17)
265 reads
Daily Coping 27 Aug 2020
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...
2020-08-27
20 reads
Daily Coping 26 Aug 2020
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...
2020-08-26
22 reads
GCP Refresher – Intro, Free account with 300$ credit, Service Model, Cheat Sheet & Billing
[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us onFacebook & YouTube.] Let’s review our GCP concepts. Refresher – Intro, Free account with 300$...
2020-08-26
68 reads
Measure Ethical Data Analysis by Outcomes, Not Intent
Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
In January 2020, Robert Williams was arrested on his front lawn in a suburb of Detroit, Mich., after police...
2020-08-26
12 reads
SQL Clone Works with FILESTREAM
SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to share a read only image, but still produce writeable databases that look normal to SQL...
2020-08-26 (first published: 2020-08-12)
211 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 TEBING TINGGI TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Jend. Sudirman No. 225-227-229-231, Badak Bejuang, Kec. Tebing Tinggi Kota,...
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08217555651
TLP/CS 08217555651 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera Utara...
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