Bulk insert and an identity column
TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file...
2018-12-12
1,019 reads
Blog Posts
Getting the SQL Version from a backup using dbatools ………. on PowerShell Core
Following an upgrade to SQL Server the backup share had a number of backups, some from the old version and...
2018-12-12 (first published: 2018-11-26)
1,723 reads
Lessons from the Phoenix Project–Leave Slack
Not @Slack, but slack time, time when you aren’t buried on a particular project.
In the book, The Phoenix Project, the...
2018-12-12
256 reads
Some databases may show a NULL collation in the sys.databases DMV
While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the...
2018-12-12
234 reads
Some differences with SQL Server when running on AWS RDS
If you plan on using Amazon Web Services (AWS) to host your SQL Server based applications in the cloud, then...
2018-12-12
874 reads
SQL Server Vulnerability Assessment
SQL Server Vulnerability Assessment (VA) in SQL Server Management Studio 17.4 or later lets SQL Server scan your databases for...
2018-12-12
319 reads
T-SQL Tuesday #109–Influence
This month’s T-SQL Tuesday host is Jason Brimhall. He asks everyone to write about influence, which is something that I...
2018-12-12
261 reads
T-SQL Tuesday 109: To influence and to be influenced
The last T-SQL Tuesday of this year is hosted by Jason Brimhall – one of my long-time friends in the SQL...
2018-12-12
125 reads
TSQL-Tuesday #109 – Influence Somebody
Influence Somebody
Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were...
2018-12-12
160 reads
TSQL-Tuesday #109 – Influence Somebody
Influence Somebody Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were hit Sunday by a snowstorm… I had 7?...
2018-12-12
10 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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