25Oct 2010 by Grant Fritchey No Comments

SQL Rally Voting

Uncategorized
I received word over the weekend that my precon application had made it past committee and was now subject to the community vote. They haven't posted it yet, but please watch this space. I'll be doing an all day session on how to tune sql queries, from monitoring to establish a baseline, to figuring out what's wrong with the query and how to fix it. If that sounds interesting, please vote for my session.
Read More
25Oct 2010 by Grant Fritchey No Comments

Who You Learn From

PASS
Less than two weeks to go until the PASS Summit. I'm excited. I've managed to cram a ton of activities into this Summit, more than ever before. But, I'm still going to try to go to a few sessions. The question asked, which sessions are you going to? Who do you want to learn from. Who can you learn from? I've got a pretty simple answer. Everybody. There's not a single person that I work with on my current team that I haven't learned something from. Sure, there are those that teach you tons and tons, for example, we have a fantastic SSIS guy on our team, that has taught me quite a lot, faster than I could have picked it up on my own. So, you're going to the…
Read More
20Oct 2010 by Grant Fritchey 5 Comments

Kilt Day at the PASS Summit

PASS
Last year, with the infinite power at my disposal (read, zero), I declared Wednesday, Kilt Wednesday at the PASS Summit. It took off... a little ways. Three people wore kilts. Now, you'd think that three out of 3000 would almost not get noticed, but the three people wearing them... well, each for different reasons, we stand out in a crowd. Heck, I was even told one of us looked good in the kilt (wasn't me, of course). Anyway, where was I, oh yeah, we were noticed (and it might be because I jumped up on the bloggers table during one of the the key notes...) and now, this year, LOTS of people are planning on wearing kilts on Wednesday, November 10th, 2010. If you don't have a kilt, don't panic. You can always…
Read More
19Oct 2010 by Grant Fritchey 1 Comment

Upcoming Speaking Engagements

PASS
I've got a couple of more sessions before the big two at the PASS Summit. Tomorrow night, October 20th, I'll be speaking at the Southern New England Network Users Group on SQL Server Best Practices. It's the first time I've talked on this topic, so it might be fun to watch. After that I'm previewing one of my two Summit presentations for Brian Knight (blog|twitter) and Pragmatic Works in a webinar on Identifying and Fixing Performance Problems Using Execution Plans. Go here to register. After that, it's off the PASS Summit.
Read More
18Oct 2010 by Grant Fritchey 13 Comments

Powershell is Really Easy… If you know what you’re doing

PowerShell, SQL Server
Sigh... I just spent almost a full work day trying to come up with, what turned out to be a single line script. The requirements were simple. After patching of servers is completed, and everything is rebooted, sometimes, not often, but sometimes, SQL Server Agent doesn't restart correctly. I was asked to put together a script that will check a list of servers to see if Agent is running. Any PowerShell guru's reading this are either laughing or crying, already. So, I started exploring how to connect to the server using using some type of PS-Drive, but I quickly figured out that I'd have to loop through the servers that way. Plus, I don't think there's a way to check Agent status through the SQL drive. So that went out…
Read More
14Oct 2010 by Grant Fritchey 4 Comments

Working the Door

PASS
You know those guys that work the door at clubs, seperating the wheat from the chaff, culling the herd, Choosing the Slain, sifting the gold from the dross, telling the difference between the sheep and the goats, winnowing out the weak, tipping the scales of justice... you know, the guys taking tickets. Well, this year, I get to do that job at the SQL Server Central party at the PASS Summit. That's right, I've been given absolute power, the keys to the kingdom, control of the list... you get the point. And best of all, while I was offered money, fame, power & women, I bargained for more and I got it. I'll be wearing one of those nifty Hawaiian shirts (Friday shirts) we always see Steve & Andy sporting. HA! And my wife won't…
Read More
13Oct 2010 by Grant Fritchey No Comments

Speaking at SNESSUG

Misc
I'll be presenting tonight at the Southern New England SQL Server Users Group (SNESSUG). The topic is "Using DMVs as a Shortcut to Query Tuning." It's a practice run for my spotlight session at the PASS Summit, so if you can't make it to the Summit, you should swing by Rhode Island.
Read More
13Oct 2010 by Grant Fritchey No Comments

PASS Summit Birds of a Feather Lunch

PASS
The absolute biggest part of the PASS Summit is the one thing that most people don't take advantage of, networking. And no, I don't mean glad-handing everyone you meet, remembering all their names (although that is a good skill to have) and saying over & over again "Rush Chairman, damn glad to meet you." I mean taking advantage of the fact that you can talk to people that have already solved the problem that you're facing at work, or just might have some insight into that issue, or maybe you can give them insight into a problem they're facing. I'm mean, talking to people. Yeah, I know, we're all geeks, and worse than that, data geeks. That means we like to sit in dark little caves & grumble about our…
Read More
12Oct 2010 by Grant Fritchey 1 Comment

SQL Saturday New England: The New Date

PASS
The real world can get in the way of important things like SQL Saturday. In the case of SQL Saturday New England, the original date was the same time as the Boston Marathon. Unfortunately, that means that Boston's somewhat limited hotel space will be tweaked. Rather than try to compete with that, we moved the date. Please mark it as April 2nd, 2011.
Read More