Rotating Header Image

SQL Bacon Nugget of Excellence Award @SQLPoolBoy

Not sure how I haven’t seen this before but I’m hopefully not the only one out there.

The AdventureWorks2008R2 Books Online Random Workload Generator

The PowerShell script will take a random query (from the Books Online example SELECT statements) and run them with a configurable delay inside an infinite loop.

You can run as many of these PowerShell scripts as you want concurrently and BOOM you have random workloads.


I became a Jonathan Kehayias ( twitter | blog ) fan originally for his awesome Extended Events posts (as you can tell by the photoshopped pic below) but over the years his blog posts and presentations have always impressed.

Thanks Jonathan!!

Prior Winners:

Enjoy!! (Follow me on Twitter: @ColinStasiuk)

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

My First MVP Summit

WOW… that’s the only way to describe the past week.

I had the pleasure of speaking at my first SQLSaturday in Vancouver (which went really well I think) and I attended my first MVP Summit.

I can’t say enough about how Microsoft treated us last week and the level of information that was provided.  SO COOL.

Once again my #SQLFamily came through with flying colors and made me feel right at home as I was quite nervous to not seem like such a newbie and a dumbass :)   It very much reminded me of my first PASS Summit and that feeling initially of just not belonging or not being smart enough to be there.  Just like my first PASS Summit, Tom LaRock ( @SQLRockstar ) found me and immediately started introducing me around and was a solid “wingman” all week.

I had the pleasure of rooming with Jason Strate ( @StrateSQL ) and bounced ideas for presentations off of him and even was able to sit in and watch as he presented virtually for his company Pragmatic Works.

Much like the PASS Summit, the MVP Summit has a way of recharging your batteries and getting you excited about everything all over again.

It was a great week and I have 3 new presentations on the go so get ready #SQLPASS Chapters… I’ll be looking to bounce some new content off of you before the PASS Summit 2013 where I am officially throwing my hat in the ring and submitting to be a speaker.

Enjoy!! (Follow me on Twitter: @ColinStasiuk)

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

SQLSaturday #198 – Vancouver

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)

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

Error 3964 – Angry Cat

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)

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

Tap Tap Tap…. Is This Thing On?

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)

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

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