Testing if a Port is Open With PowerShell
Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that, Test-NetConnection. With the -Port option, this cmdlet will do...
2018-11-20
69 reads
Blog Posts
Testing if a Port is Open With PowerShell
Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that,...
2018-11-20
6,914 reads
Watch out – new Database Level Health Detection can send your AOAG down!
Background
In the past, Windows Server Failover Clustering (WSFC) cluster only monitored the health of your entire Always On Availability Groups...
2018-11-20
299 reads
Would you give our database monitoring the UX thumbs up?
“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other similar UX advice, before. We are passionate believers in...
2018-11-20
24 reads
Would you give our database monitoring the UX thumbs up?
“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other...
2018-11-20
278 reads
2018-11-19
8 reads
2018-11-19
5 reads
A New Video - Create a DB Executor Role
A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There...
2018-11-19 (first published: 2018-11-12)
1,829 reads
Ethics in Data Science and Artificial Intelligence
Microsoft redid its Data Science Track not too long ago and they added several courses and new progress points. One...
2018-11-19 (first published: 2018-11-08)
2,783 reads
Fun with PowerShell: I made a game
So we got to playing around with PowerShell last week – one son is making a game hack, and the other...
2018-11-19
215 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