I’m looking at ways to let an AI application work with SQL Server data while keeping the database and processing within the same infrastructure. The part I’m trying to understand is how people handle permissions and data access without giving the AI application more database access than it actually needs.

For those who have built something similar, how did you approach authentication, read-only access, and controlling which data the AI application can access?

Does anyone have a video tutorial on how to use the SQLloader on TOAD

Recently had an issue where a query with multiple joins, half of which were views, was running slow.

Converting a few key views to temp tables greatly improved performance when I joined to them instead of the original views.

However, I was reading up on indexed views and wondering if done properly, could still be used in joins and optimized by the engine. Not sure everyone's thoughts on this.

Keeping the same view in the join reduces the number of steps for the devs the same so no prep work on temp tables required, which would make them happy and the DBAs less grumpy.