xevents is very lightweight, but since jobhistory is going to get this, not sure you querying text is better than a table.

I would lean towards Jeff's idea here if possible. There is an audit event on restore start, but that won't stop anything. At best, you'll get a chance to kill...

If the vendor doesn't want to allow changes. I'd build a process to "scrub" entries every minute. Index the column if you can and search for problem strings. Then decide...

ISDATE() isn't perfect (https://stackoverflow.com/questions/32755924/isdate-in-not-working-as-expected-in-sql-server)

You may need some other guard clauses or checks to be sure the value is a date. Unfortunately, dates are just not stored in a consistent...

For TDE, the symmetric encryption key, the DEK, is in the database. This is always the case. The certificate that is used to encrypt/decrypt this is stored in Azure Key...

Seen this? https://support.microsoft.com/en-us/topic/sql-server-does-not-start-because-a-service-account-could-not-be-authenticated-2238c1b1-a360-91cb-951e-5b42a135b461

If you read references to "Level Up", that's our Redgate conference.  It was internally described as: Level Up is Redgate’s way of celebrating learning and development, helping us all to...

We are having a work conference this week at Redgate. In previous years, we rented a space for a few days and literally ran a conference. Booths were from different...

Thoughts this crew might like this:

"Do not assume that index maintenance will always noticeably improve your workload."

• https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15#index-maintenance-strategy

Indeed. That's a bad one.

We don't have an IF really, but you can use CASE.

For sum of operating expenses, you could include a case when (materials or personal expenses) else 0 for the value....

Should be, they have it linked and listed from multiple places.

It's helpful if you post data in a consummable format, as in the DDL to create a table and the DML to insert data.

What I might do here is create...

What format are you logs? Any data can be loaded into SQL SErver in a table, but you usually need a process to run the import.

This comes from sys.sysprocesses. If you check the docs (https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysprocesses-transact-sql?view=sql-server-ver15), this is listed as the last time that the user executed something.