Understand cross-database ownership chaining, inspect its scope, and use signed procedures for narrow access between SQL Server databases.
Hide Code in SSMS – SQL in Sixty Seconds #154
I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Here is the video on the topic.
Hide Procedure Code in SSMS: What WITH ENCRYPTION Covers
To hide procedure code, create the procedure WITH ENCRYPTION. A demo shows what the clause blocks: the text, the definition and the plan. It also shows the ALTER trap that unhides a procedure, and why this is obfuscation and not security.
SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It
In this blog, I would share my knowledge about how to fix error 15580 – Cannot drop the master key because dialog “GUID” is encrypted by it.
Encrypted by Database Master Key: Fix the Always On Error
Adding a database to an availability group can fail with the message that the database is encrypted by database master key, even when TDE is off. This post finds the key, checks what depends on it and lists three ways to continue. A demo database shows the checks and the error that protects a key still in use.
Connection Strings Explained: Encrypt, TrustServerCertificate and Timeouts
Explain TrustServerCertificate, encryption modes, connection and command timeouts, listener failover, and server-side connection evidence.
Listing Driver, Encryption and Auth Scheme for Every Connection
Inspect the auth scheme, encryption, driver interface, and protocol for current SQL Server connections, then group the results clearly.