Category: Professional Development

Apr 10 2015

I Am Grateful For

I decided in January that I would write regularly about people that I’m grateful for. Now it’s April. Oops.

The concepts are simple and science based. Positive emotions help your clarity of thought. Further, your moods and actions extend out through your network to the third layer. With that in mind, I want to think more clearly and the most direct path to positive thoughts and emotions being gratitude, I’m attempting to focus and publicize my gratitude by publicly sharing it through these blogs (in short, I’m trying to tune my brain like I would tune a query).

I am grateful for Tim Ford (b|t).

Tim is a great guy. Further, Tim can be patient with thick headed dorks (raising my hand). For example, among all the other stuff Tim does (Board of Directors for PASS, Editor at SQL Mag, Track organizer at Connections), he organizes and runs SQL Cruise. Yeah, yeah, cue the laugh track. You don’t get it. SQL Cruise changes peoples lives. I’ve seen it. Now, first time I went, I had a blast, but, I’m a bit thick, so I didn’t understand everything I was seeing. What I knew was that I didn’t tweet or write a blog post for a week, therefor I must not be doing my job. So, I asked Red Gate to not send me on any more cruises. We skipped them for a while. Last year, with a lot of prodding from Kevin Kline (another person I’m grateful for, but one blog post at a time), I went on the cruise again. Yeah, sun, rum, beaches… Oh, and people doing intense networking, redirecting their careers, going through intense, long form sessions with great speakers (and me)… Whoa! I spent some time talking with Tim and his wife Amy and the light finally dawned. Tim isn’t ONLY finding a way to get a bunch of us out on a boat so we can have fun (yeah, that’s part of it), he’s literally building and engineering opportunities for people to recharge and reset in preparation for radically modifying their career (not their jobs, people after SQL Cruise have careers). And it’s done the same thing for me. I’ve been personally reinvigorated by the work that Tim has done and I’m immensely grateful for that. But it’s not just SQL Cruise. Tim has helped me personally and professionally because he’s just that sort of person. He’s one of a long list of people that I’m regularly gobsmacked are willing to hang out with me.

Thank you Tim.

Apr 03 2015

Speaker of the Month: April 2015

One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them and I’ve gone to three (had to miss last year, scheduling conflict). It’s a fantastic event and Mark Ginnebaugh (b|t) does a great job putting it together. In fact, this year, we got to listen to Ross Mistry and T.K. Rengarajan have a “fireside chat” for the keynote. For those who don’t know, Mr. Rengarajan is just a VP at Microsoft. Yeah, he simply runs the ENTIRE FLIPPING AZURE DATA PLATFORM. That’s all. They had a few demos and showed us unreleased code and new versions of SSMS not yet available publicly (including functionality around Query Store and execution plans, my little heart was going pitter-pat). Anyway, if you missed it, you missed it… So… Speaker of the Month.

I am choosing Vicky Harp (b|t) and her presentation, Care and Feeding of Your System Databases.

This was a very good presentation and Vicky is a very good presenter. She presented without a microphone, even though one was available. Sitting in the back corner, I could hear her very clearly. She made excellent eye contact throughout the presentation. She used her slides as guides for what she was going to talk about. She used Zoomit appropriately and frequently. I learned a couple of things during the presentation. Vicky demonstrated excellent knowledge of the subject matter, fielding every question. Largely, I’d say this was almost a class in how to present properly. And, I think it’s a good choice because system databases are kind of easy to ignore, yet, there’s important stuff there that Vicky addresses well.

Feedback I’d give Vicky, number one, repeat the question. She handled all the questions so well. I mean she really knows her stuff. But, she didn’t repeat the questions and some of the people asking didn’t have booming voices, so despite it being a small room, I was guessing context based on Vicky’s answer (which, was easy since her answers were so good). I also thought some of the examples were overly simplistic. We might have hit more of the material in more depth by skipping a couple of the really simple examples.

I understand Vicky will be recording this for SQL Server World Wide Users Group. Not sure how to get that, but it’s absolutely worth a listen.

Mar 16 2015

How To Speak At SQL Saturday Events

The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism for the speakers to learn, and fulfill the PASS goals of Connect, Share and Learn. So, you’ve decided you want to start speaking at a SQL Saturday event. Cool. You went to the <Insert Large, Popular, SQL Saturday> event last year, so you submitted this year… and didn’t get accepted. Now what?

First, submit. You won’t get accepted if you don’t try.

SQL Saturday, especially the big, popular ones, may not be the best place to present for your very first time. In fact, with the large ones, you may not get accepted because people who already have a reputation are submitting to those (we all want to talk to big audiences and go to the good venues). So, start smaller. Find your local user group and speak there to get started. Better still, contact the person running the SQL Saturday event. Most of them are also running their local user group, or are associated with it, and most user groups are desperate for speakers. Go and speak at the organizers user group. That’s going to do two things for you. You’ll get some practice in a friendly space, and you’ll get your face and name in front of the SQL Saturday organizer. PASS maintains a list of local user groups that are associated with PASS as Chapters.

Next, go to the SQL Saturday web site. Find the one that you’re thinking of submitting to. Go to the Schedule page. You’ll see a list of people and topics they submitted. At the bottom, there is a place for suggested topics. Sometimes, but not always, you’ll see the stuff there that the organizer wants to see. They’re looking for a session on the VARIANT data type and you’ve written 33 blog posts on VARIANT in the last six months? GOLDEN! Submit under that topic. You can also try contacting the organizer to see what they’re looking for. Ask them, what topics they’re interested in presenting? Now, be sure you actually can present on that topic, but, here’s your in, giving them what they want.

Go to a smaller event. Yeah, presenting at the big event so you can hang out in the speaker room with <Insert Popular Speaker> would be cool. But, it really is hard to get into some of those events because everyone wants to do the same thing. So, start smaller. Some of the events just aren’t drawing lots of big name speakers. Personally, I don’t think that matters at all (people disagree on this topic), but, it’s an opportunity for you. These events need speakers. I know some where they’ve accepted every single session submitted, turning down no one (and I even presented a couple of extra sessions while I was there to help out). So, if you want to speak and, if you drove an extra hour or three you could speak, done.

Finally, your title and abstract do matter. The abstract needs to define a clear problem and solution that you’re going to present. The title… my opinion, let’s have a clear, descriptive title. I intensely dislike the cute and clever titles. Further, I don’t think they help people, especially new people, get accepted. I think they work well for the name speakers because it shows off their personality, and sometimes that’s what people are going for. You’re just getting started, tell us what you’re presenting.

None of this guarantees you get in, but it should all collectively help to get you in front of an audience at SQL Saturday.

Mar 13 2015

Speaker of the Month: February & March 2015

It’s not a question of scheduling. I just haven’t been to lots of community events in the last several months so that I can see community speakers and find one to give an award to. I’ve been trying. So, we’re giving out two awards this month (my blog, my award, my rules). Unfortunately, neither one is going to a full-blown community speaker. Hey, not my fault. I’m trying. Anyway, on with the show.

The first award goes to ALL the speakers on the SQL Cruise. That’s Jes Borland(b|t), Jeff Lehman(L), David Klee(b|t), and Kevin Kline(b|t). Look, I get it, Tim Ford(b|t), the guy who runs SQL Cruise, goes after top speakers (and, somehow I get in too). But, until you’ve watched these people present, in the long form sessions that SQL Cruise offers, you might not have seen these people at their very best. I did. I learned things about Amazon Web Services, VMWare, Automation, and just being a DBA, that I really didn’t know going in. And, I was entertained by witty people. And I was energized by animated, interesting talks on useful topics. Look, the main reason I didn’t pick a Speaker of the Month for February was because I wanted to do this and just didn’t feel like I should. I finally just gave in. So, here you go guys. You win. Amazing stuff. Thank you so much for sharing. And you, dear reader, should try to go on one of these cruises. It’s one of the best learning opportunities you’re going to hit.

The next award goes to Justin Langford(b|t) and his session on Get Started with Troubleshooting SQL Server presented at SQLBits.

This was a very good session. I really liked how Justin delivered the content. Not surprising since he’s an MVP and an MCM. He made good eye contact through the whole presentation. He presented troubleshooting in a way that people should actually follow. I also liked how he presented all the various tools (and seeing them listed out, there are a ton of native tools in SQL Server) and their uses. I learned a few things on some of the tools that I hadn’t worked with much, especially SQL Nexus. It was a great session that I can recommend.

The only thing I might change if I were Justin is that I’d rearrange the order just a little. I’d show the problem and then show the tool that solves it. He kind of approached it the other way around. It still worked great, but I think it would have worked a little better, maybe. But that’s it. It was a very solid session.

Next month, things should get back to normal. I’m hitting a SQL Saturday, so I should be able to track down some community people and get away from all these talented professionals.

Mar 09 2015

Upcoming Events Where We Can Chat

I get around quite a bit.

Next week I’ll be visiting three cities in Germany talking to user groups in Frankfurt, Cologne and Munich on the 17th, 18th, and 19th of March, respectively. Here’s the one link I can find for information. EDIT: Here’s Cologne and here’s Munich.

Next, you can see me at the Redgate DLM Seminar in Silicon Valley on March 27th. It’s a free event and there are a few seats left. Click here to register. The next day I’ll be presenting at Silicon Valley SQL Saturday on March 28th.

After that, I’m staying close to home to get to Boston SQL Saturday on April 18th.

Then, one of the big events this year, I’ll be travelling to my very first PASS Business Analytics Conference in Santa Clara, California, on April 20-22. Analytics is a fast growing aspect of being a data pro. You’re going to need to understand it the way you understand Azure, NoSQL, and all those other technologies that are looming on the horizon and will be changing the DBAs job. Click here to register now. I think I still have a few of my “Friends and Family” discounts left. Enter “BFFGF” when prompted.

Next, it’s off to beautiful Belgium for Techorama, May 12-13. I love visiting that country and I really love that conference.

I’m not done. In June, I’m going to go on SQL Cruise Mediterranean. You do NOT want to miss this. If you’re in Europe wishing you could afford to fly over for the Caribbean trips, now is your shot. A train or a flight down to Barcelona is a lot cheaper. SQL Cruise changes lives. I’m not kidding or exaggerating. It’s very intense training and networking with fantastic people. You’ll come away energized, ready to conquer the world. And there’s rum.

I’m taking July off, but I have a bunch more trips scheduled for late summer and the fall. I’ll post them later.

I live off of questions, so I really do want to meet you at one of these events and have a chat.

Jan 28 2015

Oh Look, A Horseless Carriage

Never forget, we’re making buggy whips. And everybody we know drives little buggies and they need our buggy whips. We’ve got a special talent, a unique knowledge set, and it’s fulfilling a defined need. So we’re all set, right?

Well, other than that Stanley Steamer over there. And maybe that Ford. Oh, and there’s a Grant.

I worry about this stuff all the time. I know SQL Server. Before that, back in the day, I worked on Paradox, PAL & OPAL. I learned and programmed in Visual Basic, Java, C# and .Net. I’ve made sure that I’ve explored, let’s see, Hadoop, Mongo, MySQL, and others, structured and unstructured, relational and non, you name it. Why? Because, I want to keep an eye out for the automobiles that are going to ruin my nice little buggy whip manufacturing business. I make money on these buggy whips and that feeds my family.

Now, here’s my current question/thought/worry/thingie… How does business analytics fit into this? Is there a path that I may need to explore that moves me from working primarily within a focused technical sphere to working with PowerWhatever? Is that a path that people take? Or, is that actually leaving the technology path to become primarily business focused? That’s what I’m trying to figure out. Yesterday we did Oracle. Today we’re doing SQL Server. Tomorrow we’re working on Hadoop. Next week… Wouldn’t it be data vNext for the data professional? Or is it that the data pro’s path lies, at least what appears to me, outside of a pure technical scope?

I’m not sure. But it’s something I’ve realized I might need to at least explore a little before I dismiss it out of hand. I may sound a little snide or scornful, but I’m not trying to be. I absolutely recognize the size of the analytics market. It’s vast. And, I’m actively concerned. Does this represent a horseless carriage? I am unsure, but I’m also a little nervous. It feels like I would be abandoning technology, to a degree (recognizing that this too requires technical know-how). Technology (buggy whips!) has been my primary driving force, even when I was in the Navy.

But, we all do have to worry about this. You absolutely don’t want to be trying to sell those buggy whips when everyone is buying cars. If you do think the next step is analytics and you’re ready to go down that analytics path, I can help a little. I’ve got a discount code that will get you into the PASS Business Analytics Conference for a reduced rate. Just enter BFFGF when prompted. This very well could be the right choice to avoid the whole buggy whip problem (until the next time, because it’s buggy whips all the way down). Or, if you just want to get your feet wet, check out the BAC Marathon.

In the meantime, I think I’ll explore how this DocumentDB thing is working. I’m just not sure I want to give up on technology to focus primarily on the business just yet. But I’m seriously curious what others think about this. Is analytics the logical next step for the data pro? Is that a horseless carriage?

Jan 09 2015

I Am Grateful For

A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my ride home from a great New England SQL Server User Group meeting (yes, I listen to NPR). Two different reports came on during my ride that got me thinking again about my previous blog post. The first talked about how negative emotions directly impact your ability to make rational decisions. They’ve found that people actually spend more money on items when they’re depressed than they do when they’re happy. There’s a bunch of research around it, but I missed where it was published. It was a great discussion. They found that getting yourself into a positive mood directs your focus outwards rather than inwards. One of the best ways to get that positive emotion train running is to think about what you’re grateful for. More specifically who you’re grateful for in your life.

Then, a couple of segments later the author of this book, Connected: The Surprising Power of Our Social Networks and How They Shape Our Lives
(on my reading list, I’ll get back to you) was on talking about how positive/negative emotions transmit themselves through our social networks, and not just the people next to you, but the people they’re next to and the people they’re next to. Three layers of separation.

I’m not the brightest fellow, but taking my “Thank you” post, in combination with the two segments on NPR, I’ve decided to get off my behind and start a blog series, “I Am Grateful For…” and I’m going to single out someone that I’m personally grateful for and tell you why. Still trying to decide on frequency, but probably one a month for a little while. The purpose is purely selfish. I want to think better, so I’m going for that positive emotion. I want to be in a positive environment, in order to maintain the improvements, so I’m going to spread that positive emotion.

Let’s get started.

I am grateful for Aaron Bertrand (b|t).

I consider Aaron a friend. We’ve known each other quite a few years although I don’t remember where we met exactly (had to have been at an SQL event somewhere). Aaron lives nearby in Rhode Island (and I forgive him for that) so we actually get to see each other occasionally in the real world. I’m ashamed to say that it’s Aaron that usually reaches out for these get-togethers. He’s great that way. He invited me down to his house to help raise money and awareness for ALS. Even though he works for a company in competition with mine, we get along great and he regularly invites me to events his company is putting on. He’s also terribly smart and shares that through his blog all the time, stuff that I learn from and incorporate into what I do (no, I don’t steal it). I appreciate his voice when we get in discussions (you should hear him at an MVP meeting) because he always seems to come at things from such an informed place. Funny enough, he’s one of the meanest Canadians you’ll ever meet, but I think that makes him great too. He takes time away from a very young family to get out to events and share all the stuff he knows on a pretty frequent basis.

Thanks Aaron.

Jan 02 2015

Speaker of the Month: January 2015

I love it that my first post of the new year is going to be Speaker of the Month. I’m really enjoying doing these because I’m getting to attend a lot more sessions at the events I go to in order to get choices. But, please, don’t bug me. If I can attend your session, I will. If I can’t…


Speaker of the Month for January 2015 is William Wolf (b|t) and his session “Common Coding Mistakes and How to Mitigate Them” that was delivered at SQL Saturday DC.

This was a good session. It was informative. I really liked how Bill (I’m going to use that because it’s easier to type and despite looking like the Demon Biker of the Apocalypse, he’s a bigger sweetheart than I am) kept referencing everything back to his own coding experiences. It’s a fantastic way to make a point and make it stick. Further, it lets the audience know where you’re coming from and why any particular point is important to you. Maybe they haven’t seen this problem much, or at all, and don’t think it’s important. But you’ve seen it burn down the house, so bringing your experience out is just a great way to communicate. I also liked how Bill emphasized each of the points he was trying to make. It wasn’t just a series of slides and examples, but he was making a specific point with each and the code reflected that, but Bill emphasized it. He really followed the “this is what I’m going to tell you, now I’m telling you, this is what I told you” model. I also liked how he worked Metallica into the slides. It was a useful and informative session, well delivered.

A few points that I think may help to make the session even better. First, stop using Profiler and trace events. Extended Events are here to stay. Learn them, love them, demo with them. Practice a little more with Zoomit. You used it very well, but every once in a while it sort of surprised you. That’s just practice. Be careful about reading the slides to us, especially when you turn to look at them and read them. Doing that to emphasize a point, cool. Reading for us, not so cool.

Thanks. Great session. It showed a lot of hard work, especially the demos. I was really impressed and enjoyed the session.

Dec 08 2014

Speaker of the Month: December 2014

For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new speakers to see (heck, I didn’t get to see any sessions at Summit this year). But, that didn’t mean I didn’t get to see great speakers. I did (Rimma! Rimma! Rimma!). Live360 had some amazing presentations. I do like the mixed events like Live360 because I enjoy crossing into dev sessions as well as database sessions.

My speaker of the month for December 2014 is Bradley Ball (b|t) and his session “Inside the Query Optimizer

Oh, before I go any further:


Sorry, but Brad had us do that at the start of the session. I figured I’d just carry it on. Anyway, wow. What a great session. Brad’s delivery is just awesome. He’s light and funny, but hits the points he means to hit and hits them well. I really loved the partitioned view example to illustrate simplification within the optimizer. Like I do with most of my speaker of the month sessions, I learned a few things. I also heard things that are driving me to do some research to help further my understanding. That right there should be one of the criterion for what makes a great session. Everything worked. His jokes were funny, but not overwhelming the content. As already noted, the demos supported the content extremely well. It was great.

Improvements… Yeah, a couple, maybe. I loved the way Brad presented, but, it had a feel as if he was speaking really fast. I don’t think he was, or maybe I just heard really fast, but you might try slowing down slightly. Again, more of a feeling than a real criticism. Brad had more scripts and material than he had time for. Like with my last winner, I can’t say this is a problem. But I’ve heard people complain about it. Again, you might try hiding some of the stuff and only pulling it forward as needed.

If you want to learn about the optimizer, come see me speak… kidding! Seriously, you won’t go wrong attending this session. You’ll walk away with a smile on your face (Brad’s funny) and more knowledge in your head. It’s a winner.

Side note: The last two winners are both established speakers who do this all the time and are therefore awesome. Isn’t this supposed to be about helping build up new speakers?


I’ll try to do better. But this will happen sometimes.

Dec 05 2014

Speaker of the Month: November 2014

I have been very remiss in my blogging of late. Apologies.

One thing I haven’t blogged about is Speaker of the Month. I’m behind. So, I’ll be posting two of them over the next few days in order to catch up.

First up, Speaker of the Month for November.

I went to quite a few events in October, but I actually didn’t get to see too many sessions. However, the few I saw were actually quite good. Speaker quality is just going up and up. I finally got to see someone present that I’ve known for years and years, but just never had the opportunity to sit in on a class. Well, I sat in on one, and this is the result. My speaker of the month is Kathi Kellenburger(b) and her presentation, Writing Better T-SQL Queries with Window Functions.

Kathi is just great. If you’ve ever met her in person, she’s this quiet, unassuming woman. She’s like your favorite Aunt, maybe why her nickname is Aunt Kathi. But when she’s presenting, she takes total charge of the room. You know who the presenter is. She spoke without a microphone and I didn’t realize she could project like that, while sitting. The content of the session was great. She mainly worked in the code and through examples, but she had just enough slides that there was some content documentation to guide people through the lessons. Awesome work. Her examples were extremely illustrative of the points she was making about window functions. I picked up a few things and was reminded of several things that weren’t at the front of my brain any more. I loved it.

Everyone can improve a little. While Kathi presented a tour-de-force, I found a couple of things I didn’t like. She had a series of graphics about this guy on set of stairs, that just didn’t work for me. I don’t have a good suggestion on how to improve it, but it just didn’t hammer the point home well for me. Kathi also had more material than she could cover in the time. Now, that’s a mixed bag. I’d say it’s better to have too much material rather than too little. But, I’ve heard people complain that they didn’t get to see X, or Y, or Z, because of time constraints when, in fact, the presenter intended that material as padding in case the session ran short. I guess in order to avoid the complaints, maybe put the padding after the final slide so you can go to it, but only if needed.

However, as you can see, if those are my complaints, one slide graphic didn’t work, and she had too much great material, how amazing was this presentation? Exactly.

This is extremely useful material. I strongly recommend tracking down Kathi and checking out this session if you get the chance.