Rotating Header Image

What Is My Restore Doing?

I love that I can still learn cool new stuff with SQL Server even after 15 years 🙂

I was trying to troubleshoot a problem and got to the point where I was questioning everything I knew about backups/restores because I just couldn’t explain what was going on and why a restore was taking so long to finish.

Then I came across this little nugget of awesomeness to help me along the way:

DBCC TRACEON (3004, 3605, -1)

Don’t worry little birdies I’ll feed ya…

Trace Flag 3004 – This gives you a very detailed explanation as to what your restores (and backups) are doing during execution

Trace Flag 3605 – This will write out the results of your Mgmt Studio query to the SQL Server Log rather than to the results window

The results will look something like this (click to enlarge):

To disable (turn off) these trace flags:

DBCC TRACEOFF (3004, 3605, -1)

If you’d like to chat with me about this or anything else (SQL or other) please leave a comment or hit me up on my Twitter: @ColinStasiuk

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

Happy 2014 SQL Folks!!!

Seems like a year since my last post haw haw haw


But seriously it has been a while and it’s a new year so I guess it’s time I make good on a resolution (or make one in the first place) and blog more.

2013 was a great year and professionally it marked the first year that I was a presenter at the PASS Summit in Charlotte.



On to 2014 and I’m hoping to submit a session in for the 2014 Summit in Seattle.  Last time I submitted 2 sessions, hoping to get 1 and got 2 and was way too stressed that week so this time I’m going to pour my heart into 1 session and hope that the abstract and topic are good enough to make the cut.

I wish everyone a very Happy 2014 and hope to see my #SQLFamily very soon


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

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

PASS Summit 2013 – Keynote Live Blogging and Random Asides

8:04 am – First time at the bloggers table for me… I plan on just copying whatever the people around me are typing.  I really hope Tim Mitchell and Andy Warren write some funny stuff.

So far the big news was already released 🙂 and that is that SQL 2014 CTP2 is available for download…. here.

8:07 am – More big news… Jes Borland is officially the bestest person in the world for bringing me some starbucky goodness.

and the natives are getting restless and finding ways to entertain themselves 🙂


 8:15 – It’s go time (almost)

 8:16 – PASS gets the blogger tables network drops working….. much love!

8:20 – Bill Graziano takes the stage

8:27 – 700,000 technical training hours this past year (between Chapters, SQLSaturdays, 24HOP, and SQLRallys)

 8:30 – PASSion award winner… Amy Lewis!! 🙂 Congratz Amy!!!

8:36 – Quentin Clark going to lay down the roadmap for the Microsoft Data Platform for the next year.

8:43 – “You wanted us to deliver a complete data platform … today’s talk is all about listening to you.” – Quentin Clark

8:45 – Everytime we hear “push the boundaries” we all drink 🙂

8:50 – SQL2014 CTP2 is live and SHOULD be what RTM is (ish)

8:51 – Tracy Daugherty (Program Manager) taking the stage

8:57 – showing off that tables with Columnstore indexes in SQLServer 2014 are now updatable.

9:00 – in-memory technologies are built right into SQL Server 2014.  Not a separate product.  No app migration

 9:05 – “Tools to support backup between all the versions of SQL Server. These tools provide encrypted, automated solutions”

9:10 – Network dies for the keynote demo… twitter explodes hahaha

9:17 – Focus shifting to “Big Data”

9:30 – It’s BI Power Query time 🙂

9:42 – Showing Power BI for Office 365 Preview. You can put in something like “calls per capita by country on a map” and it figured out the query you need and displays it as you wish… very cool.

9:45 – See you tomorrow and thanks for following along!!



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

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

My #SQLFamily and Community Battery is Charging Up!!


Every year around this time I feel so drained when it comes to my extra curricular SQL activities… and every year the PASS Summit rolls around to give that battery a recharge and gets me back excited about everything SQLish in nature.

This year is no exception… I find myself back wanting to blog more and present more and just be the Colin that I love to be.

Not sure what this means going forward but I’m definitely going to have to do my best to see my SQL Peeps more often!!

<3 #SQLFamily <3


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

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

PASS Summit 2013, Bullying, and Stuff

The PASS Summit is fast approaching and it felt even closer this week when I uploaded my PowerPoint slide decks and got the email from PASS HQ that Craig Purnell and I should get ready for the dump of presentations that our team will be going through over the next several weeks.

This is my first time as a member and leader of the PowerPoint review team so I’ll be relying heavily on Craig and his past experience as a review team member to make this a smooth and efficient process for our team.

As a first time Summit speaker I started thinking about how excited/nervous I am for this years Summit.

Excited cause the PASS Summit is awesome and I get to see so many #SQLFamily members who I only see once a year.

Nervous cause this is my first time presenting at the Summit and I hope the SQL community enjoys the sessions that I’m putting on.

I read Tom’s post on Bullies – Not Just On The Playground and it really hit home with me.

If you haven’t given it a read yet I hope that you do.  We have an amazing and supportive community and I hope it continues to be this way for years to come.


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.