And that's why there are central management servers and Powershell...

The worst schema I had to implement:

A customer wanted us to reboot the server for patches on the first friday of the month around 1am.

How do you schedule updates for...

A table is not an object, it's a set. A set contains zero or more elements.

Set = plural

Element = singular

Once you start thinking of a table as singular, your mind...

That doesn't shrink the file.

And the logfile of a simple database can also grow large if you try to do everything in one transaction.

That's what Powershell is for.

Invoke-DBAShrink -SQLInstance Instance -AllUserDatabases -FileType Log

Steve Jones - SSC Editor wrote:

ildjarn.is.dead wrote:

Do they require a reboot or a restart of SQL server service?

Not sure what you mean? Nothign I've shown requires a reboot

Exactly. So why add 'I am not...

Do they require a reboot or a restart of SQL server service?

• This reply was modified 2 years, 8 months ago by  ildjarn.is.dead.

In the end this was resolved by installing the latest CU, after which the WMI classes mysteriously appeared.

You've determined the best Batman movie, not the best Batman. A Batman can be awesome in an otherwise crap movie, or crap in an otherwise awesome movie.

I prefer to use Powershell, and Invoke-DbaQuery from within my Powershell scripts for things that require T-SQL. The source of all scripts is then in my Powershell library, instead of...

How thread-safe is this? I.e. will other sessions with updates also not fire the trigger?

I have. But see also the second line...

https://docs.microsoft.com/en-us/sql/language-extensions/language-extensions-overview?view=sql-server-ver15

So not every language can be added with a language extension, or am I misreading this?

I would've expected DROP TABLE to set @@ROWCOUNT to the number of dropped rows.

'Colts' is in the middle of the string, and TRIM() only removes characters from the beginning and the end.