Eric M Russell (9/7/2012)

---

I don't know why someone would care to have a high end graphics card in their work PC... unless they are playing Modern Combat 2 or watching...

Dream machine for work?

Well, without price limits it's a pretty silly question - that's going to be something like a Dell T620 tower, dual socket octo-core 2.9Ghz Xeon, 384GB of...

Backups by date/time are definitely easier to deal with, especially if your SQL Server is toasted or you're at a DR site and you want to see what you have.

Take...

Jeff Moden (8/28/2012)

---

shannonjk (8/28/2012)

---

In fact there is a disturbing rate of people who claim to be DBA's who can barely put a select script together or know how to run...

Evil Kraig F (8/28/2012)

---

In the end, any argument I hear for 'centralize everything' sounds to me like 'I don't trust anyone else to do their job well enough'. Well,...

Thank you for reporting back - did performance improve as well as the crash frequency being reduced?

Why would you need a 200GB tempdb? Index creates and/or rebuilds on...

Jeff Moden (8/28/2012)

---

Is it something that could change characteristics based on the next change that MS might bless us with or do you think it's stable for the good part...

JimS-Indy (8/28/2012)

---

I do resent the notion that "SIT" cares more about a quality product. I produce a quality product that has been through a careful QC process. But I know...

Well run Central IT (CIT) does a more thorough job for the organization... taken as a whole, and filtered through operational (not stated) organizational priorities.

Well run Shadow IT (SIT) can...

Even stranger is that despite the 8/22/2012 date, it still claims to be version 1.0, and it still only officially supports up to Windows 2003 and XP (not 2003 R2,...

You're welcome - all of my work is on the remote end, not the local end, but I do hope that the links are helpful to others.

For your specific question,...

I haven't gotten around to moving WMI calls to a non-admin account yet, but what I've been looking at in preparation:

http://technet.microsoft.com/en-us/library/cc787533%28v=ws.10%29.aspx

http://www.poweradmin.com/help/enableWMI.aspx

While I haven't touched the PCIe SSD's yet (Fusion-IO, OCZ Z-drive, etc.), with the SATA and SAS SSD's, treat them similarly to extremely short-stroked spindle disks - high throughput, very...

Steve Jones - SSC Editor (8/16/2012)

---

BlackHawk-17 (8/15/2012)

---

If there is separation of duties where you, as a DBA, do not have the rights to create accounts or drop them in OUs...

1) Security permissions testing; just why can't SQL Server access X...