Also, once you TDE any database on an instance, then tempdb also automatically becomes a TDE database to prevent any TDE-encrypted data from being written unencrypted to a tempdb file....

We use TDE with an HSM for several multi-TB highly-transactional databases.

Once you set up and enable the encryption, it will run silently in the background encrypting the database while normal...

The foundation certification for both SQL Server dev and DBA is MCSA:

https://www.microsoft.com/en-us/learning/mcsa-sql-certification.aspx

Once you have passed the three MCSA exams, you may work toward one of the SQL Server...

Why BCP at all? You're adding the expensive steps of converting all of your data into and back out of text while forcing all of it to be written, flushed,...

Queries aren't routed, the entire connection is. The connection does not change based on the type of query executing on that connection. You will connect to the Listener in either...

If you have a support agreement, call them up and scream at them.

What does 'inaccessible' mean?

After the failover, is the database online and available on the second instance?

If the database isn't online, then there's one troubleshooting path.

Have those domain users...

Most efficient would be the 3-byte date data type.

Second would be an integer storing the number of days since January 1, 1900 (use DATEDIFF(d, 0, <input_date_value>) to calculate the value,...

You have lots of time and the database files are small. This can be easy:

1. Detach each database. This will complete all active transactions and shut down each database in...

morleyf (4/19/2016)

---

Is mixing the DMZ and internal databases on a single cluster a bad idea?

... Since this Instance is servicing public facing applications in the DMZ, is it safe to...

Ray K (3/30/2016)

---

I came up with an abstract. Let me know what you people think.

Groupthink is a phenomenon that is highly destructive -- and all too common in group...

szejiekoh (3/22/2016)

---

Hi all,

Specifies the TCP/IP authentication requirements for connections for this endpoint.

Does the "for" actually means "to" ?

-- means that client connections to this endpoint must be authenticated with...

If the source database is live in production, and the Database Master Key (DMK) has been encrypted by the instance's Service Master Key (SMK), then you can create any number...

I would start by looking at the following things:

> <frame procname="" line="89" stmtstart="9704" stmtend="18556" sqlhandle="0x03001200f252954d9248480120a400000100000000000000" />

This 9,000-character-long call looks like it's part of a much-larger batch. Examine that for locks...

Check the Windows logs on the server where the errors were thrown, because it looks like you lost the transaction log file, or access to it. My gut says you...