Mar 3rd, 2010
by Colin Stasiuk.
So a developer asked me a question about how he added a column to a table and now the view that referenced the table wasn’t showing the column. I asked the obvious question: “Did you add the column to the view?” to which he replied “The view is doing a SELECT *”
OK it may not [...]
Feb 1st, 2010
by Colin Stasiuk.
The more I work with PowerShell the more I love it
So what do you do if you’re in a VM environment and you want/need to reboot your server but you can’t connect via RDP and you can’t connect to the console using the VM Infrastructure Client, and all other attempts to connect just [...]
Dec 30th, 2009
by Colin Stasiuk.
I’ve seen a few of these types of posts over the last week or so and I figured I should publish something on the intertubes that would be something to look back on come next year at this time. Tom LaRock had a very interesting spin on things (as he always does) and added a [...]
Nov 24th, 2009
by Colin Stasiuk.
OK maybe I’m feeling really good today… maybe it’s because it’s @Peschkaj’s birthday… maybe it’s because I needed to find a way to work some Tina Turner into my next blog post…or maybe it’s because I successfully took care of both kids last night for the first time while wifey started some photography [...]
Aug 13th, 2009
by Colin Stasiuk.
So have you ever had one of THOSE days?
So I’m finishing up building a shiney new SQL Server 2005 Instance and I start configuring Database Mail. Everything is going fine and once it’s setup I do a “Send Test Email”. I get the email in a couple seconds so for my final test I create [...]