It’s usually good to break up the files in this manner. However, be sure to check out how this maps back to actual storage. It may be that you’re creating...

For most situations I agree with you. I would do it via more normal means. However, the reason I mentioned the example I did was to basically ask the question...

Don't use a logon trigger. Go with an extended event:

https://voiceofthedba.com/2015/12/16/tracking-logins-with-extended-events/

Another idea for a PK is a composite key (two columns) consisting of the year + the day of the year. There are some uses for this.

If you've configured successful or failed logins monitoring for the SQL Server, the information will be written in the SQL Server logs as well as the OS' Application event log....

Andy Leonard (former SQL Server MVP) doesn't frequent these forums much, but I would ask him if he knows a better way as I know he does DevOps with SSIS...

Have you done this?

Go into SQL Server Configuration Manager for that SQL Server and clear out all the TCP Dynamic Ports (set them to 0) and TCP Port...

As Steve posted, check the SID on the new login versus the user SID in the database.

SQL Server, like Windows & AD, uses a unique identifier (SID) to...

Without doing something crazy security wise, you'd have to leave those settings on all the time for users C and D to work. Out of curiosity, why are they trying...

This may be more doable and it's what I recommend over the aliasing. It's an A or CNAME record (recommend the CNAME) by your DNS administrator:

https://www.mssqltips.com/sqlservertip/2663/using-friendly-names-for-sql-servers-via-dns/

You typically get this error when there's an issue communicating with the storage device. What happens when you run a backup using a SQL Server Agent job and not through...

I don't believe this can be done without some sort of scripting effort such as around dtutil.

Is antivirus in control of the firewall? I've seen cases where it is and unless you check advanced, it may appear off when it isn't.