Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « How to change the SA password in SQL ServerDon't put a return statement in a stored procedure inside a transaction »
    comments

    This is the third year I’ve headed south to Chicago for SQL Saturday. The first, in 2010, was my first SQL Saturday ever. The second, in 2011, was the first time I ever spoke at a SQL Saturday. Could it get better this year? It could, and it did!

     

    Friday – SQLFriends Lunch

    Earlier this year, my friend Aaron Lowe (b | t) had an idea for an event – get a group of SQL people together for networking. Isn’t that always the best part of events? He created SQLFriends, and held the first lunch in March. The second was on Friday, and the guest host was LessThanDot’s own Ted Krueger (b | t). The point is to get people in a room, with no session or agenda, to network and talk.

    And talk we did. There were a dozen people, from at least four states; from consultants with decades of experience to a student graduating later this month. We talked about consulting, writing books, running (I was there, after all), SQL features, and more. It was fun and inspiring. It allowed me to get to know several people better. Ted was a great host, sharing stories and advice. The only time we really got quiet was when he was telling us about a bug he discovered with SQL Server Replication. Yes, we’re geeks.

    SQLFriends lunch (photo courtesy of Aaron Lowe)

    Thank you, Aaron, for putting this event together. He’s looking to spread this idea, so if you have a great location and a possible guest host, let him know!

    SQL Saturday

    The main event took place on…wait for it…Saturday. We were at DeVry University, the same location as last year, which is a great location. I grabbed some Dunkin’ Donuts coffee and a bagel and went to the sponsor room. That was set up really well, and I got a chance to chat with the national and local companies supporting the SQL community. Thank you to the sponsors!

    I caught part of the WIT lunch session, between waiting in a long line for Portillo’s and dashing off to present. Thank you to Wendy Pastrick, Erin Stellato, Hope Foley, and Shelly Noll for sharing their experiences and advice!

    My Session

    I presented my “Reporting Services: From Basic to WOW!” session after lunch. I always like the challenge of keeping people awake after a good lunch (and Portillo’s was a good lunch). I had a packed, energetic room that I really had a great time presenting to. About half the attendees were at their very first SQL Saturday, which was exciting for me.

    Presenting! (photo courtesy of Michael Kappel)

    I talked about my favorite report and tablix properties. I showed how to create a matrix. I asked how many people had used lists, one of my favorite features, and was surprised to only see three hands go up; I showed everyone how powerful they can be. I finished the session up with a quick look at charts. Reporting Services is so fun, and I love sharing how many things you can do with it. It is so much more than just black and white tables of numbers to be exported to Excel. You can download the PowerPoint and .rdl files from the SQL Saturday website.

    Student Labs

    There was something new at SQL Saturday Chicago this year. The organizers worked with DeVry to offer a free SQL Server class to alumni and students. The topics covered were installing SQL Server; a look at SSRS, SSIS, and SSAS; and creating your first database and table. I was asked to lead the SSRS portion, and assisted Ted and Frank Gill (b | t) with the other labs. It was exciting and challenging to share real-world knowledge with people just getting started in the field. I have to commend Ted and Frank for putting together the presentations and labs from scratch, and keeping the students interested on a beautiful Saturday afternoon.

     

    Ted and I in the student lab (photo courtesy of Michael Kappel)

    I think this would be a great way for other SQL Saturday organizers to give back to their local community. I know it’s a lot of work and coordination, but I think there’s a lot of value.

    Saturday – The After Party

    What happens at #sqlkaraoke stays at #sqlkaraoke. If you go to a SQL Saturday and there is an after party hosted, try to go. It’s nice to get to know people outside of a classroom.

    As always, my favorite part of the weekend was all the people. I got to see many old friends, and met some new ones. The people are what make this community awesome.

    Chicago, I’ll see you again next year!

    About the Author

    User bio imageJes Schultz Borland is a Consultant with Brent Ozar Unlimited, and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree, is a Microsoft Certified Professional in SQL Server 2012, and has worked with SQL Server as a developer, report writer, DBA, and consultant. Her favorite topics are administration, automation, and SSRS. She is an active member of PASS, President of FoxPASS, founder of Tech on Tap, and a LessThanDot.com blogger. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.
    Social SitingsTwitterLinkedInLTD RSS Feed
    InstapaperVote on HN

    3 comments

    Comment from: Eli Weinstock-Herman (tarwn) [Member]
    Eli Weinstock-Herman (tarwn) I missed the last two Chicago ones, I may have to try to make the next one, the first one was a lot of fun (even if I did have to switch to Ted sleeping hours for the weekend, aka not a whole lot :P).
    05/22/12 @ 07:15
    Comment from: Dustin Mueller [Visitor] · https://twitter.com/#!/sqlcheesecake
    Dustin Mueller "What happens at #sqlkaraoke stays at #sqlkaraoke."
    - The best part of the weekend, right?

    Seriously, what a great event and kudos to the event organizers, volunteers, and DeVry for putting on a terrific SQL Saturday. I’ve attended the last 2 in Chicago, and look forward to checking out all the presentations I couldn’t make it to.
    05/22/12 @ 08:05
    Comment from: Sarah Strate [Visitor] · http://sarahsjolander.wordpress.com
    Sarah Strate Jes, I could tell you were having fun. I was going around taking some pictures, and could hear you laughing all the way down the hall - with the door shut! Way to keep things fun!
    05/31/12 @ 11:40

    Leave a comment


    Your email address will not be revealed on this site.

    To mislead the spambots.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)