Have you heard about Retention lock, Immutable Shared Folder, WORM (Write Once Read Many)? Many NAS and storage manufacturers have that feature, including QNAP, Synology, HPE, NetApp and many others. They all are referring to the same concept: after backup …
There is often confusion between Login and User in SQL Server. What is the difference and what is the link? I hope to clear that out in this short video:
Sometimes we need a low-privileged user to do a specific administration task or task that require some server-level permissions (such as VIEW SERVER STATE, ALTER TRACE etc). Of course, we do not want to give that account server-level privilege, because …
