I was recently working on a Windows Server in my office when I noticed it had not been rebooted in a while. That got me to thinking, how many other servers in my environment had gotten in under the radar and were in need of a reboot. So, I decided to try my hand at [...]
Archive for February, 2012
List Sever Reboot Times
Posted in PowerShell, System Admin, tagged CSV, Powershell, Reboot on February 28, 2012 | 2 Comments »
Using sFTP in SQL Server SSIS
Posted in SQL Server, tagged sFTP, SQL Server, SSIS on February 23, 2012 | Leave a Comment »
On several occasions I have had to use SSIS to export data from a SQL database, and then transfer that data to a third party via sFTP. SQL Server SSIS has an FTP task built in but it does not natively support sFTP. There are several commercial products (Eldos Software, /n Software, CozyRoc) out on the market [...]
Now for a little VB Script
Posted in VB Script, Windows Server, tagged scripting, VB Script on February 16, 2012 | Leave a Comment »
I was going through some old files and thought I would post this one as a good example of using VBScript. I had a request to automate the upload of a file to an FTP site. This example dates back to 2006 so I know there are better ways to do this now, but it is a good example [...]
Setting Up PowerShell 2010
Posted in SharePoint, Windows Server, tagged Common Install Issues, SharePoint2010 on February 10, 2012 | Leave a Comment »
Today I was setting up PowerShell 2010 for testing on a VM and I ran into an issue during the install that is apparently quite common. I had successfully installed the prerequisites and was attempting to install the actual product when I got the following error. Setup is unable to proceed due to the following [...]
Using PowerShell to map a network drive
Posted in PowerShell, System Admin, Windows Server, tagged Login Script, Powershell, VPN on February 3, 2012 | Leave a Comment »
Recently my CFO purchased a new computer for his home office. He wanted to be able to VPN into the office and have access to all of his network shares and applications. After installing all his applications I was trying to decide on how to go about mapping his network drives after he logged onto [...]
