I dug around for a bit, but couldn't find any docs for Vormetric.

What I did find is that there are a couple different Vormetric encryption products for SQL Server, and...

What provider are you using?

Invest in your career, and consider a PluralSight subscription. They have monthly subscription options and a free trial offer, so you can start cheaply and see if it's right for...

Here's a couple queries you can use to inspect things. Note the relationship between, master.sys.asymmetric_keys, sys.server_principals, sys.server_principal_credentials, sys.credentials, and sys.

The Credential object holds the login information for SQL Server to use when communicating with the KMS. "Identity" is the user name on the KMS, and "SECRET" is the password....

• This reply was modified 5 years, 6 months ago by Eddie Wuerch. Reason: Skipped a step
• This reply was modified 5 years, 6 months ago by Eddie Wuerch. Reason: Added "FOR CRYPTOGRAPHIC PROVIDER [crypto_provider_name]" to step #2

You need to use the same certificate in both the master database and the user database, not just a certificate with the same name.

Here are the steps, with the...

• This reply was modified 5 years, 6 months ago by Eddie Wuerch. Reason: Correction and additional detail

Rewriting the requirement: Generate a random positive integer value between 10000000 and 99999999

Solution: Create a random positive integer value between 0 and 89999999, and add 10000000 to it.

            
March 19, 2020 at 5:07 pm
            
#3735649

            
            
                                                
        

Looks like a lot of work to build an 8-digit string that means 'yesterday', one date part at a time.

First, it determines what year was yesterday.

The part that sets the...

• This reply was modified 5 years, 6 months ago by Eddie Wuerch. Reason: formatting

Embed your search argument in a variable, and use that in the function:

-- sample data 
CREATE TABLE #Testr(id int not null primary key, MyField varchar(128))
GO
INSERT #Testr(id, MyField)
SELECT...

• This reply was modified 5 years, 6 months ago by Eddie Wuerch. Reason: added more comments to the code

TL;DR: just get the encryption Certificate loaded on every AG instance before encrypting, and it will just work.

TDE encryption is performed as normal transactions against a database. When you perform...

In order to protect against DST settings, just run the job 5 minutes past every hour. At the start of the job, check to see if it's the 'correct' time...

To format the SQL on-the-fly, search for 'syntax highlighter'. One I've used is the open-source GeSHi tool (https://en.wikipedia.org/wiki/GeSHi), although its T-SQL coloring was last publicly updated a while ago. You can...

See SET LANGUAGE for setting the language SQL Server uses for the connection for system messages and month/day names:

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-language-transact-sql?view=sql-server-ver15

Instructions for installing an English-language SSMS on a non-English OS are available...

• This reply was modified 5 years, 9 months ago by Eddie Wuerch. Reason: Original sample I posted was in Japanese, but the code editor barfs on Unicode :P

Also, be very protective of that Certificate. You will need it to restore backups of databases encrypted with it. The database backup will not have the Certificate; you must separately...

• This reply was modified 5 years, 9 months ago by Eddie Wuerch. Reason: fixed a typo

"What happens if the DB is already part of AG and I enable TDE on the DB on primary? How does TDE work in that situation?"

SQL Server encrypts the database...