I went for the last solution in your post. I read them thoroughly, and this last solution turned out to work with minimal changes to my existing code. Thanks!!!

@HanShi, thanks for the link to the article. I think this may be it in my case, so I'll be reviewing this further.

What if I create a transaction on the table and leave it uncommitted, will this cause a timeout in the script when trying to connect? If so, will this only...

Ed Wagner (6/17/2016)

---

Do you know the root cause of the failure? Knowing when it fails is one thing. Like Michael said the real goal should be finding the...

Michael L John (6/16/2016)

---

Not sure that I ever had a database server get a case of the hiccups!

My opinion would be to find the root cause, and fix that. ...

The connection failures seem like hiccups. So the idea for looping was to loop for some time, and finally exit and notify if it fails to make the connection. And...

No. I'll be converting the CSV to XLSX for delivering reports.

Good morning Guys,

Thanks for your input. Federico's suggestion for using import-csv is what I ended up using. However, that adds a first line to the file that reads:

#TYPE System.Management.Automation.PSCustomObject

So in...

Some web development may be required. And/or maybe some local scripts to pull the data from the API. Here's one I found with a quick search on Bing: http://openweathermap.org/API.

My personal...

j-1064772 (5/4/2016)

---

For "older" social security numbers, the range is LESS than the theoretical 1 billion numbers.

According to Wikipedia, the US Social Security Number does NOT include a check digit dependent...

Sergiy (5/1/2016)

---

By using bigint here you're gonna just waste the system resources.

You may have 4 records in your database per every possible SSN number and still...

Ok, if anyone here has the time and/or patience to review my final thoughts on this issue, here it is. I think this will be the final approach (please disregard...

Is there something missing here? Is this an assignment? What're the guidelines for output? I'm not seeing a pattern in the output.

Sergiy (4/28/2016)

---

http://opendata.stackexchange.com/questions/5595/how-should-us-ssn-be-anonimized

Since SSN has only 9 digits, changing hash function will not suffice because attacker can simply apply the function to all 10^9 SSN's and match the result against the...