Msg 15151, cannot alter the login ‘sa’, comes from missing rights. Only a member of the sysadmin role can change SA, so add the user to that role first.
Connection Resiliency: Surviving Brief Wi-Fi and Network Drops
Configure connection resiliency for brief idle network drops, test ConnectRetryCount and ConnectRetryInterval, and separate retryable failures.
Leading Wildcard LIKE Searches: Why They Scan and What Helps
Diagnose a leading wildcard LIKE scan and compare prefix search, reversed suffix keys, full-text search, and n-gram indexing.
SQL SERVER – DISABLE and ENABLE user SA
You cannot modify the permissions of the SA user, but you can disable and enable user SA with ALTER LOGIN. Log in with Windows authentication first.
SQL Server Express Limits: What the 10 GB Cap Really Means
Check SQL Server Express limits by version, separate data files from logs, and identify the memory, CPU, and scheduling limits that affect you.
SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL
A scheduled job has recorded scheduling metadata as well as its actual execution history. I check both before promising a next run.
Keeping SSMS Up to Date
Keeping SSMS up to date means reading release notes, choosing a supported channel, planning side by side installs, and checking settings.