Some initial thoughts on the matter:

- Verify that you have valid database backups in place before changing a live environment.

- Have a rollback plan setup ahead of time in case...

The short answer is, it depends, on far too many factors for anyone to say definitively what would be best for your environment.

Generally speaking you'll want to keep blocking to...

jhager, if you're interested, here is an article that explains why the transaction log is involved in full backups and how much of it is required:

http://www.sqlskills.com/blogs/paul/debunking-a-couple-of-myths-around-full-database-backups/%5B/url%5D

Deflated (Warriors lost)

Pretty much the same deal. If you steal a backup with encrypted columns and restore it to a new instance you still need to, at minimum, be able to decrypt...

I'm with Grant here. Time for you to put in some effort so 1. you yourself know and understand is actually running in your production environment, 2. you can explain...

mlemay-957463 (5/14/2013)

---

I wanted to gather Active Directory data into SQL Server table to analyze permissions on critical data. I wanted to use a SQL Server Agent Job that would...

sjs-36273 (5/14/2013)

---

GilaMonster (3/4/2012)

---

kilkenny (2/27/2012)

---

My first inclination was to turn on TDE, but after reading several articles, I'm worried about losing performance. If we choose to encrypt at the column-level,...

I remember one server I had to work on being hacked to us autologon so the machine logged itself in as the SQL Server service account upon reboot so the...

What edition, version and build are you guys on?

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('Edition') AS Edition,

...

It's been a while,...

shamshad.ali (5/14/2013)

---

Thanks for help, could you please write some more in details, how can we supply login I'd and password to network drive, do you mean while mapping it? Please...

Ideally the network device would be setup to refer to Active Directory for Authentication, but if that is not possible and the device does it's own Authentication then you can...

None of the DBAs I know with a system of your specs (x64) would categorically reject someone offering them an increase in RAM. That is typically a good thing.

When the...

It could, but remember that the original statement is not what is replicated, the resulting CRUD operations are (minus the R's) so blocking should be reduced.

Said another way, imagine...