SQL Server 2012 (“Denali”): New Security Features
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...
2011-12-23
1,967 reads
Blog Posts
SQL Server Sample Databases – All Versions
Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server...
2011-12-23
1,455 reads
Tis The Season to be Giving...#SQLFamily
Indeed the Holiday Season is traditionally a season of giving, and being charitable to those who are less fortunate. Although giving...
2011-12-23
1,681 reads
2011 What A Great Year
What A Diffrince A Year Makes
In January I posted up my new years list basically, stuff I wanted to learn in...
2011-12-22
1,031 reads
A SQL Server Christmas Card
Merry Christmas everyone!
DECLARE @hohoho char(100)
DECLARE @bells smallint
DECLARE @tiers smallint
DECLARE @maxtiers smallint
SELECT @hohoho = ' ', @tiers = 1, @bells = 1, @maxtiers = 6
PRINT @hohoho
WHILE @tiers...
2011-12-22
808 reads
CONCAT() string function–SQL Server 2012
As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...
2011-12-22 (first published: 2011-12-19)
4,001 reads
How many calls – A T-SQL Question
I got a call from a friend recently that was looking for some query help. He was actually using Access,...
2011-12-22
1,303 reads
PASS Summit 2011 Eval Results
My presentation on Professional Development Plans ended up being ranked 47th out of 190, with an overall score of 4.63....
2011-12-22
644 reads
SQL Server Sample Databases - All Versions
Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server...
2011-12-22
1,254 reads
The #Meme15 Round-Up
The first round of #meme15 has finished. In total, there were eighteen people that participated. If there were more, I...
2011-12-22
846 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