Why It’s Called a User Group…
On Tuesday night was the first meeting for PASSMN, the SQL Server User Group in Minneapolis/St. Paul this year. As...
2012-01-18
580 reads
Blog Posts
#SQLThursday is here
Struggling to source quality free content on SQL Server? Finding it difficult to fill the void between #TSQL2sDay and Un-SQL...
2012-01-17
412 reads
A Trio of Functions
I found myself perusing an execution plan the other day. I know, big surprise there. This execution plan showed me some interesting things I had never really paid much...
2012-01-17
14 reads
A Trio of Functions
I found myself perusing an execution plan the other day. I know, big surprise there. This execution plan showed me...
2012-01-17
1,246 reads
ColoradoSQL for January 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-01-17
565 reads
CTE command In Sql Server
Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by...
2012-01-17
4,986 reads
Eliminating Successful Backup messages with Powershell and SMO
As a DBA, I enjoy knowing that the better job I do, the less likely it is that any of...
2012-01-17
944 reads
Error when creating a subscription
When creating a subscription in SQL Server sometimes the following error will occur:
The remote server "%s" does not exist, or...
2012-01-17
1,919 reads
Free SQL Performance Tool Worth Checking
First, I’d like to wish my readers a very safe, happy and prosperous 2012 (santé, properité, et bonheur). This is...
2012-01-17
1,629 reads
Goals – 6 month checkup
Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself...
2012-01-17
827 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