30Aug 2010 by Grant Fritchey 4 Comments

Upcoming Presentations: #24HOP & #SQLSAT46

PASS
Blogging has been a bit quiet of late. That's because I've been spending a lot my spare time getting ready for presentations that I have to give. Two of them are in about two weeks. First, and this one is going to be a big deal, is 24 Hours of Pass: Summit Preview. At the PASS Summit this year I have two spotlight sessions, both on tricks and tools for tuning queries, one on using execution plans and the other on using DMVs. Since the 24HOP presentation is supposed to be a lead-in to the PASS presentations, I decided that before you started tuning queries, you need to know which queries to tune. The presentation is titled: Identifying Costly Queries. I understand there are already nearly 2000 people registered. Let's…
Read More
23Aug 2010 by Grant Fritchey 4 Comments

PASS Elections

PASS
There are a lot of things I'd like to say about the PASS elections. I was on vacation last week when the news about the slate of candidates broke. I've gone through a lot of emotions thinking about this, which is funny, because, really, what does it matter? But, because of the people, and let's face it, PASS is nothing without the people involved, it does matter. But, I've decided to say as little as possible because I'm not convinced I can add constructively to the conversation and that is what is most needed at this time. First, I want to endorse a few candidates. The people I'm going to endorse, I'm endorsing because I know them personally. I've worked with them, I've talked to them, I've read their stuff.…
Read More
11Aug 2010 by Grant Fritchey No Comments

Viva Las Vegas!

SQL Server, T-SQL
I won't be going to Las Vegas, but I will be presenting to the Las Vegas SQL Server Users Group, S3OLV. The sesssion will be "Introduction to Execution Plans." Please swing by if you're in the area. I'm not sure if they'll make the LiveMeeting available to the public or if they'll record the session. But if they do, please attend that way too.
Read More
11Aug 2010 by Grant Fritchey 3 Comments

24 Hours of PASS: Summit Preview

PASS, T-SQL
Registration is open for the second 24 Hours of PASS this year. This one is going to be a preview of the Summit itself. So all the sessions are tied, in some manner, to sessions being given at the summit.Here's a link to go and register. I'm very excited to be able to say that I'll be presenting in this 24HOP. One of my presentations at the Summit this year is Identifying and Fixing Performance Problems Using Execution Plans. It covers pretty much what it says, methods for fixing performance problems by exploring the information available within execution plans. But, how do you know you have a performance problem? That's where my preview session comes in. Identifying Costly Queries will show you several ways to gather metrics on your system so that you…
Read More
01Aug 2010 by Grant Fritchey 6 Comments

A Milestone

Uncategorized
I just passed 100,000 views on the blog. That's from 400 posts over a period of time starting in March of 2008. You guys have posted 1129 comments. The average views per week went from 39 in 2008 to 160 in 2010. I realize others out there are hitting 100,000 a week, but for some of us small time bloggers, this is a big deal. I just wanted to say thanks for stopping by and I hope my attempts at understanding SQL Server, PowerShell, SCOM, spatial data, Visual Studio, ORM and whatever else I've posted about has been helpful in some way.
Read More