I am not convinced that using PowerShell for these scenarios is applying the most appropriate tool. I am certain that given any description I provide that someone could come up...

One aspect that is often overlooked in DR is the restarting of applications. Certainly application reinstallation is often thought of but sometimes what is missed is that there will be...

I think that the first version should be a simple (as per Einstein's definition) set based query that resolves the business question. Of course, this assumes that it is a...

I do fear that, whilst the 90s moved towards greater software engineering practices, since the popularity of the www that there has been a return to the hack and slash...

I am a long time fan of PowerShell but we must also realise that we should be applying the right tools for the right jobs. I have seen examples of...

I am at the whim of my clients. I can recommend, request as well as try to cajole but at the end of the day I am often not allowed...

I find that the shift from something as core to an IT department such as a RDBMS or OS takes a long time. In general there appears to be the...

Sometimes the perception of competition, or rather the perception of alternatives existing, is more of a comfort blanket than a reality. This is often a fallacy as you just have...

It cannot be forgotten that sometimes maintainability must take an equal footing to performance. For some, being able to adjust a system to ever changing business rules is as important...

Replace

$SqlCmd.CommandText = "select f.physical_name from sys.master_files f, sys.databases d where f.database_id = d.database_id and

d.name = 'master'"

With

$SqlCmd.CommandText = "select f.physical_name from sys.master_files f, sys.databases d where f.database_id = d.database_id and

d.name =...

You are most welcome - makes a change for me being the helper as opposed to the helped!!!

When using double quotes (") PowerShell looks to replace variables with their values whereas if you use single quotes (') it does not. So as you used double quotes it...

Ross McMicken (4/22/2013)

---

Gary Varga (4/22/2013)

---

Gary Varga (4/22/2013)

---

Clearly if Steve had written a poor editorial he wouldn't be putting it down to the tool he wrote it in.

Has Word ever won...

Gary Varga (4/22/2013)

---

Clearly if Steve had written a poor editorial he wouldn't be putting it down to the tool he wrote it in.

Has Word ever won a Pulitzer or Excel...

Steve Jones - SSC Editor (4/22/2013)

---

Gary Varga (4/22/2013)

---

I also think that we are going to have learn to throw away more data too. This will probably be a rough road...