Midlands PASS Meeting – February 5, 2019
Midlands PASS (Columbia, SC) will be hosting Shannon Lowder on February 5, 2019, from 5:30-8:00 PM. He will be speaking...
2019-01-29
147 reads
Blog Posts
Opening a Twitch Channel, Data Wisdom
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on...
2019-01-29
5 reads
Opening a Twitch Channel, Data Wisdom
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here....
2019-01-29
184 reads
Query tuning: The IN clause
This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say...
2019-01-29
2,651 reads
Research into Autism in Information Technology
Title: Exploring the experiences of employees on the autism spectrum working in information technology: an interpretative phenomenological analysis
My name is Sabrina Ellis, I am the Operations Director here at...
2019-01-29
35 reads
Research into Autism in Information Technology
Title: Exploring the experiences of employees on the autism spectrum working in information technology: an interpretative phenomenological analysis
My name is...
2019-01-29
197 reads
SSDT: Build in VSCode
Over the last couple of years I have been using VSCode more and more and Visual Studio less and less, this is great but there isn't first class support...
2019-01-29
5 reads
SSDT: Build in VSCode
Over the last couple of years I have been using VSCode more and more and Visual Studio less and less,...
2019-01-29
368 reads
Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf). Most...
2019-01-29
424 reads
Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to...
2019-01-29
1,074 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