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.
Query Hints on a View in SQL Server: Where OPTION Goes
Query hints on a view cannot sit inside the view. Learn where OPTION goes, what a view may contain, and how Query Store hints help.
Table or View in SQL Server: Check With OBJECTPROPERTY
To settle table or view in SQL Server, ask OBJECTPROPERTY. This post builds a table, a view, a synonym and a procedure, and reads the answers for each. It also shows a trap with other databases and a catalog query for every object.