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
04Oct 2010 by Grant Fritchey 11 Comments

SQL Saturday in New England

PASS
Adam Machanic (blog|twitter) has put on a SQL Saturday/Data camp event in New England for the last two years. I've helped him both years. It's been very successful. In January we had over 300 attendees, making it one of the larger SQL Saturday events. But, with a single exception (thank you Tim Ford (blog|twitter)), we've only had local speakers. Mind you, we're somewhat lucky with speakers here in New England and have several MVPs and others who are truly excellent when presenting. I'm taking over from Adam to lead the effort for this year, and due to my schedule we're moving the event to the spring sometime. We were thinking about maybe making it the the weekend before SQL Rally. But, I've got a question for all of you who present at SQL Saturday events.…
Read More