Most Valuable Yak (Rob Volk) Blog

…and other neat SQL Server tricks

PASS Summit Speaker Idol 2018: Part 1: The Lyrics & Video!

HOLY COW!! I was once again selected to participate in Speaker Idol at PASS Summit, and I advanced to the final! Many thanks to PASS for providing the Speaker Idol sessions, and even more thanks to Denny Cherry for originating, arranging and hosting the event for all these years. Read more →

PASS Summit Speaker Idol 2017

I’m extremely honored to have been chosen once again to participate in Speaker Idol at PASS Summit 2017! I’m in deep trouble too, considering the contestants this year: https://www.dcac.co/syndication/your-pass-summit-2017-speaker-idol-contestants-are I’ve previously blogged about why Speaker Idol is such a great opportunity: http://weblogs. Read more →

T-SQL Tuesday #72: Data Modeling

It's that time again: T-SQL Tuesday! This month the lovely and amazing Mickey Stuewe (b | t) is hosting and asks us to write about the trials and tribulations of data modeling. Read more →

Notes from Speaker Idol 2014

When last I blogged, I recommended everyone who was eligible to sign up for PASS Summit Speaker Idol 2015. The contestants have been announced: http://www.dcac.co/your-pass-speaker-idol-2015-top-12-are They also announced the judges in case you want to try the bribery route: http://www. Read more →

PASS Speaker Idol 2015

In 2014, PASS offered a new type of session at their Global Summit event: Speaker Idol. Initiated by Denny Cherry (b | t), the concept is: To provide an opportunity for community speakers Who haven't yet presented a regular session at PASS Summit A chance to present to a panel of judges - like American Idol, but without singing. Read more →

T-SQL Tuesday #53-Matt's Making Me Do This!

Hello everyone! It's that time again, time for T-SQL Tuesday, the wonderful blog series started by Adam Machanic (b|t). This month we are hosted by Matt Velic (b|t) who asks the question, "Why So Serious? Read more →

Full-text Indexing Books Online

While preparing for a recent SQL Saturday presentation, I was struck by a crazy idea (shocking, I know): Could someone import the content of SQL Server Books Online into a database and apply full-text indexing to it? Read more →

Criminals and Other Illegal Characters

SQLTeam's favorite Slovenian blogger Mladen (b | t) had an interesting question on Twitter: http://www.twitter.com/MladenPrajdic/status/347057950470307841 I liked Kendal Van Dyke's (b | t) reply: http://twitter.com/SQLDBA/status/347058908801667072 And he was right! This is one of those pretty-useless-but-sounds-interesting propositions that I've based all my presentations on, and most of my blog posts. Read more →

SQL Saturday #220 - Atlanta - Pre-Conference Scholarships!

We Want YOU…To Learn! AtlantaMDF and Idera are teaming up to find a few good people. If you are: A student looking to work in the database or business intelligence fields A database professional who is between jobs or wants a better one A developer looking to step up to something new On a limited budget and can’t afford professional SQL Server training Able to attend training from 9 to 5 on May 17, 2013 AtlantaMDF is presenting 5 Pre-Conference Sessions (pre-cons) for SQL Saturday #220! Read more →

SQL Saturday #162 Cambridge

Despite the efforts of American Airlines, this past weekend I attended the first SQL Saturday in the UK! Hosted by the SQLCambs Chapter of PASS and organized by Mark (b|t) & Lorraine Broadbent, ably assisted by John Martin (b|t), Mark Pryce-Maher (b|t) and other folks whose names I've unfortunately forgotten, it was held at the Crowne Plaza Hotel, which is completely surrounded by Cambridge University. Read more →

T-SQL Tuesday #34: Help! I Need Somebody!

Welcome everyone to T-SQL Tuesday Episode 34! When last we tuned in, Mike Fal (b|t) hosted Trick Shots. These highlighted techniques or tricks that you figured out on your own which helped you understand SQL Server better. Read more →

Throw Things at Me…In Person!

I have a few speaking engagements coming up in July. I will be getting my Revenge on twice this week, first at the Steel City SQL User Group in Birmingham, Alabama July 17, 2012: Read more →

T-SQL Tuesday #31 - Logging Tricks with CONTEXT_INFO

This month's T-SQL Tuesday is being hosted by Aaron Nelson [b | t], fellow Atlantan (the city in Georgia, not the famous sunken city, or the resort in the Bahamas) and covers the topic of logging (the recording of information, not the harvesting of trees) and maintains the fine T-SQL Tuesday tradition begun by Adam Machanic [b | t] (the SQL Server guru, not the guy who fixes cars, check the spelling again, there will be a quiz later). Read more →

SQLBits - Unicode Porn

We've just finished up a fantastic event at SQLBits X in London! If you've never been to SQLBits and you can make it to the UK, I highly recommend it. If you didn't attend, here's what you missed. Read more →

T-SQL Tuesday #025 – CHECK Constraint Tricks

Allen White (blog | twitter), marathoner, SQL Server MVP and presenter, and all-around awesome author is hosting this month's T-SQL Tuesday on sharing SQL Server Tips and Tricks. And for those of you who have attended my Revenge: The SQL presentation, you know that I have 1 or 2 of them. Read more →

Queerie Memoree Spils

Did you know that if you run a query in SQL Server, and it processes it as a hash match, and there's not enough memory to fully process it, the memory will spill to disk? Read more →