11Aug 2011 by Grant Fritchey 7 Comments

Google + Hangouts

Professional Development
I just finished hosting my third hangout on Google Plus. I’ve also attended one hosted by Andy Leonard (blog|twitter) and one hosted by Tom LaRock (blog|twitter). I am blown away by how useful these things are. I’m actually struggling to try to put it into words. This may be something of a ramble. Jorge Segarra (blog|twitter) brought it up during the conversation this morning, you can’t know everything. You can’t. So what do you do when you’re hitting an issue that you can’t solve because you just don’t have the knowledge? Well, you contact someone who does have that knowledge. You work your contacts and your network and track down the information, because someone you know either knows that bit of information or they know someone else who does. That’s…
Read More
10Aug 2011 by Grant Fritchey 1 Comment

Denali & CTP 3

Uncategorized
I have Denali installed on a virtual machine on my laptop and I’m working through evaluating it. Actually, I’m working on writing two books using it as the source for the books. But it’s something of a slog, figuring out what’s new, finding out how the new stuff works, seeing if the old stuff broke. Microsoft just released a new guide for doing Denali evals. It’s worth checking out. It might help you short-circuit that discovery process just a little.
Read More
08Aug 2011 by Grant Fritchey 8 Comments

Droid Apps

Misc
A friend of mine recently got his first smart phone, an Android. My wife has also recently moved into the world of smart phones, again, an Android. I’ve been working with Android for a year now and loving it, and not even remotely non-vocal about it. I even picked up a Droid tablet, an Asus Transformer (which I LOVE). My advice on apps has been solicited a few times. I forwarded the most recent request to G+, Twitter & Facebook. Funny thing is, I’ve installed a ton of apps and then uninstalled most of them. There are only a few that I’ve found really, really useful. Note, this is beyond the basic stuff that comes with the phone, email, web browsing, maps, navigation, calendar, etc. That stuff is wonderful. I’m…
Read More
03Aug 2011 by Grant Fritchey 1 Comment

All About Execution Plans

PASS
If you’re attending the PASS Summit this October, I’d like to make a suggestion. The Summit itself is only three days long, Wednesday to Friday. But, if you have to travel any distance to get there, you’re going to miss work on Tuesday as well. Why not take a whole week away and spend Monday with Gail Shaw (blog|twitter) and me? The reason I ask is because Gail and I are putting together 7 hours of information all about execution plans. We’re going to be presenting this information on Monday at the Summit as a pre-conference seminar. Yes, you’ll have to pay extra to attend this session. But if you register for the Summit now, there’s still a discount, which you can put towards to the seminar. And, seriously now,…
Read More
26Jul 2011 by Grant Fritchey 4 Comments

Strengths Finder 2.0

Misc
I’ve made the commitment to read and review 12 books over 12 months as a part of continuous personal development. This is my second book. While this is a book review, the first thin you need to know is that the Strengths Finder 2.0 book is actually just a written, in-depth, support document for the test that you take on the StrengthsFinder web site.The core idea to the test and the book is to identify your strengths and work on them instead of spending all kinds of time trying to fix your weaknesses. If you just think about it a little bit, it makes sense that you can spend days and weeks trying to improve in an area where you are not terribly strong while improvement in areas where you…
Read More
05Jul 2011 by Grant Fritchey 1 Comment

PASS SQL Rally 2011 Evaluations

PASS, SQL Server, T-SQL
  In keeping with the all my other major speaking engagements, I’m posting the results of my pre-con and session evals at the first-ever SQL Rally. I’m posting this really late and I apologize. The good news, I did a fill-in when someone cancelled and I was placed in the Grab Bag category where I had the highest rated session although it was a far cry from the actual highest rated sessions from the whole Rally. There is no bad news. Query Performance Tuning: Start to Finish I was pretty happy with this considering it’s my first, public, all day training class. I’m even happier with the feedback. I received some excellent constructive criticism that I will attempt to take into account when I present in the future (including at…
Read More
27Jun 2011 by Grant Fritchey 2 Comments

Presentations in Action

Misc
The first book I read for my 12 goal oriented books was Jerry Weissman’s Presentations in Action: 80 Memorable Presentation Lessons from the Masters. Up front, let me say, this book met my expectations. I expected to see a lot of things I already knew. I expected to learn a few new things. What I didn’t expect was more books for my reading list. The book is broken down into 80 little stories and these are grouped into five sections talking about Content, Graphics, Delivery Skills, Q&A (dealing with it, not your questions), and Integration. The sections made a lot of sense even if a couple of the stories felt like they had been sort of shoe-horned into the section. Most of the stories made a lot of sense, and…
Read More
20Jun 2011 by Grant Fritchey 9 Comments

Make the Optimizer Work Harder

SQL Server
One of my favorite indicators for whether or not you have a good execution plan is when you see the “Reason for Early Termination” property in the TSQL operator like this: The optimizer considered this particular plan “Good Enough.” which is what you want to see. When you see “Timeout” as the reason, that’s an indication that the plan you have may be sub-optimal. The question is, can you make the optimizer spend more time on your queries. Well, actually, the question is, should you make the optimizer spend more time on queries. During my session on SQL Cruise I answered the original phrasing of that question, no. As usual when I present in front of people smarter than I am, I was wrong. Brent Ozar (blog|twitter) pointed out that…
Read More
15Jun 2011 by Grant Fritchey 9 Comments

Rebind and Rewind in Execution Plans

T-SQL
Ever looked at an execution plan? If you answered no, you can’t possibly have ever tried to tune a query, or, you’re doing it wrong. For every one else, no doubt you’ve looked at the tool tips or the property sheets of an operator and you’ve seen the Rebind & Rewind properties and wondered what the heck they mean. Me too. I learned as much as I could for the book on execution plans and I spent two pages describing it. Then, a little while ago, on the SQL Cruise, someone asked me to describe them and I was flummoxed. Specifically they said the explanation in the book was insufficiently clear, so I promised to put together a blog post on the topic, both to attempt to clarify my explanation…
Read More
13Jun 2011 by Grant Fritchey 5 Comments

Time for a Little PD

Misc
No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I know that’s not 100% accurate, but I need a hook on which to hang this lesson). Knowledge workers either develop more knowledge or become buggy whip manufacturers. It’s that simple. Keep moving/learning or die/become obsolete. I’m voting for continuing to learn. In keeping with this, during SQL Cruise Alaska (I’ll be posting more on my thoughts about the trip), I was privileged to sit through Buck Woody’s (blog|twitter) presentations on “Three C’s on the High Seas.” Buck is a great teacher and not at all afraid to hand out homework, which he did before and during the cruise. Confession time, I did fail to do one pre-cruise assignment and Buck…
Read More