Tag: syndicated

  • 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.

  • The Charles River – SQL in the City Boston

    headI once rowed in the Head of the Charles Regatta. I had the 3d seat, starboard, in a 4 man boat and it was quite exciting to come up to Boston and row down the famed Charles River. It was hard, and the river was rough, tossing waves in our boat at times, but it was a great experience. This year I won’t be rowing in the Charles, but I am looking forward to a chilly run along the Charles on Oct 7. I’ll get into Boston around 4:30pm, race to the hotel, and then have an evening run. Follow me on Twitter if you want to join me. I’ll probably do a couple miles that evening, and again around 6:30am on Monday.

    The SQL in the City tour comes to Boston on Monday, Oct 8, 2012 with another great lineup of speakers. In addition to myself, g, and a number of our Red Gate developers, we have Adam Machanic (b | t) joining us to deliver a full day of free training to SQL Server professionals.

    Free. Just register and come down to the Joseph B. Martin Conference Center at the Harvard Medical School on Oct 8, 2012. It’s training The Red Gate Way at a great location, with fantastic material and plenty of refreshments. The staff is there to make sure you have a great day, as we do at every stop.

    staff

    booksWe’re looking to teach you a few things, give you tips and tricks for working with SQL Server, debate you, answer questions, and have an inspiring day. Stop any of us, and ask a question, pick up a book for your library, and maybe even win a prize as we sip a beverage at the end of the day.

    It’s a great time and I’m sure you’ll find it worth your time to come spend a day with us talking about SQL Server.

    Register today, and come shake my hand in Boston on Oct 8.

    This is part of my SQL in the City series, covering a few thoughts on the US tour.