That is a great graphic. I'm going to save it as well.

And if you want to write up something on how you used it in a specific situation, I bet...

Ha, I'm much more likely to help you get a first round bye.

Congrats, John

Ah, so filter by some amount of reads. Not sure how easy this is, but we might be able to sort by this. Filtering is definitely more work.

I had that happen with SQL Saturday. In setting up new accounts, the...

Two people authenticate a process. For example, I want to turn auditing off, but I can't do it alone. I ALTER AUDIT SET OFF, but until another admin does this,...

I'm not sure what you mean by "how much fews has a script"

I don't have a way to easily correct that. I can't mark two answers as correct in an either or scenario.

Ha, I should try some in C#. After lots of daily work in PoSh and some Python, I find the idea of working in C# cumbersome.

Yep, somehow missed seeing the note in the docs. Question corrected, or rather, answer changed to not use master_files

Meaning enter a date and only see scripts that were created after that date? What about updates to scripts?

We already have MFA authentication for Azure SQL.

For two-person authentication, it would be simply a matter of linking your AD account to another's cell phone - like your boss...

• This reply was modified 4 years, 5 months ago by Steve Jones - SSC Editor.

We have that as well. It remembers...

I thought that this would track the data, glad to see it tracks the column

Same tenant? Or different?

https://docs.microsoft.com/en-us/answers/questions/512410/moving-an-azure-sql-server-to-another-subscription.html

https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-move-azure-sql-server-to-another-subscription/ba-p/368790

I know for Azure SQL DB, they can store the cert in Azure Key Vault. Not sure what happens if you allow them to manage your backups. Is this for...