SQL Lunch – Pick your favorite Logo
We have been working on the logo for a month now, but instead of making the final decision I have...
2009-09-23
781 reads
SQLDownSouth
TSQLScripts.com – Script of the Week
After about 3 weeks of digging through .css files and html code I finally found the problem with the site. ...
2009-09-21
509 reads
Upcoming SQL Lunch (Live Meeting) – Historical DMV Information
The next SQL Lunch is scheduled for Monday, September 28. See below for details
Date: 9/28/2009
Time: 11:30 AM
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend
Presenter: Thomas...
2009-09-21
478 reads
SQL Server 2008 R2 August CTP – Utility Control Point (UTP)
I finally carved out some time in my day to try and get the August CTP of SQL Server 2008...
2009-09-18
1,362 reads
Article of the Week – Kevin Kline “Social Media Scene”
This weeks article is written by Kevin Kline, which is titled “Getting Up-to-Speed on the SQL Server Social Medial Scene”. ...
2009-09-16
934 reads
Windows Internal Database
This past Friday I received a call from our systems team stating that they were running low on Disk Space...
2009-09-14
4,377 reads
Today’s SQL Lunch - Oracle-CDC for SQL Server Integration Services
Join us today for a SQL Lunch
Date: 9/14/2009
Time: 11:30 AM
Reserve your seat:https://www1.gotomeeting.com/join/509742840
Presenter: Jeff Cole. Jeff has been designing and building...
2009-09-14
720 reads
.Net SQLConnectionStringBuilder ApplicationName Property
We have several “Home Grown” applications at my current place of employment. This provides our development staff with a great...
2009-09-11
1,949 reads
SQL Lunch - Oracle-CDC for SQL Server Integration Services
We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am...
2009-09-10
711 reads
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-09
2,018 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