I don't know for Aurora and mysql

In SQLServer you can just use "GRANT view definition TO ..."

I would not rename the new server (to much a hassle ), but have an alias for the name of the old server point to the new server.

I figured out why the exec @cmd wasn't working. I was filtering out the files before it got to the cursor. Now I have one last problem. I am...

Does your service account have access to 'D:\TelcorLogDump\' ?

crossed with your last reply 😉

• This reply was modified 3 years, 11 months ago by Johan Bijnens.

1. Of course, updating the existing table will cause splits / fragmentation
2. My guess, your primary key is non-clustered ( dbatools scenario ), so insert into a heap ( quickest...

Using "with standby" you force the engine to make your database available in a read-only state.

If you know you'll have to restore all log backup files, use NoRecovery in stead...

SQLServer will have to rewrite the whole table as internal workings of varchar(n) versus varchar(max) !

1. You could also prepare the modification via SSMS and script the operation.

It will probably...

So, someone has a local instance of SQLServer on his/her/its client and declared a Linked Server pointing to another SQLServer instance which can be available with an active VPN connection.

...

On top of Grants replay, you should probably be using last_request_start_time to avoid killing sessions which are still actively used.

( maybe killing one of your sessions with which you are...

Intercept the connections to get a glimpse of who connects from where and when.

You can start reading my little article "Logon monitoring in SQL Server and Azure Managed Instances...

Indeed, but best is to just avoid the SVF

• This reply was modified 3 years, 11 months ago by Johan Bijnens.

Hello Johan.

I have a couple of Scalar Functions that are sub-second.

1 that I use every day passes an IP Address/Subnet in and returns a human friendly site name by...

• This reply was modified 3 years, 11 months ago by Johan Bijnens.
• This reply was modified 3 years, 11 months ago by Johan Bijnens.

As a general rule of thumb, you should not write any scalar valued functions. At all.

Even tough SQL2019 and up are evolving in this troublesome area, just don't use SVFs.

Even...

Extended events are your friends !

e.g. "Audit Login Change Password Event Class"

You can always start reading my little article "Logon monitoring in SQL Server and Azure Managed Instances...

1.  Always ( indeed ) start with Data Migration Assistant
2. Fresh Hardware / fresh OS / Latest SQL Server version and CU over in-place upgrades. Hands down.

   It will indeed...