Monthly Archives: March 2012

Collection of scripts

Recently I started contributing scripts to the community by uploading some of my scripts to the Technet Script Repository. Today I would like to highlight two of the scripts I have uploaded.

Delete files older than x-days – Cleanup Script

This script delete files older than x-days. The script is built to be used as a scheduled task, it automatically generates a logfile name based on the copy location and the current date/time. There are various levels of logging available and the script can also run in -listonly mode in which it only lists the files it would otherwise delete. There are two main routines, one to delete the files and a second routine that checks if there are any empty folders left that could be deleted.

PowerShell function to run as a different user

Script with both both the ability to set and get. When the Set switch is specified the script will prompt for credentials and write the password to the file file specified. When the script is running with the Get switch the script will read the password from the file specified in the $filename variable and use the username specified in the $username variable. This allows you to runas another identity without having to enter credentials.

For a complete listing of all scripts I have published please have a look at the Technet Gallery I have published other scripts there as well and I will be happy to answer any questions you have about them.


SQL Server 2012 beta exams are available

Last week I received an invitation from Microsoft Connect for the beta exams and recently the promotional codes also have been posted on the Microsoft Learning Blog. So if you have been working with SQL 2012 and feel you have a shot at passing the exams you could try one of these promotional codes for a chance to participate in the Beta exam process. The exams run from the 23rd of March to the 13th of April. I have included the second unofficial list of codes in the table, so try both codes if it reports that the maximum number of seats has been booked.

Exam number

Promo code

2nd code

Exam 70-461: Querying Microsoft SQL Server 2012



Exam 70-462: Administering Microsoft SQL Server 2012 Databases



Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012



Exam 70-464: Developing Microsoft SQL Server 2012 Databases



Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012



Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012



Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012