There is an amazing amount of slop in today's business world. I have no doubt the bank will continue, albeit with worse profits this year. Or maybe no profit, but...

I used to like to keep sa enabled in case someone did something stupid like remove the admin group because of a mis-click. These days, I would disable it and...

I'll second Thom's advice. This is asking for trouble and a poor habit.

Please create a new account that has limited access to what is needed. Use that. The...

And link in the database with a string URL? Is there any concern about synchronization?

FWIW: https://social.msdn.microsoft.com/Forums/en-US/fd5acaca-9911-4168-a82d-02a92c0d5a80/can-filestream-directory-containers-be-encrypted-with-efs?forum=sqlsecurity

I think EFS would work, or Bitlocker, but you should test

Glad it worked. I'd say undo the setup and restore the cert, then setup again. It's not that complicated. It is stressful though.

As Sue mentioned, you won't get any improvement here. There is slight value with more files at times, and there are often better performance on different drives, but slight. Really...

You can also use a proc to check if something changed. As sgmuson noted, you can use a semaphore (flag) to not editing. however, what can also be done is...

Each instance is limited to the max number of connections. If you connect to a readable replica, that has it's own set of connections, as noted above. However, if the...

Read Perry's stairway, which will help you understand. The cluster presents itself as a virtual IP and name, in addition to the IP and name that each node has.

This might help: https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding

There are tools that do this, but I think most cost money:
https://www.ispirer.com/products/sql-server-to-postgresql-migration
https://www.devbridge.com/articles/migrating-from-mssql-to-postgresql/#
https://dbconvert.com/mssql/postgresql/

I think you'd need some eventing (XE) to capture tempdb usage and also activity that's going on at that point.

R services in the database are a part of the core engine. The CUs/SPs will update r services. The code used is the same as other code. Nothing really for...