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
There are two different ways one can rename view in SQL Server. Let us see in today’s blog post how to rename view. 1) SSMS 2) T-SQL
SQL SERVER – Using NOEXPAND with Indexed View
I was helping one of my clients with tuning a view (my personal opinion, I do not like views), when I used NOEXPAND with the Indexed view…
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.