Viewing 15 posts - 1 through 15 (of 607 total)
Have you taken a full backup of the database since it was placed in the Full Recovery Model? Until the first full backup completes, the transaction log acts as if...
September 24, 2020 at 3:18 pm
The deadlock graph contains the SQL statements involved in the deadlock, which may include parameter values.
If your database contains PII or other data that must follow regulations (GDPR, HIPAA, etc.),...
June 12, 2020 at 3:22 pm
First, you need to deal with the XML Namespaces xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" and xmlns="urn:partner.soap.sforce.com" :
WITH XMLNAMESPACES ('http://www.w3.org/2001/XMLSchema-instance' AS xsi, DEFAULT 'urn:partner.soap.sforce.com')
Then you can shred each row's address XML column...
April 12, 2020 at 5:54 pm
I used Microsoft's Data Experimentation Assistant (DEA) on my last upgrade project. The databases upgraded included 100TB+ databases pushing billions of transactions per day: https://docs.microsoft.com/en-us/sql/dea/database-experimentation-assistant-overview?view=sql-server-ver15
DEA is a system for...
April 3, 2020 at 11:31 pm
Just run setup.exe from the install media, and specify everything as parameters of that. Here's the doc on those parameters:
March 31, 2020 at 3:11 pm
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...
March 30, 2020 at 3:26 pm
What provider are you using?
March 25, 2020 at 3:21 pm
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...
March 24, 2020 at 5:48 pm
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.
March 24, 2020 at 5:36 pm
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....
March 24, 2020 at 2:58 pm
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...
March 20, 2020 at 7:19 pm
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
March 19, 2020 at 5:07 pm
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...
March 9, 2020 at 7:11 pm
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))GOINSERT #Testr(id, MyField)SELECT...
February 29, 2020 at 10:45 pm
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...
February 21, 2020 at 5:10 pm