SSRS 2008 R2: Show Column Meta-Data in ToolTip
First, I want to apologize to the three people that read my blog. Sorry for going dark for such a...
2011-10-06
3,656 reads
SQLDownSouth
SSRS 2008 R2: How to dynamically size your INDICATORS
The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS...
2011-05-25
28,526 reads
SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)
I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL...
2011-05-20
1,128 reads
WHERE HAVE YOU BEEN, patrick leblanc????
Ok, so what have I been up to?Well a lot has changed for me over the past couple of months,...
2011-05-19
1,129 reads
Report Builder: Change Report Server Connection
A question that I have been asked quite often is, “How can I change the Report Server that I am...
2011-05-19
6,493 reads
SQL Lunch #51–SQL U Presents Women in Technology
This week I am happy to announce the second SQL University SQL Lunch presentation. What’s makes this exciting is that...
2011-03-17
1,150 reads
SSRS: Shared DataSet, Not So Shared!!!
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
2011-03-14
5,725 reads
SSRS: My Filter is not Working!!!
I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the...
2011-03-07
3,365 reads
SQL Lunch #50 - Solitary Containment (An Overview of SSIS Containers)
Join us tomorrow on the SQL Lunch for a little SSIS.
Topic: #50-Solitary Containment - An Overview of SSIS Containers
If you’ve ever...
2011-03-02
763 reads
I travel, I work, I EAT
As most of you know I am a consultant with Pragmatic Works, which requires me to travel a bit. During...
2011-02-12
661 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
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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