Peter McLarty (1/31/2016)

---

Hi

The company I am working generally denies Server Admin rights to the DBA. I have to set up log shipping and I can see that with 2008 and...

Ed Wagner (1/29/2016)

---

Perry Whittle (1/29/2016)

---

Doubt you'll find that, upgrading the sql server version using rolling update is a supported path for...

Theyre useful for standalone instances as well as clustered

dajonx (1/29/2016)

---

Yes, I do. I also read that eight data files should be the minimum if the server has more than eight cores (server will have 16 cores on...

Doubt you'll find that, upgrading the sql server version using rolling update is a supported path for sql server

Just run

exec sp_validatelogins

This will identify any AD users or groups which have been removed from AD but not from the SQL Server instance

Typically used in...

You could split tempdb data and log, these must be kept separate fro user...

dajonx (1/29/2016)

---

Hi,

What do you think about using mount points for SQL Server? Is there a performance difference between using a mount point or a drive letter?

Any insight...

Connecting through SSMS?

The listener connects you to the instance that's the Primary replica for the AO group, you'll see any databases you have access to.

use NTPassword reset boot disk

APA0876 (1/27/2016)

---

Hi,

This is my current scenario:

Windows Server 2008 R2

SQL Server 2012 Enterprise Edition Active \ Passive Failover Cluster

Intended scenario:

Windows Server 2012 R2

...

the solution would be to use a separate network for your iSCSI connections

Everything you need is in my stairway on this...

Welsh Corgi (1/28/2016)

---

I thought that you need the Private Key to restore a TDE Database?

All that I have is the following:

tde.key

tde.cert

Master.Key

Service Master.Key

Is this enough to restore a TDE Database?

I tried...