Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: certificate

SQL Server certificate for backups: Does expiration date matter?

By adminPosted on December 3, 2022

Question : If I have a cert in SQL Server, used for backups: Can backups still be created after cert […]

Grant User permission to view XE results via sys.fn_xe_file_target_read_file

By adminPosted on October 14, 2022

Question : I need to grant a user (MyDomainJohnSmith) permission to view one particular XE session results using sys.fn_xe_file_target_read_file I […]

Changing a certifcate+key algorithm by dropping & recreating with the same names

By adminPosted on July 25, 2022

Question : We have a situation where a symmetric key has been created (a long time ago) using TRIPLE_DES. This […]

Force Client to Validate SSL Certificate?

By adminPosted on June 20, 2022

Question : When SQL Server uses the Force Encryption with value “yes” then if in the client-side we use encrypt=true […]

Domain Certificate Authority Generated Certificate and SQL Server – Keyset does not exist

By adminPosted on June 18, 2022

Question : I do not have much experience with certificates or certificate terminology, so I may be incorrect in how […]

ola-hallengren backup solution with encryption is not encrypting

By adminPosted on May 14, 2022

Question : Installed OH’s scripts and they run great. sqlserver 2017 standard edition in a testing/dev environment. testing before rolling […]

SSDT Schema Comparison for Stored Procedure signed by a Certificate

By adminPosted on May 10, 2022

Question : I am using SSDT 14.0.50730.0 in Visual Studio Professional 2015. I am comparing databases between two instances and […]

Permissions in triggers when using cross database certificates

By adminPosted on May 9, 2022

Question : I use cross database certificates (as explained by Erland Sommarskog) to control access to a certain database in […]

How to get certificate expiration date for certificate in mirroring endpoint in SQL Server 2016 Always On Availability Group?

By adminPosted on April 6, 2022

Question : I created a domain-independent 2-node SQL Server 2016 Always On Availability Group using the Microsoft instructions: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/domain-independent-availability-groups?view=sql-server-ver15 One […]

Sharing certificates encryped by password between DBs and instances

By adminPosted on April 5, 2022

Question : Question: I am trying to create a single (self signed) certificate and deploy across many databases and instances. […]

  • 1
  • 2
  • 3
  • …
  • 5

Recent Posts

  • Get column names and data types of a query, table or view
  • What is the effect on primary keys when moving a CLUSTERED index to a new filegroup?
  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding