below86 (3/27/2014)

---

I was once fired, on a Monday morning when I first came in. Now they had to know Friday before that, so why not do it then? ...

Although there are differences in the various employment legal systems around the world, I think there is a world of difference between being made redundant (losing the job because the...

I have almost always left on good terms except once. Most people will want to do so even if it is through gritted teeth as sometimes friction develops in a...

Steve Jones - SSC Editor (3/26/2014)

---

Gary Varga (3/25/2014)

---

I use the connection colour option in SSMS. See 'Use custom color' and set up registered servers using the desired colours. I tend...

SQLRNNR (3/26/2014)

---

skanker (3/26/2014)

---

While I can understand companies not keeping up with latest software versions running a website like this on 11 year old technology must be a big risk. ...

Like functional testing, documenting and performance testing I guess security was an afterthought too. Unprofessional.

n.arley.dealey (3/25/2014)

---

Premature optimization is the root of all evil!

I’m not a DBA. In fact, it’s been a long time since I’ve been a developer, but learning the little aphorism above,...

Have you tried:

$instanceNameList = invoke-Sqlcmd

-query

"SELECT [server_name] as Name

FROM [msdb].[dbo]

...

Manic Star (3/24/2014)

---

LSAdvantage (3/21/2014)

---

I have chuckled about this several times already today! This is great!

As...

I am not a DBA but it is a DBA horror story.

Working on a development project a long time ago in a company far, far away, the development team asked...

PHYData DBA (3/20/2014)

---

In the last ten years I Have had the pleasure to work.

With at least four different offshores that demanded real copies of databases to use in the development...

Steve Jones - SSC Editor (3/20/2014)

---

Jim Youmans-439383 (3/20/2014)

---

I use to want to know how my data was secured and make sure it was not being put at risk. Use...

Please forgive me going through each element as I am doing this for anyone who reads this post's thread.

1) Return all the files and directories in the directory "C:\Source Directory\"...

This might work:

Get-Items "C:\Source Directory\*.xml" | ForEach-Object {Convert-SqlServerInventoryClixmlToExcel.ps1 -FromPath $_.FullName}

The above statement I wholeheartedly agree with.

The...