Free SQL Server Dashboard
Greg Larsen, a SQL Server DBA, and the owner of the website SQLServerExamples.com, has released a free plug-in for SSMS...
2009-09-23
4,154 reads
Presentation Skills from Brent Ozar
If you present at any level, read this. If you’re thinking about presenting, read this. If you’d like to start...
2009-09-23
1,076 reads
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
Venturing into Powershell
As you probably know if you read my blog regularly, I recently put together a presentation called, Dive into the...
2009-09-23
498 reads
Fun with Firewalls
We have a couple of boxes at a local Denver co-location facility for the training business, SQL Share. Our firewall...
2009-09-23
911 reads
External MAML Help Files
One of the really handy improvevements in Powershell V2 is around creating help information for your script users. I often find myself having...
2009-09-23
752 reads
MVP Profile of the Week.....
It’s time for the MVP Profile of the Week!
You’ve probably seen his work, as he’s been busy producing content for...
2009-09-23
1,404 reads
PASS Book List
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
551 reads
PASS Connector Editorial for September 23, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-22
562 reads
ADO.NET in PowerShell
I've had to rework some logic for gathering database information in my serverstatus.ps1 script, because SMO doesn't exactly do things...
2009-09-22
746 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