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
30Nov 2011 by Grant Fritchey No Comments

PASS Board Elections

Professional Development
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look these people over, weigh them, and vote well. Things are running a little different this year. The elections are being held between the 6th and the 20th of December. The PASS Community is an amazing thing and these people are going to potentially improve it, maintain it, or degrade it. If you’ve attended any of the 24 Hours of PASS, the PASS Summit, SQL Rally, SQL Saturday, your local user group, and you’ve received something positive from any or all of them, then you’ve seen the benefits of the Professional Association for SQL Server. If you want to see PASS improved, or at least maintained, then it’s up to you…
Read More
21Nov 2011 by Grant Fritchey 3 Comments

Installing SQL Server 2012 RC0

Uncategorized
Very short informational post. If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server Denali, uh, I mean 2012, then the news about the release of RC0 is pretty exciting stuff… until you realize that you’re going to have to tear down your virtual test machine, removing the CTP in order to prep for the install of RC0. I love playing with the toys, but I hate working on the toys, if you know what I mean. Great news. You can upgrade from CTP3 to RC0 in place. I know because I’ve done it. When you run the install and you get to the screen that asks what type of install you want, select Upgrade, as highlighted below: I know it doesn’t say…
Read More
18Nov 2011 by Grant Fritchey No Comments

Thank you

Misc
I somehow made the Top 10 Community Choice Bloggers in the SQL Server Magazine 2011 awards (keep scrolling to the bottom). This was evidently a write-in list and some of you who read my rambling attempts to understand this SQL Server stuff thought enough to actually write down this blog. I’m completely and utterly gobsmacked, humbled, surprised… and yeah, happy. #6 …. Wow! Thank you. Gotta go get some posts written now.
Read More
07Nov 2011 by Grant Fritchey 2 Comments

Meme Monday: SQL Family

Professional Development
Tom LaRock’s (blog|twitter) question this month: What does #sqlfamily mean to me? Wow… Geez Tom, couldn’t you ask a hard question for once? Hmmm… Just saying #sqlfamily and a whole series of images of people flashes through my head. And those images are accompanied by all sorts of fun, amazing, interesting situations. And you know what, they’re all very positive. I don’t have flashes of people I dislike or bitter acrimony or really strange relationships. In short, maybe it’s not a family. I have a huge, complex, and very extended real-life family. When I compare that to my #sqlfamily, parts of the real family don’t shine quite so bright as that #sqlfamily does (parts, of course, shine brighter, I love my family). The #sqlfamily is impressive. I get so much…
Read More