Let an LLM query SQL Server through a restricted login, approved views, enforced row filtering, execution limits, and query auditing.
SQL SERVER – T-SQL Fortune Cookies
Fortune cookies contain uplifting messages that bring a smile after a good meal. Did you know they likely originated in America, not China?
Column-Level Permissions: Hiding One Column From Some Users
Apply SQL Server column-level permissions, test DENY and SELECT behavior, inspect explicit grants, and compare views with data masking.
SQL SERVER – Rename View
When I rename view objects, I inspect references and retained definitions first. SSMS and sp_rename both need dependency planning.
SQL SERVER – Using NOEXPAND with Indexed View
NOEXPAND treats an indexed view as stored indexed data instead of expanding its base tables. Customer results have differed.
SQL SERVER – Modifying Table Used In SCHEMABINDING View
I received a very interesting question from the user. The question is about modifying the table used in the SCHEMABINDING View.
What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245
SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.