It's not just booze and it's not not something I have a solution for. In any size group, there will be people that behave poorly. Rather than create stringent rules,...

There isn't a best solution. Every solution has tradeoffs, and depending on what you audit, this can be a tremendous amount of data.

If you use SQL Audit...

This does work. I tested it today to verify.

TDE encrypts data at rest. When an authorized user connects and queries data, the database engine decrypts the data in...

That's where I'd start. The stairway gets you moving. Itzik's book is great. From there you could look at the Hi Performance SQL Server book and the T-SQL Recipes books,...

Let's make this easier. Node1 is the original primary and Node2 is the original secondary.

When Node1 comes back, it's not going to failback immediately. It comes back as...

What are you trying to accomplish with tracking changes? What's the purpose?

Did you choose the Azure Resource Manager (ARM) deployments? All these resources should have ARM templates available in the portal or with AzureRM PoSh cmdlets. You can get the templates,...

What I would do is have other apps that can connect to the instance (SQLCMD, SSMS, etc.) and verify they work after the kbs are installed. Ultimately, without a test...

Not to be pedantic, but you're not saving the procedure or function. You're compiling it each time. If you want to do this, you can use a DDL trigger,but you...

Thanks

I would have thought 10 as well. This is a strange choice to me, but it is what it is.

So it's easy to be surprised by this if you don't see it, but it's also easy to be ignorant of behaviors that don't seem to be much to you.

It's law for government. It's...

We also have a Stairway to T-SQL ( a couple actually) here to help you learn.