Some Background Like most Microsoft installations, ever individual’s experience installing the same piece of software can be very different. I must be special because I […]
Query SQL Server using PowerShell
I don’t understand why it was so difficult for me to find an example on this, so I compiled one from three posts so I […]
Selecting Random Date Between a Date Range with tSQL
I had a very interesting experience recently trying to figure out how to select a random date between a date range using tSQL, it was […]
Extension Methods: Straight to the Point!
I kept looking at many articles on extension methods and for some reason I couldn’t get mine to work. It then dawned on me that […]
How to Iterate Through all Enums from a Class in C#
This took me a good while to figure out. This is specifically for looping through multiple enumerations declared inside of a class. This code would […]
How to connect to a remote SQL Server
I posted about this on Stackoverflow.com http://stackoverflow.com/questions/2486610/how-to-connect-to-sql-server-from-another-computer/6765184#6765184 I think I will revisit this later to find the correct 1 way solution to this problem.
Windows 7: How to locate a task you created in the Task Scheduler
I created a task recently in the windows 7 task scheduler and I couldn’t find my task after I created it. I saw other people […]
How to install sql server management studio 2008 component only
I posted an answer to this question on Stack Overflow here
Multiple Lines to a Single Line using Powershell
#declare a variable to dump a text file into $a #Pipe the file into the variable using the cmdlet tee-object and pump the unwanted output […]