Why Your SQL Permissions Disappeared
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.
2026-07-10
3,292 reads
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.
2026-07-10
3,292 reads
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:
2026-07-10
Learn about a few new features built into SQL Server 2022 that can help improve performance on your workload.
2026-07-08
3,694 reads
Learn how to call locally hosted Ollama embedding models from SQL Server using sp_invoke_external_rest_endpoint
2026-07-08
Learn how to add the geometric mean in Power BI to your calculations.
2026-07-06
1,221 reads
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?
2026-07-06
Learn how to get started with an MCP server that can query your SQL Server database.
2026-07-03
5,011 reads
Another fun article for America's Independence Day using SQL Server's spatial features.
2026-07-03
919 reads
From the Air Canada chatbot lawsuit to the infamous Chevy dealership pricing fiasco, this article breaks down the six real reasons RAG systems fail in production – and the five architectural patterns high-performing AI teams use to make them trustworthy, grounded, and production-ready.
2026-07-03
The vendor file arrived twice overnight, Snowflake loaded both copies without complaining, and finance found the problem before the pipeline did.
2026-07-01
1,018 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers