Benchmark IT Consulting Rotating Header Image

Posts under ‘Colin Stasiuk’

sp_refreshview How Did I Forget You?

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

Congrats to Team Canada!!

It’s a rarity for me to blog about something non-SQL Server related but I have to tell you the 2010 Winter Olympic Games were pretty amazing.  Anyone who knows me (or who met me at the Summit last year) knows that I’m a huge hockey fan and I have to give credit where credit is [...]

Rebooting a Server Using PowerShell

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

EDMPASS Meeting – January 27th 2010 #YEG

On January 27th 2010 the Edmonton Chapter of PASS is having it’s next meeting. Details below:
http://www.eventbrite.com/event/503789849
Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks. 
Date:  Jan 27th 2010
Time: 5:00 pm – 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting Room: Centennial Room [...]

A Very Busy January

First off I’d like to say Happy New Year to everyone and extend my congratulations again to all the new MVPs out there… well done and the community is a better place because of people like you.
January is going to be a VERY busy month for me both personally and professionally so I thought I [...]

Twitter links powered by Tweet This v1.6, a WordPress plugin for Twitter.