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, 3 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, 3 months ago by Johan Bijnens.
• This reply was modified 3 years, 3 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...

have a look at "Glenn's SQL Server Diagnostic Queries" ( Diagnostic Information Queries )

For systems databases ( master / msdb ) things work a little different !

Have a look at: Backup & restore: system databases (SQL Server)

hardware issue

Indeed, that's why we always perform DBCC CHECKDB after a database restore.

When you restored the prod db a second time to reporting, did you first drop de reporting db or did you restore with replace ?

In such case it will reuse...

What differentiates as Sequence ?

Why is "4001_0_3       1                                      08:00:00  "...

another option is to have the instances listen to port 1433.

How do regular consumers ( users / applications ) connect ?

If you activate sqlbrowser service on your instances, you don't need to provide the port number.

( of course not...

What kind of aliases are you talking about ?

• DNS aliasses ?

  • We use these to provide a "more meaningful" server naming ( but connections should also provide Instancename or...