Feb 11th, 2013
by Colin Stasiuk.
SQL Saturday 198 – Vancouver
This weekend I invade Vancouver BC for SQLSaturday 198 (enroute to the MVP Summit in Seattle the following week).
I can’t wait to hit one of the most beautiful cities in Canada. Unfortunately I’m going to be there for less than 24 hours but hey, beggars can’t be choosy.
This is a cool time for me as this is my FIRST SQLSaturday (as an attendee as well as a presenter) and I look forward to seeing so many of my #SQLFamily who normally I only get the pleasure of seeing once a year (at the SQLPASS Summit).
I plan on trying to make it out to more of these events and also trying to get a SQLSaturday going in Edmonton. I’ve had many friends already say they would present for me (which is awesome) so hopefully I can talk to PASS about getting the wheels in motion for hosting an event here in Edmonton.
Have a great week everyone!
Enjoy!! (Follow me on Twitter: @ColinStasiuk)
Posted in: Benchmark IT Consulting, Colin Stasiuk, SQL Server.
Tagged: 198 · Benchmark IT Consulting · Colin Stasiuk · PASS · SQL · SQL Server · SQLSaturday
Feb 5th, 2013
by Colin Stasiuk.
So I hate cats… but this describes me perfectly right now.
Error 3964 on CREATE INDEX on temporary table under SNAPSHOT ISOLATION LEVEL.
I understand the error but what I don’t understand is WHY on a # temporary table (that is tied directly to my SPID) this would be an issue?
I found this: CONNECT ITEM
and the reply from Microsoft was:
“Thanks for reporting it. Some DDL operations that are allowed inside snapshot isolation. For example, CREATE TABLE is ok because it did not exist. However, altering/creating index is not allowed. We are aware of this limitation and will look into it in the future release”
Sweet 
that was back in 2010 and now the connect item has been closed “As By Design” 
I’d love to give you some magical code to get around this issue but unfortunately I can’t. The most you can do with a # temp table is during the definition you can specify a primary key or a unique non-clustered index but that’s it.
Back to the drawing board
Happy Tuesday everyone!!
Enjoy!! (Follow me on Twitter: @ColinStasiuk)
Posted in: Benchmark IT Consulting, Colin Stasiuk, General, SQL Server.
Tagged: Benchmark IT Consulting · Colin Stasiuk · Error 3964 · SQL · SQL Sever
Feb 4th, 2013
by Colin Stasiuk.
I’m excited to officially say I’m “back in the game”
I’ve been wanting to get back into blogging for a LONG time now as it used to be a very rewarding and fun way to share some SQL goodness with whomever decided to check it out.
Trying to find a “comeback” topic is tricky as after a long absence you want something impressive but I decided to avoid trying to hit the homerun post and just get consistent again in my posts.
So if you’re still out there “Thanks for reading” and I look forward to the comments and questions.
Enjoy!! (Follow me on Twitter: @ColinStasiuk)
Posted in: Benchmark IT Consulting, Colin Stasiuk, General, Personal, SQL Server.
Tagged: Benchmark IT Consulting · Colin Stasiuk · SQL · SQL Server
Nov 12th, 2012
by Colin Stasiuk.
I just got back from the 2012 PASS Summit and I am exhausted.
One of the many great things I learned last week is that during the Summit they announced the release of SQL Server 2012 SP1.
I know historically companies have always waited for an SP1 release before really pushing forward with upgrading to a new version of SQL Server. I’ve tried to encourage my customers (who hold this belief) to at least put 2012 in some of their development environments so that when the “safety net” of SP1 comes they will be ready to go and already getting used to the product and new features.
Here is the link to the SQL Server 2012 SP1 download site
Enjoy!! (Follow me on Twitter: @ColinStasiuk)
Posted in: Benchmark IT Consulting, Colin Stasiuk, Release Information, SQL Server.
Tagged: Benchmark IT Consulting · Colin Stasiuk · Edmonton · PASS · SP1 · SQL · SQL 2012 · SQL Server
Oct 31st, 2012
by Colin Stasiuk.
Next week at this time madness will ensue. That madness is the 2012 PASS Summit.
Now I mean madhouse is the bestest way possible as the Summit is the annual event where “SQL geeks” from around the world invade Seattle and drink from the firehouse of SQL goodness.
There have been numerous amazing posts on how to best prepare if it’s your first Summit experience so I’m not going to rehash the goodness that’s already out there.
For me I’m looking forward next week to catching up with the amazing #SQLFamily that I sadly don’t get to see as often as I would like being from Canada.
I have so many amazing memories of my previous 3 Summits and I can’t wait to see everyone.
HAPPY HALLOWEEN!!!
(My son and I did Mjolnir as he is Thor for Halloween and my wife and daughter did Ariel cause well…. they’re girls LOL)
Enjoy!! (Follow me on Twitter: @ColinStasiuk)
Posted in: Benchmark IT Consulting, Colin Stasiuk, PASS, SQL Server.
Tagged: Benchmark IT Consulting · Colin Stasiuk · PASS · sqlpass · Summit 2012
