Glad it made you think

Closing this thread as it has gotten off topic and a little out of hand. My apologies for not doing this sooner.

If you wish to discuss politics or...

The more data you delete in one batch, the larger the log records and and the more locks taken. Often easier and faster to delete in batches rather than one...

That's only a part of what auditing is. Auditing is deciding what information to capture, when, and for this objects. You have the last one, but what information needs to...

What do you need to audit? You still haven't defined this.

Reboot.

There isn't an expiration date, as noted, for licenses editions. For evals, use this:

SELECT

@@SERVERNAME SERVERNAME,

CREATE_DATE ‘INSTALALTIONDATE’,

SERVERPROPERTY(‘EDITION’) ‘Version’,

DATEADD(DD, 180, CREATE_DATE) AS ‘EXPIRY DATE’

FROM SYS.SERVER_PRINCIPALS

WHERE SID =...

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...