How to change password of SA login using Management Studio: log in with Windows Authentication, open the SA login properties, set the new password and test it.
Working With an Outsourced Database Team
An outsourced database team needs a clear scope, controlled access, useful reporting, and a plan to keep operational knowledge in house.
Hashing Data With HASHBYTES
HASHBYTES creates repeatable row fingerprints with SHA2 algorithms, but input encoding, NULL handling, and collision risk need a clear plan.
SQL Server Permissions Without the Guesswork
Understand SQL Server permissions through principals, securables, roles, and ownership chains, then inspect what the current account can do.
SQL SERVER – 2005 – Get Current User – Get Logged In User
How to get current user for a query in SQL Server 2005: SELECT SYSTEM_USER returns the name of the current context, which helps with debugging and security.
SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database
Invited to review a big company’s schema, I wanted to know my own permissions without asking their DBA. fn_my_permissions shows them at server and database level.
SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
Msg 7411 says the server is not configured for RPC. A Jr. DBA I am training found the fix on his own: turn the RPC option from False to True.