Eric M Russell (6/25/2013)

---

By and large, employees are granted more access to data than they really need to perform their job functions. I'm surprised when people talk about a database...

And that is the crux of the matter.

There are lots of people out there who are responsible for looking after...

kevaburg (6/19/2013)

---

What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have been trained...

I wholeheartedly agree. A small team (even much smaller than 50) could go through loads of small issues which when combined will make SQL Server a much slicker provision. It...

Hi Jeff,

You are most welcome. I am sure I speak for all of us when I say it was a privilege to help you especially considering the huge input you...

DavidL (6/18/2013)

---

paul.knibbs (6/18/2013)

---

There are other reasons for not moving on from a job. My main reason is that I absolutely hate looking for new jobs--I don't like the disruption, I...

I struggled to find somewhere as interested in doing a thoroughly decent job of developing quality software that I ended up contracting (year 15 now). The irony was that my...

All fair points. Maybe I am being a little naive and idealistic.

I find that not always to be the case. Some people could use some decent processes and a little control. I guess it depends on the scenario. More so on...

Craig-315134 (6/17/2013)

---

Perhaps that was Steve Jones' intent, but it could easily be interpreted as a slam against older workers.

Why was age specifically used as an example? Would it have...

Craig-315134 (6/17/2013)

---

Steve Jones wrote:

It may mean that the newest, youngest person at your company might rise much faster than you simply because they're a better DBA or developer.

Sounds a...

Steve Jones - SSC Editor (6/17/2013)

---

But we are immature. Even thought we've been doing this for decades, we run as an unregulated, seat of the pants industry, with little standardization...

Ah yes, good spot:

.GetValue(0) returns the first logical disk requested. Please see the looping above to see that you can ignore this call now.

As for the number of executions you have two choices:

1) Loop through adding multiple inserts to a single command.

$isFirst = $true

$commandText = "INSERT DiskSpace"

$wmiObject = Get-WmiObject Win32_LogicalDisk -computer 'SomeComputerName'

Foreach ($logicalDisk...

Almost, unless I am mistaken you have missed single quotes either side of the comma i.e.

$wmiObject.GetValue(0)["SystemName"] + "','" + $wmiObject.GetValue(0)["DeviceID"]+ "')"

I am sure that you will have come across the...