03Jul 2014 by Grant Fritchey 9 Comments

Reflections on the 2014 PASS Summit Selection Process

PASS, Professional Development
Oh we are a bunch of high school kids at heart. Maybe high school never ends (and there's a nightmare, god I hated high school). But, there's been drama about the 2014 PASS Summit sessions and the Selection Committee's work. I was on the committee. I worked as a part of the team responsible for rating sessions for the Azure track (said track is gone, more on that later). As self-serving a statement as this is, I think we did a good job. Further, I think the process worked. You can read the official explanation of the process here. Amy did great work and deserves your thanks. All the volunteers who reviewed over 900 submissions from more than 300 people, ON THEIR OWN TIME, FOR FREE, also deserve your thanks. The vitriol directed at…
Read More
30Jun 2014 by Grant Fritchey 11 Comments

The Curse of Working With A DBA

DevOps, Professional Development
I no more than finished my rant from last week than I started thinking about all the reasons why a healthy chunk of the reasons that developers want to bypass relational database is not the horror of the relational database itself, although, that's there. No, a very large reason why is the DBA. We're on a blog called The Scary DBA. I earned that title, well sometimes. Sometimes I got it and I wasn't sure why. However, it's perfectly in keeping with how many people view their database administrators; grumpy, obstructionist, slow, difficult, control freak, etc.. There are even jokes about it, "What's the DBAs favorite word? No!" And for those answering "It depends" that's two words. I understand why. In large part it's that phone in your pocket (used…
Read More
18Jun 2014 by Grant Fritchey 12 Comments

The Curse of Relational Databases

Professional Development
Let's face it, none of Information Technology is easy. Oh yeah, there are those few geniuses that have an absolute grasp over some small aspect of the stack, or those other geniuses that have a very shallow knowledge level, but understand the entire stack. But the stack itself, it's vast, deep, wide, utterly unfathomable. So what do you do? You cheat. You take shortcuts. You ignore things you don't like/understand/appreciate. And then there's all the things you just don't know. Or, you cheat another way, you get experts that have drilled down on a particular technology so that they'll provide you with the knowledge you need. Ah, but then you have to listen to them and what happens when your local genius (deep or wide) doesn't agree with your hired…
Read More
06Jun 2014 by Grant Fritchey No Comments

Speaker of the Month, June 2014

Professional Development
It's not like I can't find plenty of great presentations here in the US, but, while I was over in Belgium at Techorama I checked out several of the presenters there. They were awesome. This was the first ever Techorama. It's a developer focused event, but there was stuff there for data-centric people too. They had a great international collection of speakers from all over. The venue was a movie theater which was a lot of fun to present in, although may be a little too comfy to watch presentations (I fell asleep in one, I sure hope I didn't snore). It was such a great event that I decided to pick my speaker of the month from there. I saw a bunch of very good presentations (even the one…
Read More
02May 2014 by Grant Fritchey 8 Comments

Speaker of the Month, May 2014

Professional Development
Whoa! Another month gone by already? I guess I better pick a speaker of the month then. I went to several events this month, so selection was difficult, getting to see so many great speakers. But, one stood out in my mind, partly because he's the least experienced speaker I've seen in quite a while. But his inexperience didn't show. Speaker of the Month for May 2014 is Andy Yun (t) and his presentation Every Byte Counts. The session was about using the right data types. You'd think this is self-obvious, but from the way Andy packed the room along with the attention and questions from the attendees, it's clearly a topic that needed attention. I really liked how he did a presentation on the problem space before showing his goals…
Read More
15Apr 2014 by Grant Fritchey 11 Comments

SQL Server First Aid

DevOps, Professional Development
If you take basic first aid, say a CPR course, you'll learn a handy mnemonic for the primary assessment you have to make, A-B-C. That breaks down as Airway, Breathing, Circulation. Is there an open airway so they can breathe? Are they breathing? Do they have circulation, a pulse, are they alive in short. I recently took a two day course on wilderness first aid (on top of CPR training and first responder training and basic and advanced first aid training and Scout training and Scout first-aid training and I'm sure I'm forgetting some) that added to that, D-E. We now have Disability and Environment. In short, just how responsive is the person or do they have the possibility of spinal issues? What's the environmental situation, lieing on cold ground,…
Read More
14Apr 2014 by Grant Fritchey No Comments

Sharing a Good Idea

Professional Development
I posted earlier about my experiments with Microsoft Curah!. (yes, technically the period should follow the exclamation since the exclamation is part of the name, not the end of the sentence) Evidently people actually read this blog because it inspired Stephen Bennet to start putting together his own curations and collect them on his blog. I think that's a pretty interesting idea. I might try it myself (after I get back from SQL Intersection). Stephen's Curah! so far. Oh, and I kind of dislike the name. Curah! Just typing it I feel like I should be excited except I'm not. Anyhooo...
Read More
04Apr 2014 by Grant Fritchey 4 Comments

Speaker of the Month, April 2014

Professional Development
I'm really enjoying picking a speaker of the month. It forces me to sit through a lot more sessions at the events I attend. I had been getting rather slack about attending sessions. It's easy to get caught up in networking so much that you're not taking advantage of the learning opportunities. This month we're on to the East Coast to pick a speaker from the Boston SQL Saturday event. The talk was called, "What I Wish I Knew Before Becoming a DBA." The speaker of the month is Mike Walsh (b|t). Mike's session was just a general discussion about the job of being a DBA. He didn't get into a lot of technical detail. Instead it was like a conversation with your friends talking about personality traits, work/life balance, restore…
Read More
07Mar 2014 by Grant Fritchey 3 Comments

Speaker of the Month, March 2014

Professional Development
This never gets easier. I was able to attend a bunch of sessions in the last month from a number of speakers that I'd never seen before. A lot of them were good, very good. In fact, I'd go so far as to say I think the general level of speakers within the SQL Server community is improving. Which means we'll all need to up our games. I also saw several that I've seen before because I always learn from them. In short, my cup runneth over. Anyway, the person I picked this month, well, I'd never seen him present before. But, I have hung out with him. He's got this incredible, fast, sharp wit and he'll protect you from dangerous objects in orange. I'm picking Mark Vaillancourt (b|t) and his…
Read More
27Feb 2014 by Grant Fritchey 2 Comments

Let’s Talk Query Tuning

Professional Development, SQL Server, T-SQL
I spend quite a bit of time writing about query tuning on this blog. I've written (re-written and am actively re-writing) books on query tuning. But what I like most is talking about query tuning. I love giving sessions at various events on different aspects of query tuning, but, what I like the most is spending a whole day, trying to do a complete brain dump to get as much information out there as possible. Sound attractive? Then I've got a great deal for you. Come to Louisville on June 20th, 2014. We will talk query tuning at length. You have a specific question? Let's get it answered. Then, the next day, we can all go to SQL Saturday 286 there in Louisville to get more learning and some serious…
Read More