A New Word: Nighthawk
nighthawk – n. a recurring thought that only seems to strike you late at night – an overdue task, a nagging guilt, a looming future – which you sometimes...
2023-12-01
86 reads
Blog Posts
Building Upon Your Productivity Momentum: Staying Productive For Life
Note: I found this sitting in my Medium draft. This was a cross-post from my old productivity blog that got lost in oblivion. Productivity is never an accident. It...
2023-12-01 (first published: 2023-11-17)
262 reads
Changing the Data Type of a Primary Key–#SQLNewBlogger
A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this....
2023-12-01 (first published: 2023-11-20)
380 reads
PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple question: What do you think about PostgreSQL events? Prior to this year, I’d never attended...
2023-12-01
71 reads
Using ThinOptics to Read Data
As I’ve aged, I find myself struggling to read many things in my life. It started with difficulties seeing menus, but moved on to other areas. During the pandemic,...
2023-12-01
58 reads
Testing Microsoft Fabric - Part 3
Sorry to disappoint you. In this post, we won't test Microsoft Fabric directly. We will compare Azure Data Factory (ADF) to Microsoft...
2023-11-30
3 reads
Cosmos DB – Monitoring performance
Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query...
2023-11-29 (first published: 2023-11-15)
244 reads
Is that the right question to ask?
This is not a “clickbait” title, but an important consideration when it comes to developing technical solutions. Let me give you an example between two questions for SQL Server...
2023-11-29 (first published: 2023-11-17)
255 reads
SQL Prompt Tips–Using $surroundtext$ in a Snippet
A user on the SQL Community Slack was asking about what the $surroundtext$ variable. This post looks at how this can be used in snippets. This is part of...
2023-11-29
87 reads
Force parameterization is powerful-feature
Force parameterization in Microsoft SQL Server is a feature designed to optimize query performance by converting literal values in Transact-SQL statements into parameters. This process helps in plan reuse,...
2023-11-27 (first published: 2023-11-13)
889 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