Voice of the DBA

Tag: syndicated

  • Talking Career and Unstructured Data

    The Denver SQL Saturday is coming in less than two weeks, SQL Saturday #169 is our second event in Denver, and the fifth in the state and I am honored to be able to speak. I have two sessions on the schedule:

    These are both presentations I’ve done in other places, and they’ve been received well. I’m looking forward to giving them again, and I hope that I’ll see some of you there.

    My busy fall actually starts a few days earlier, where I’ll be giving a talk on Contained Databases at the Colorado Springs User Group on Sept 19.

    After these two events, I start out on the SQL in the City Tour and then hit Dev Connections in October before finishing up at the other Colorado SQL user groups in November. Across those events I end up going to 11 events and giving 21 presentations.

    Whew, I need some tea and honey for my throat.

  • T-SQL Tuesday #34 – Help! I Need Somebody

    tsqltuesday

    I couldn’t resist, so here goes….

    Help, I need some data,
    Help, not just any data,
    Help, I was told you need a report, help.
    When I was younger, so much smarter than today,
    I never needed any query help in any way.
    But now these reports are long, I’m not working late nights,
    Now I find I’ve got to ask for help on window functions.
    Help me if you can, I need a rank 
    And I do appreciate the over clause.
    Help me, get my report back to the client,
    Won’t you please, please help me.
    And now T-SQL has changed in oh so many ways,
    the over clause just seems to vanish in the haze.
    But every now and then I feel I know row_number,
    I know I need a lag or lead just not sure which to use.
    Help me if you can, I’m feeling slow
    And I do appreciate returning more rows.
    Help me, get my query back to the client,
    Won’t you please, please help me, help me, help me, oh.

    The Rules

    T-SQL Tuesday is a monthly blog party hosted by a different blogger every month. This month is hosted by Rob Volk with the theme of “Help, I Need Somebody”.

    If you’re like to participate, just write a post, publish it on the appropriate day and link to the host’s post. If you want to host, contact the founder, Adam Machanic (b|t).

  • Sleepless in Seattle – SQL in the City 2012

    seattle_20081115_cA few years ago I went to Seattle a few days before the PASS Summit started. I took my middle son and we spent 3 days wandering around Seattle, seeing some amazing sights. We went to the Museum of Flight and the Underground Tour, along with a few other places and had a great time. This year I’ll be going early again, and I’ll get to spend a day with my oldest son, who lives in Seattle.

    However I’ll also be getting to work early. SQL in the City is coming to Seattle on Monday, November 5, 2012 at the Bell Harbor International Conference Center. It’s just a short walk from the Convention Center on the water, and we’ll have another great lineup of speakers.

    If you are coming to the Summit, and would like a free day of sessions on Monday, sign up and come down. We’ll do training the Red Gate way, with great speakers, topics, discussions, debates, and food.

    This will be the end of our 2012 tour, but I’m sure we’ll have plenty of our SQL Star beer available at the end of the day. Register and come on down if you will be free on Monday.

    I’ll likely be in town on Saturday, and I’ll be going hard. I will likely get a run in early in the morning before the event, but I’ll be jogging along the water on Tuesday as well, so catch me on Twitter if you want to tag along.

    Register today.

  • This is Big Data

    I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.

    A day.

    That’s serious data. I’ve never had a database that was a TB, must less growth by over a TB a day.

    To be fair, lots of the Facebook data is unstructured, stored in Hadoop or NoSQL structures for images/video, but there’s a ton of database-like status updates, links, comments, etc. that have to be managed.

    Rather impressive, but not something I want to administer.