Rotating Header Image

And the Emmy Award Goes To……

Yup…. Something I didn’t know was even on my bucket list just got crossed off (that’s how bucket lists work right? lol).

I won an Emmy Award! (OK so it wasn’t just me that won an Emmy but the company that I contract out to)

Invidi Technologies won an Emmy for “System for Executing Targeted Household Advertising on Linear Television”

Eat your heart out Steve Carell, Courtney Cox, and Jerry Seinfeld (actors who I googled who never won an Emmy lol)

Chances are in you live in the USA and get your TV programming through DirecTV, Dish, Verizon, or Comcast that you have the Advatar software running in your set top box and don’t even know it.

The easiest way to describe the Advatar software is that you and your neighbor could be watching the same show on TV and when a commercial comes on for a holiday experience because you are a family of 4 you may see a commercial for Disneyland but your neighbors who are a single couple with no kids might get a commercial for the Dominican Republic.Β  Pretty cool stuff.

Anyways… I haven’t posted in a while and this was something very cool and something I’m proud of.

I may need to change my twitter handle to @EmmyAwardWinningColinStasiuk …. hmmmm doesn’t quite roll off the tongue πŸ™‚

Thanks!!

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

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

Just Keep Googling, Just Keep Googling…. SQL Agent Job Scheduling (Past and Future)

So I needed a script where I could provide a start and end date that could go into the past and into the future to determine all the job schedule executions that should have or will happen between the given dates.

I found bupkis

My Google-Fu was weak and couldn’t find anything so I pinged the OOBER smart folks on Twitter as I couldn’t be the ONLY person who ever wanted to do this.

This one was a tricky one to find… so tricky in fact that I started writing my own version and had moderate success but was still SO BUGGY.

I started to work through some of my bugs and low and behold I found the holy grail!!

http://weblogs.sqlteam.com/peterl/archive/2008/10/10/Keep-track-of-all-your-jobs-schedules.aspx

Twitter: Peter Larsson

Moral of the story: Don’t stop Googling cause there is a 99.9% chance that you’re not the first person to want to solve a particular problem.

Mr. Peter Larsson I thank you! πŸ™‚

Thanks!!

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

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

Colin’s Oilers Ticket Contest!!!

So this is one of those personal non-geek type of posts so I apologize if this ends up on your feed and you were expecting something SQL-riffic πŸ™‚

Today is my birthday…

and I thought a good win/win scenario to try and get me out of my birthday funk is to do something that I like to do every now and again and give away some Oilers tickets!!!

…. but here’s the catch (sorry… this time there is a catch πŸ™‚ hehehe)

My son Rob is playing in the Stollery Family Day classic hockey tournament to raise money for the Stollery Children’s Hospital.

For those if you that don’t know… I spent a good chunk of my childhood in that hospital back when it was named the Northern Alberta Children’s Health Foundation.

So here’s the deal….

For every person that donates to my son Rob’s Stollery Hockey Tournament page you will be assigned a number.

At 8 PM tonight a random number will be drawn and that person will receive two tickets to the Oilers vs. the Flyers on Feb 16th!!!

$10 gets you 1 number
$25 gets you 3 numbers
$50 gets you 7 numbers
$100 gets you 20 numbers

Click the image below to donate and enter the contest!!!

Thanks!!

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

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

Hey #SQLFamily Where Do You Go?

OK so this video came out like 7 years ago which is pretty well how long it’s been since I’ve blogged.

I miss blogging and the #SQLCommunity #SQLFamily #SQLHelp #SQLPASS…. basically all the hashtags that have anything/everything to do with SQL.

I turned on Tweetdeck for the first time in a LONG time and said a quick “Hello, from the other side”

 

(I’ll spare you the Adele meme) πŸ™‚

 

Low and behold a couple of #SQLBeauties (New Hashtag ALERT) @grrl_geek and @SQLBek remembered me and said hello.Β  <3

So why am I here?

Deep right?

I’m trying to find where my #SQLPeeps (New Hashtag ALERT) are hanging out these days…. twitter seems quiet with the usual suspects of #SQLPASS and #SQLHelp getting the odd post here or there…. have people just stopped tweeting?

Anyways I made a New Years Resolution to get my name back out there and start getting my presenting chops back because I really miss it (and all of you!!!).

If you’re out there…..

Hit me back, just to chat, truly yours, your biggest fan…. this is Colin

 

Thanks!!

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

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

Do You Even Blog Bro? (Stats, Execution Plans, Indexes, and crazyness)

Have you ever worked with a piece of software for like 15-20 years and ended up doing something with that product that you haven’t or can’t remember doing ever before?

joygasm

 

This happened to me quite recently and although I wont have a bunch of sexy scripts for you to reproduce the problem I will go through what I learned/remembered you can do with statistics.

Scenario:

  • Production database at a customer site is choosing an absolutely shitty execution plan (not using an index as expected).
  • Can’t get a backup
  • Don’t want to “cowboy” it up on a live 24/7 $$$$$$ production system
  • Can’t reproduce in development with an old backup that we have on site.

SadPanda

Trying to determine “why” this is happening was proving to be a rat-hole until I came across this:

http://blog.kejser.org/the-ascending-column-problem-in-fact-tables-part-two-stat-job/

specifically the part that said showed that you can run this:


DBCC SHOW_STATISTICS ([TableName], [StatisticsName]) WITH STATS_STREAM

What this UNDOCUMENTED/UNSUPPORTED/BE VERY CAREFUL USING/GREAT POWER BLAH BLAH BLAHΒ is doing is this is actually scripting out your statistics and the histogram

dsjkfjdsoks

 

Now that you have the statistics from (in my case) the production database that I cannot get a backup of, or actively troubleshoot against, etc I can then run the following statement on my development server (which has an older backup of the database in question restored)


UPDATE STATISTICS [dbo].[TableName]([StatisticName]) WITH STATS_STREAM = 0x01000000010000000000000000000000B242E5900000000000038......etc., ROWCOUNT = 159543018, PAGECOUNT = 2904894
GO

And BOOM… we were able to reproduce and establish the root-cause of the issue.

After googling around for blog posts about STATS_STREAM I did find the following as well:

Anyways this was just one of those moments where I got all excited and had that awesome feeling about trying something new and having it work.

Now that SQL Server 2016 is available to download for everyone I imagine I’ll have more “a-ha” moments

Aha

(If you don’t get the reference you’re young and I hate you and get off my lawn!!!)

Thanks!!

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.