Techstravaganza 2012

Today I am getting the opportunity to attend the Techstravaganza 2012 event http://www.techstravaganza.com at Microsoft’s office in NYC.  I hope to pick up a lot of good information on PowerShell and SharePoint.

Read Full Post »

List Sever Reboot Times

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 [...]

Read Full Post »

Using sFTP in SQL Server SSIS

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 [...]

Read Full Post »

Now for a little VB Script

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 [...]

Read Full Post »

Setting Up PowerShell 2010

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 [...]

Read Full Post »

Using PowerShell to map a network drive

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 [...]

Read Full Post »

Using PowerShell to copy files and send via email

I was reading Joe Keohan’s Blog about copying files via PowerShell and that got me to thinking about a process I already had.  Each night we copy files from a shared folder and post them to our intranet site for internal use.  We currently are using a batch file to handle this but I thought [...]

Read Full Post »

Updated PowerShell script to loop through files for printing.

After finishing my script from the previous post I thought there has to be a better way to write this and reduce the lines of code.  Not that 5 separate lines is a lot.  But, if the list of items to print grew larger say to 15 documents, and was in different subdirectories then it [...]

Read Full Post »

Using PowerShell to print pdf files automatically

My office has a series of nightly reports from SQL Server that export as Adobe documents.  The users want them printed and waiting for them each morning on a specific printer.  We had a little utility that could do this (and more) but the problem with it was that the computer running the utility had [...]

Read Full Post »

Get Quarter begin and end dates

This is a script I wrote to use when I need to get the quarter begin and end dates for SQL. declare @date datetime declare @begdate datetime declare @enddate datetime set @date = getdate() --get first day of CURRENT qtr  set @begdate = dateadd(q, datediff(q, 0, @date), 0) --get last day of CURRENT qtr  set @enddate = dateadd(q, datediff(q, 0, dateadd(q, 1, @date)), -1) select @date as today, @begdate as QtrBegin, @enddate as QtrEnd

Read Full Post »