Hungarian Notation is misunderstood
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
990 reads
Blog Posts
Missing Indexes
SQL Server has means built into it to track possible missing indexes. This used to be found through the use...
2012-01-17 (first published: 2012-01-12)
3,856 reads
PASS Data Architecture VC presents: Audrey Hammonds–Database Makeover: Renovate Your Data Model
Subject: Database Makeover: Renovate Your Data Model
Start Time: Thursday, January 19, 2011 12:00 PM US Central Time (January 19, 2011...
2012-01-17
494 reads
SQLServerCentral Webinar #15
Once again, I’m the moderator for a webinar coming up at the end of the month, on Jan 31, 2012....
2012-01-17
826 reads
TOP WITH TIES
I have been working with SQL Server for quite a few years now, and it still happens quite often that...
2012-01-17
6,330 reads
#meme15 – Use. Twitter. Why?
Should an average Jane or Joe professional use twitter?
Yes.
Why?
Because, I’m using it.
Not enough reasons? <grumpy face> I knew you wouldn’t...
2012-01-16
676 reads
Capacity Planning – Monitor and Extrapolate
I wrote a post recently on capacity planning, and then thought of one more thing. In addition to planning for...
2012-01-16
1,967 reads
Database Backups: Things You Need To Do Now
I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written...
2012-01-16 (first published: 2012-01-11)
5,168 reads
Help JHD Help MND
My good friend Justin Hostettler-Davies (JHD) aka @JHDAVIES , the same JHD who recently scaled Kilimanjaro, is on the fund raising...
2012-01-16
804 reads
Introduction to XML DML (Part 1) - Using the modify() method: insert
This is the first part of a 3 part blog which will attempt to show some different ways of how...
2012-01-16
16,257 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 BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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