Notes from Mission Critical Environments in SQL Server 2012, Webinar by Marc Theoret
The other day I sat in while Marc Theoret gave a great overview of the what is coming in SQL...
2011-12-11
1,431 reads
Blog Posts
#sqlfamily
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,700 reads
A PASS Board Of Directors Endorsement
One of the requirements for the PASS Board of Directors application was a collection of recommendations - 3 from volunteers, 3...
2011-12-09
893 reads
My Recipe for Chocolate Pie
One of our small holiday traditions is that we bake at least one home made dessert. Hard to beat the...
2011-12-09
656 reads
PASS Board Of Directors Voting Open Through Dec. 20
Voting for the 2011 PASS Board of Directors elections started earlier this week and if you were a PASS member...
2011-12-09
679 reads
PASS Speaking Results
I got the PASS speaking results today on the new speaker portal. They posted the top sessions as well, overall...
2011-12-09
1,108 reads
Re-blog – December 2 – December 8
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-09
561 reads
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,127 reads
SQL Database Status with sys.databases
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column...
2011-12-09
850 reads
SQL Server MVP Deep Dives Volume 2 – My Review
Volume 1 was packed full of knowledge and a very welcome edition to my bookshelf! With the bar already set...
2011-12-09
847 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