Monthly Archives: September 2013

date-stamp switch

I have the date.  I have a number of buckets and what to be in each bucket on the right date.  I need a switch statement to assign the bucket membership depending on the date.  that is – On January … Continue reading

Posted in Uncategorized

law school images

The law school wants a “face-book” with images of each student.  I lost the old script files and had some procedures changes (ie, i no longer have db access to the LCMS – i was using existing student enrollment in … Continue reading

Posted in Uncategorized

checking WINRM from powershell

I read a blog post and there was a one-liner (with a pipe in it) to check on the status of WINRM (Windows Remote Management) on remote servers.  The script returned a boolean (True) if successful, and a big block … Continue reading

Posted in Uncategorized

parameter sniffing

When you run a stored procedure,, the first step is to see if the stored procedure is in the plan cache.  Since stored procedures typically have variables passed to them, the entity that is stored does not reflect the specific … Continue reading

Posted in Uncategorized

get-date and semesters

i have a script that runs to create a list of students.  The script will have different outputs for different semesters. Currently, the program reads a configuration file to get the semester, however this year someone (actually NOT me) didn’t … Continue reading

Posted in Uncategorized

datetime

On January 1, i want to do something different.  No, in ADDITION to not being hung-over, i want to change a constant in my program.  I could change it manually, or pull it from a configuration file, but that means … Continue reading

Posted in Uncategorized

logging

There is potentially a need for logging in order to debug and to follow script execution over time.  we can, when developing, use write-output and write-verbose to see what is going on, and when we are running, we can either … Continue reading

Posted in Uncategorized