The question is:

"What will be the status of the Availability Group (AG) if I proceed with the switch to synchronous commit mode?"

By status of the AG I believe you are...

Legal issues aside, if you are wanting to setup up something very quickly to see what audits will look like to record, check out the SCHEMA OBJECT ACCESS GROUP audit...

I am replying to this article because I ran into an issue which ultimately was found to be SQL Server overloading our storage subsystem and the resolution was to turn...

• This reply was modified 5 days, 10 hours ago by Smendle.

SSIS is a GREAT tool.

You can use it for so much more than the actual work it performs.

The visual aspect gives you lots of solutions.

• document processes
• Train new personnel

I...

ensure you are using the sql native client driver