19Dec 2011 by Grant Fritchey 2 Comments

PASS Summit 2012 Evaluation Results

PASS, Professional Development
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not indifferent), feedback is a wonderful gift. Any time you appreciate a speaker, give them feedback. Any time you think a speaker could improve, give them feedback. Any time you hate a speaker, give them feedback. It’s really the best thing you can do. With that in mind, I have a huge stack of gifts in front of me here, the evaluations from the PASS Summit.Thank you very much to each and every one of the 160 different evaluations I received. I presented three times at the summit, once on a pre-con with Gail Shaw called “All About Execution Plans,” one time in a spotlight session called “DMOs as a Shortcut…
Read More
14Dec 2011 by Grant Fritchey No Comments

SQL Saturday #104: Colorado Springs

Professional Development
I’ll be presenting at the Colorado Springs SQL Saturday on January 7th of 2012. The session is called Seven Ways to Fix Bad Parameter Sniffing. Please, if you’re in the area, register and come to the event. There are going to be some truly excellent speakers there. There is also evidently skiing on Sunday, although I won’t be taking part in that.
Read More
12Dec 2011 by Grant Fritchey 11 Comments

Changes to SQL Server 2012 Execution Plans

Uncategorized
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations. Here’s an example from SQL Server 2008R2: You can see cool stuff like the size of the plan, the time it took to compile, the optimization level, the reason for early termination. Many of the properties on…
Read More
09Dec 2011 by Grant Fritchey 3 Comments

#sqlfamily

Professional Development
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a single better cause to throw some support behind. Not one. They’re going to donate money based on posts about #sqlfamily. Well done to Brian Knight (blog|twitter) and all the team at PragmaticWorks. I knew you were great people, I just didn’t know how great. Thanks to Microsoft and the SQL Server Team for their support of Brian. Oh, and for all the work you guys do with SQL Server. I may bitch about you guys more than you’d like, but it’s only because I live inside your software, constantly. I wouldn’t be there all the time if you didn’t do great work. Keep it up. We can talk about this…
Read More
06Dec 2011 by Grant Fritchey 1 Comment

SQL Connections Fall 2011 Speaker Evaluations

Misc
In keeping with the past, I’m going to go ahead and post my evals for the two sessions I did at Connections in Vegas back in November. It was a mixed conference for me. The first session I had ~80 people. The second session I had 9. Yeah, weird. But there were great speakers there (as usual) so I’m hardly shocked that I had low attendance, but the funny thing is I expected the sessions to be reversed. The low one was the session I lavished love & attention on. The high one wasn’t given as much of my focus. Figures. Here are the evals. I love how Connections shows the high, mean and low so you get a sense of how you fit. SQL Server Optimization Checklist (36 responses)…
Read More
05Dec 2011 by Grant Fritchey 1 Comment

Resolutions: Outcome

Professional Development
Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked by Jen McCown (flat out, one of my favorite people, blog|twitter). It was supposed to be about resolutions, but I just don’t make those. I make plans. Here we are, close to a year later (11 months). How did the plans work out? The first one, hinted at the time, was to start a new job. Well, that’s done and it’s going swimmingly, thank you very much. The job has turned out to be harder than I thought it was going to be. I travel more than I thought I was going to travel (although we’re keeping it within the limits we agreed to, I love my new company). Frankly,…
Read More