Part of my job at work is to update Transact-SQL reference content. System dynamic management views (DMVs) have permissions that are managed in the SQL Server Database Engine source...
2025-09-08 (first published: 2025-08-23)
263 reads
rivener – n. a chilling hint of distance that creeps slowly into a relationship – beginning to notice them laugh a little less, look away a little more, explain...
2025-08-22
19 reads
Today's reality is that cybercriminals are increasingly using AI to develop better attacks. This is just the latest reported technique, probably because it's starting to be used more often....
2025-09-12 (first published: 2025-08-21)
246 reads
Aligning Technical Excellence with Organizational Agility Tuning SQL performance in Azure transcends routine database management and becomes a strategic imperative when viewed through an executive lens. Slow database operations...
2025-09-12 (first published: 2025-08-21)
345 reads
I wanted to do some testing of SQL Server 2025 on my laptop. I have written before how I avoided installing SQL Server on the laptop and use containers...
2025-09-10 (first published: 2025-08-20)
775 reads
If you’re responsible for a SQL Server instance, you need working, consistent backups. Not just a .bak file here and there, but a plan that runs automatically and covers...
2025-08-20
35 reads
I’m in the progress of migrating some legacy stuff at a client, and in their Power BI environment there are still quite some Power BI dataflows Gen1. I had...
2025-09-05 (first published: 2025-08-20)
373 reads
Over the years, I’ll admit, SQL Server has come a long way in making life easier for database administrators and with each version it keeps getting better and better....
2025-09-08 (first published: 2025-08-19)
509 reads
I want to talk about a fairly new product that you may not be aware of: Azure IoT Operations, which GA’d last November (it was first announced at Ignite...
2025-09-03 (first published: 2025-08-19)
787 reads
This weekend was one of my favorite Data Saturday events, Data Saturday Columbus! If you’re in the area, I highly recommend it. Always some great speakers, amazing lunch, and...
2025-08-19
20 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers