May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Hide in Code

Hide Code in SSMS – SQL in Sixty Seconds #154

February 3, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Management Studio, SQL Server Security, SQL Stored Procedure, SSMS

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.

Read More
hide code

SQL SERVER – Hide Code in SSMS

February 2, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Management Studio, SQL Server Security, SQL Stored Procedure, SSMS

Today we are going to learn something very simple but asked a lot by all of you as well as my client is that how to hide code in SSMS.

Read More
GUID

SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It

February 26, 2020
Pinal Dave
SQL
Service Broker, SQL Error Messages, SQL GUID, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Security

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.

Read More
database master key

SQL SERVER – Always On Error: This Database is Encrypted by Database Master Key, You Need to Provide Valid Password When Adding it to the Availability Group

February 22, 2020
Pinal Dave
SQL
AlwaysOn, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Security

This database is encrypted by the database master key, you need to provide a valid password when adding it to the availability group.

Read More

SQL SERVER – Huge Size of SSISDB – Catalog Database SSISDB Cleanup Script

November 24, 2018
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Encryption, SSIS

In recent past, while doing Comprehensive Database Performance Health Check I encountered an interesting issue. In this blog, I am sharing my knowledge about how to clean up the SSISDB database using the script.

Before you try this, make sure you have gone through below blog to check the symptoms.

Read More
keycertificates

Domain Controller – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved

June 16, 2017
Pinal Dave
SQL
SQL Domain Controller, SQL Error Messages, SQL Server, SQL Server Encryption, SQL Server Security

But now, as per company standards, they need to use a domain account as the service account. Let us learn more about that in this blog.

Read More

SQL SERVER – System. Security. Cryptography. CryptographicException – There Was an Error Generating the XML Document

April 1, 2017
Pinal Dave
SQL
SQL Error Messages, SQL Server, SQL Server Encryption, SQL XML

One of my clients contacted me in assistance to install SQL Server. Generally, this is straightforward, but sometimes there are problems. This time we received an error message and it was very interesting. Let us learn about error related to the XML Document.

Read More
1 2 3 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version