SQL Server 2012 licensing
Microsoft has recently released the licensing overview for SQL Server 2012. A few things has changes from SQL Server 2008,...
2011-11-14
952 reads
Blog Posts
SQLInspire - Follow-up & Post Event Notes....
This blog entry is a short post-event follow-up for all our followers and attendees at the event! I will have...
2011-11-14
1,015 reads
SQLInspire NYC 2011
I sit here in a hotel room as I reminisce on this past weekend. This last weekend began with a...
2011-11-14
543 reads
SQLInspire NYC 2011
I sit here in a hotel room as I reminisce on this past weekend. This last weekend began with a red-eye trip from Salt Lake to New York. The...
2011-11-14
7 reads
The Industry Problem according to @Way0utWest
Steve Jones (blog/@way0utwest) from SQLServerCentral posted his daily editorial today titled "The Industry Problem" in which he describes an article he...
2011-11-14
1,021 reads
TSQL Challenge 63 – Update
If you recall, I like Sudoku. I even posted a script for solving it via TSQL. I went so far...
2011-11-14
1,037 reads
TSQL Challenge 63 – Update
If you recall, I like Sudoku. I even posted a script for solving it via TSQL. I went so far as to enter my script into a TSQL Challenge....
2011-11-14
15 reads
An Informal Compendium of SSAS Errors, Part 5: Incorrect Calculation Results, Miscellaneous and MDX Studio Errors
This is the fourth in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-11-13
1,906 reads
Merge Business Logic Handler Conflict Resolver
Introduction
This example demonstrates how to implement a business logic handler for a Merge article to perform custom resolution of conflicting...
2011-11-13
1,412 reads
Merge Business Logic Handler Custom Conflict Resolver
Introduction
This example demonstrates how to implement a business logic handler for a Merge article to perform custom resolution of conflicting...
2011-11-13
2,475 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas 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