Reading that SQL Server 2025 shipped without SSRS took me back to 2012, when Microsoft announced end-of-life for TMG — our perimeter firewall, web proxy, and SSL inspection. It had run quietly for years until it suddenly needed a plan. Within weeks, vendors found us. Demos, a steering committee, a three-month project plan. We weren't […]
Steve believes that his career and life have become better as he learns more everything. It's the key to improvement.
When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens.
We had an issue with a SQL Server database in an Always On Availability Group (AOAG) where it was not synchronizing the secondary replica even though it was using the “Synchronous commit” Availability Mode for the secondary replica. This article explains how to troubleshoot and resolve:
Communication is hard, and it's something most of us can learn to do better. Steve notes that using an LLM for tasks will also help you learn to communicate better.
Learn about a few new features built into SQL Server 2022 that can help improve performance on your workload.
Learn how to call locally hosted Ollama embedding models from SQL Server using sp_invoke_external_rest_endpoint
What happens when you have bad IT people working in your company? Steve Jones says that they always will be around, but we might not want to enable them to continue in this business when we find them.
Learn how to add the geometric mean in Power BI to your calculations.
In a previous tip on Orphaned User Detection for SQL Server High Availability Databases, we have seen how to identify when there are orphaned database users in an Availability Group database. Is there a way where we no longer need to worry about missing database users or different SID values between primary and secondary databases in an Availability Group?
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
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
