A Basic Update Trigger: #SQLNewBlogger
I had someone ask me about using triggers to detect changes in their tables. As I explained a few things, I thought this would make a nice series, so...
2025-06-04
79 reads
Apply for a 2025 PASS Summit Scholarship
Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket to the main part of the PASS Summit, but also $1400 towards travel and accommodations....
2025-06-18 (first published: 2025-06-04)
249 reads
SQL Server TempDB: The Most Overlooked Bottleneck
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk drawer – everyone uses it, nobody monitors it, and eventually it becomes a bottleneck you...
2025-06-23 (first published: 2025-06-04)
836 reads
Why I Created the SQL Rescue Sprint – And How It Works
Over the past 25 years, I’ve worked with SQL Server in all kinds of environments: startups, mid-size companies, and global enterprises. And no matter the industry or infrastructure, one...
2025-06-04
44 reads
Getting Started with SQL Server 2025 Public Preview: A Step-by-Step Installation Guide
A step-by-step guide to installing SQL Server 2025 Private Preview.
2025-06-04
3 reads
IndiaAI मिशन: भारत को AI की ताकत से बदलने की तैयारी!
🔹 मिशन विज़नIndiaAI पहल का उद्देश्य आर्टिफिशियल इंटेलिजेंस की शक्ति का उपयोग करके नवाचार को बढ़ावा देना, पहुंच को बेहतर बनाना और देशभर में सामाजिक-आर्थिक विकास को गति देना है।...
2025-06-04
18 reads
IndiaAI Mission: Transforming India with AI Power!
IndiaAI Mission: Empowering India Through Artificial Intelligence🔹 Mission VisionThe IndiaAI initiative aims to harness the power of artificial intelligence to drive innovation, improve accessibility, and catalyze socio-economic development across...
2025-06-04
13 reads
Invoking Another Pipeline in Microsoft Fabric
At the moment there are two activities in Fabric pipelines that allow you to execute a “child” pipeline. They are both named “Invoke Pipeline” but are differentiated by the...
2025-06-16 (first published: 2025-06-04)
765 reads
My first year on full disability, wow!
What a year … At the end of May 2024, I went on full time disability. For the first time in my adult life, I was not fully employed....
2025-06-03 (first published: 2025-06-02)
47 reads
Getting References for GenAI Results
I wrote an editorial on the view of GenAI tech from execs and someone commented that they wanted references for results. Most of us might take a result from...
2025-06-02
40 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
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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