Tag: speaking

  • Customizing SSMS–Results

    This is a short series on some customizations in SSMS to make it visually more appealing.

    As a presenter, I’ve learned how to change the way Management Studio (SSMS) looks to make it easier for people to see the screen on a projector. I had wrongly assumed that so many people knew many of these tricks, which is a poor attitude on my part. That should be especially apparent as I saw a presentation recently where the speaker didn’t know how to make things easier to see.

    In a previous post I talked about changing the query font size. In this post we’ll look at result sizes.

    The Defaults

    This is what I see, and it’s not easy to read.

    Capture_009

    The results are much smaller than the query itself. How can we change this and make things easier to read?

    I wrote about one way: using results to text. This works well, but it isn’t the best solution for everyone, and you still want to change the size of your results. The technique I’ll show you works for that as well.

    Customization

    If you go to the Tools | Options menu, in the Fonts tab as I showed in the last post, you’ll find there’s a drop down titled “Show settings for:” at the top. If you select Grid results, you can change the font settings.

    Capture_006

    The default is 8, and I usually up that a bit.

    Capture_007

    Once that is done, you click OK, and get this note:

    Capture_008

    Make sure your tabs are saved, since you need to restart SSMS. Once you do, your results will be much easier to read.

    Capture_005

    Note that in the drop down for settings, there is an item for “Results to text”. If you change that, your text results will be larger.

  • T-SQL Tuesday #41 – I Love Presenting

    tsqltuesday.jpgThis edition of the T-SQL Tuesday blog party isn’t a technical one. Hosted by Bob Pusateri, this one is timely for me. Bob invites us all to write about how we came to love presentating. That’s good timing as I’m actually giving two sessions at the SQL Intersection conference today.

    T-SQL Tuesday is the monthly blog party, on the second Tuesday of the month. If you’d like to host, contact Adam Machanic(@AdamMachanic).

    I’m Scared

    That’s actually how I felt the first time I had to stand up in front of the class in school and give some sort of report. I can’t tell you when the first time I did it, but I do know that all through high school, and even college, I was scared to be in front of people, palms sweaty, bowels rumbling, and cheeks flushed. I couldn’t imagine voluntarily choosing to stand in front of people and talk about anything. Even talking to a group of 10 people at a party in college made me nervous.

    I Need Money

    College is expensive. When I went through college it was a fraction of the cost today, but it was still expensive. To help out my family, I worked almost full-time to cover my living expenses. The most efficient way to do that was to work in the restaurant business. I learned to cook, clean, and wait on tables. I never had to really speak to a group larger than 8 people, but I was constantly meeting new people and talking to them every night.

    One summer, while home working at a local hotel, our bartender called in sick. I volunteered to jump in, did a good job, and spent the rest of my college career mixing drinks. Around this time the movie Cocktail was released, and many of my fellow workers learned to toss and spin bottles, myself included. It was a little like being on stage in front of groups of people, and over the next few years, much of my shyness in front of strangers disappeared.

    Watch and Learn

    I worked hard early in my technology career to learn as much as possible. I read books, magazines, trade articles, and more, trying to learn as much as I could about the various pieces of technology in my companies. I also attended lots of talks at user groups and MSDN local events. I watched many speakers talk about subjects that I had read about, and worked with myself. I learned lots of things, but more and more I realized that I knew much of what speakers were presenting. I started to think that I could present as well as others. I gained confidence from watching others validate my knowledge.

    Eventually I started SQLServerCentral and there was a year when the founders wanted to do some joint presentations. Brian Knight and I had a debate about identities v GUIDs. It was my first time speaking at the PASS Summit and it wasn’t so bad. We had a lively debate, some input form Microsoft in the audience, and I realized presenting wasn’t so bad. I didn’t jump right in, but a couple years later I was asked to do a short presentation at a local user group and accepted. Fortunately for me this was a small group, and I ended up presenting for 15 minutes while seated a a conference table. Much like being in a corporate meeting, I felt the same mix of nervousness and confidence, but sitting down helped me.

    Over the years I’ve had some good and bad presentations, but I’ve tried to learn from what has worked well and from what other presenters have done. I have written about presenting and tried to help others. These days I’m fairly comfortable talking in front of groups. I know I’ll make mistakes, and that someone in the audience might know more than I do. I know I’ll stumble over sentences. However I move on and don’t worry about those issues. I try to learn from them, but I don’t view them as failures.

    Today I love presenting about various topics. I speak on SQL Server and professional development topics 10-15 times a year. I usually end up giving 25-35 talks, often on 8-10 topics a year. It’s fun, and I really enjoy the chance to teach people something or help them improve their careers.

  • Thirty Hours at Home

    This is a busy travel week for me, and one of those times that stresses out everyone in the household. I attended SQL Saturday #197 – Omaha over the weekend, arriving home Sunday morning from my trip. I had a good time at the event, my first time to Omaha, and would like to go back again sometime.

    However it’s a quick turnaround for me. Fortunately I have packing down to a science since I’m leaving today at 2:00 for Las Vegas and the first SQL Intersection conference. I have two talks to deliver on Tuesday and a few sessions I’d like to see Wednesday before I head home again.

    Back in time to cook a couple meals (and extra leftovers) for the family and spend a day with everyone before heading back out of town. These are tough times, and it’s a lot of support from the family that allows me to do this.

    I’ll have the same type of turnaround at the end of the month between SQL Saturday #175 – Fargo and SQL Bits.

    I may have to limit some trips later in the year after this month, so please don’t be offended if I decline any offers to speak.

  • Reminders and Rehearsal

    I’ve spoken at quite a few SQL Saturday events. I won’t hit 50 this year, like Kevin Boles, but by my count, I’ve been to 21, with 4 or 5 more coming this year.  I have no idea when I’ll get to 50, but I hope I do.

    Capture_028

    That’s in addition to other events, which will likely bring my 2013 total to close to 15 events, similar to what I’ve done the last few years. That doesn’t seem like a lot, maybe 1 every six weeks, but I end up doing multiple talks, on multiple subjects sometimes. There was a stretch late last year where I did 12 talks in 7 different areas in about 3 weeks. It was slightly confusing for me.

    Yesterday I received an email from SQL Saturday #197 – Omaha, which had the schedule in it. I’d glanced at it before, and had seen I was giving my Encryption Primer talk, but this time as I scrolled down, I saw my name at the end.

    sqlsat197

    Hmmm, that didn’t say “The Encryption Primer”. I’m glad I looked and double checked the schedule because I’m giving two talks. In addition to encryption, I’m talking FTS with Searching Binary Data in SQL Server.

    I’ve given the talk before, and I’m not too worried about it, but I do want to refresh my memory of the flow, and practice the demos again. I have given the Encryption talk a few times this year already, but I was planning on double checking demos again before the event. Especially as I changed the talk around and added some material for a variation I’m giving next week at SQL Intersection.

    I find it’s always good to rehearse my talks. I’m comfortable in front of people, and I know I can get through the talk, but I want things to flow and to make sense to attendees, The more practice I do, the better things go. The less “ums”, “errs” and other placeholders I use as well.

    Plus this will be good practice for SQL Bits, where I’ll deliver this talk again in May.