Thanks for the idea.  A role to help organize these permissions would definitely help.

We have 87 table types in our DB and I was looking for a way to grant...

I wanted to post a follow up as I got a script put together to turn off filestream.   It's really just a modification of the script from the article I...

I have this fully working now.  Thanks to Johan for his suggestion.  The other issue that was causing problems was that we have 2 subscriptions in azure.  One is for...

Thanks for this idea.... I had not tried it without the domain.  After some quick testing it appears to be working.

I need to put a bit more time in to...

We copied xmlrw.dll from a working machine to the /system32/   and /SysWOW64/ directories on our Azure SQL VM in order to get this working.  I think system32 was probably...

We were able to get this to work by copying xmlrw.dll from another VM to this VM.    I would prefer to understand why this file wasn't in place, but I...

Thanks for these ideas!  I have it working in a foreach loop, but I'd like to try the second option that you mentioned.  I would think that it would be...

I wanted to provide some follow up in case this helps anyone in the future.  We've worked with MS over the past few months and found a pattern that allowed...

• This reply was modified 1 year, 8 months ago by  tommiwan.

Thanks again Andy!  I read through that documentation just to make sure I had everything set up properly.  For whatever reason, today the AAD security group authentication is working.   I...

Thanks Andy!  I do understand that a typical user would be created as a contained database user and would need to pass the database name in as part of their...

Thanks again for the replies so far.  I think it may take some time to work through this with MS.   One specific question I have though...

Since we shut the db...

Thanks for the replies so far!  Here are some answers to a few specific questions.

The reason the servers get shut down each night is because the application is used by...

When I mentioned "offload" I'm referring to where the VM lives.  We have certain on prem host servers that are licensed for SQL server, and others on prem host servers...

• This reply was modified 4 years, 5 months ago by  tommiwan.

Thanks, I did check to make sure that there was no blocking going on.   After reading some of Brent Ozar's articles regarding performance issues I'm starting to lean toward parameter...