Snapshots are not backups. They aren't even copies of the database. They don't become backups until they have been transferred off of the SAN in a format that can be...

Configure the client connection string to include MultiSubnetFailover=True so the client will try each of the addresses.

Under the 'Multi-Subnet Failovers' heading in the doc at https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-ver15 :

This is...

To show all employees:

1. Remove the filter on EmployeeID from the WHERE clause
2. Add EmployeeID to the grouping

Using Example 2:

-- Add Emp to groups so it can...

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...

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.),...

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...

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...

Just run setup.exe from the install media, and specify everything as parameters of that. Here's the doc on those parameters:

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15

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 4 years, 8 months ago by  Eddie Wuerch. Reason: Skipped a step
• This reply was modified 4 years, 8 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 4 years, 8 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