Follow my stairway series on this site starting at...

dmc-608719 (1/7/2015)

---

As the title says.. I am looking to implenet TDE. I was looking at this article

http://msdn.microsoft.com/en-us/library/bb934049(v=sql.110).aspx

Before proceeding with these steps I wanted to look a little more at...

sounds like what they're looking for is Oracle RAC

if you have access to dns clean up the dns records too

UconnDBA (1/5/2015)

---

KenpoDBA,

Basing that on all our other database backups, in 2012 and 2008r2, compressing to a file less than 30% of the database size. I did try running the...

to be clear, latches occur on physical disk pages and inmemory pages

sej2008 (1/4/2015)

---

I was able to do windows cluster successfully on vmware but after destroying it and I wanted to rebuild cluster on same nodes with same vmnode as DC.But...

with a decent pipe between sites i've copied over the network overnight, that was from UK to Arizona.

multiple IP addresses on different subnets but not VNNs

you add the primary, the est should be taken care of

Failover cluster manager in Windows 2008 and 2012 is pretty much exactly the same bar a few small tweaks.

Do you even have a clustered instance of SQL server running?

Start by...

dbaduck (1/5/2015)

---

You need to ensure that the computer name does not exist in AD. A failed install attempt can put that name in AD. The network name you add in...

check for any type of LOB columns, as these do not compress well, if at all.

This should help identify any large columns

select object_name(c.object_id) as tablename,

c.name as columnname

from sys.all_columns c inner...

sej2008 (1/2/2015)

---

I went through the link given it was indeed helpful.but I want to know do I have to create separate Domain User in AD for SQL clustering and then...

create a role for your clustered sql server instance and into the role put the required shared disks for the sql instance and a shared disk for the DTC.

Right click...