This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A child's handprint set hard in a concrete square by a back door, a garden trowel lying useless beside it.

Immutable Backups: Keeping a Copy Ransomware Cannot Delete

August 20, 2019
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server, SQL Server Security

Design immutable backups with enforced retention, separate storage access, offline recovery material, checksum checks, and restore tests.

Read More
A hermit crab in a fresh shell beside its empty old one, a red starfish nearby.

Running SQL Server Under a Group Managed Service Account

July 23, 2019
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Configuration, SQL Server Security, SQL Server Services

Set up a group managed service account for SQL Server Engine and Agent, then verify permissions, SPNs, and Kerberos connections.

Read More
Gouache painting of a shut wooden cabinet with a vermilion key stuck halfway in the keyhole beside a ring of brass keys

msdb Upgrade Error 916: Fix the Database Owner

July 19, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server Security, SQL Upgrade, System Database

A msdb upgrade error can stop the service at the last upgrade step. The post reads the ERRORLOG, shows a read-only owner check, and walks through the four steps that fix the owner of msdb. The fix is one ALTER AUTHORIZATION statement.

Read More
Gouache painting of key-marked folders copied between database cabinets with a duplicate-key warning

DBCC CLONEDATABASE Error Msg 2601: Cannot Insert Duplicate Key Row in sys.sysowners

July 5, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server DBCC, SQL Server Security

A DBCC CLONEDATABASE error that names sys.sysowners points at a database user name, not at the database owner. The queries here find the conflicting user in model and in the source database, and I tested them on SQL Server 2025 along with a clean clone.

Read More
Gouache painting of a swept doormat with a pile of old brass keys aside and one vermilion key in the middle

DBCC FLUSHAUTHCACHE: Force Azure SQL to Re-authenticate

June 25, 2019
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Login, SQL Scripts, SQL Server Security

DBCC FLUSHAUTHCACHE clears the authentication cache of an Azure SQL database, so open connections must authenticate again. This post shows what a password change does to open sessions on SQL Server, why Azure SQL needs the extra command and how to list the sessions you want to end. It also covers the cautions that matter.

Read More
SQL SERVER - FIX: Msg 7416 - Access to the Remote Server is Denied Because No Login-mapping Exists

SQL SERVER – FIX: Msg 7416 – Access to the Remote Server is Denied Because No Login-mapping Exists

June 7, 2019
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.

Read More
SQL SERVER - FIX: Msg 15274 - Access to the Remote Server is Denied Because the Current Security Context is not Trusted

SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted

June 3, 2019
Pinal Dave
SQL Tips and Tricks
Linked Server, SQL Error Messages, SQL Server, SQL Server Security

In this blog we would talk about fixing error 15274 – Access to the remote server is denied because the current security context is not trusted.

Read More
Previous 1 … 7 8 9 10 11 12 13 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com