Voice of the DBA

Author: way0utwest

  • Watson Freemium

    I’ve been intrigued by the Watson project from IBM. It was quite a coup to see the platform win on Jeopardy. That’s an amazing accomplishment for machine learning, though it does seem like the investment and effort to set up the platform and experiment with it was more than most people could afford.

    However this week I saw an announcement that IBM has introduced a freemium version of Watson, aimed at people looking to work with analytics. This product allows users to upload some data and ask natural language questions, which Watson will answer.
    I have no idea how this will work, but I like the model they’ve taken. We can upload limited data and experiment with it. If it works well, we can subscribe, pa some money and upload more data and get more complex analysis. As an IT person, I think this is great. End users can play with it, and I don’t have to mess with a proof of concept. If it works, I can get involved, help automate ETL, query structure, tuning etc.
    It’s a changing way of working with analytics, and one I welcome. To me, as business people play with technologies like this, they become more savvy and willing to invest in technology. And as they demand more, they create more opportunities for IT people to help them, not less.
    Steve Jones

  • Back from DevConnections

    I spent a few days at DevConnections this week and really enjoyed the conference. The location was Aria in Las Vegas, where I’ve never been, but it was a new, really nice hotel and there was one amazing thing:

    The wi-fi worked.

    Not on and off, pretty much the entire time I was sitting in sessions, I had access from my devices. I think that was the first time this worked for me at a conference. Congrats to DevConnections and Aria.

    The conference itself was short for me, with too many other commitments for presentations and talks, I had to cut short my time there. Tues afternoon – Thur morning, which mean I saw a couple talks on Tues, only one on Wed, and gave two Wed.

    That’s disappointing. There were other things I wanted to see, and I wish I had the chance to do more. I’ll be looking to schedule less trips next year as more and more I am finding myself picking up things from really interesting sessions.

    One of the great things about DevConnections is that I can get a variety of knowledge from the event. I watched a session on Azure diagnostics, as I’m curious how to actually track the performance and issues of your application. I still hope to port some (or all) of SQLServerCentral to Azure, so understanding the telemetry is something I’d like to have.

    From there, I went to an interesting logical query processing talk from Itzik Ben-Gan, which I really enjoyed.  If you get the chance to see Mr. Ben-Gan talk, you should take it.

    That’s hard to do at many events, where we often have the focus on one technology. There’s nothing wrong with that, and we have some amazing events in the SQL Server community. However there are times that I want to learn a bit more about development, Sharepoint, Azure, or something else. DevConnections gives you the chance to do so, as does DevIntersection/SQLIntersection (coming in November).

    If you wear multiple hats, think about coming to one of these conferences in the future.

  • No Compelling Reason

    When I’m talking to people working with SQL Server, many of them are quite pleased with the platform. It solves their issues and problems. While they always wants changes and improvements, not to mention bug fixes, overall most people seem happy with their particular version. However, there’s no shortage of things that are slightly broken in SQL Server, and while I appreciate the Cumulative Updates every other month, I’d like to see even more work done fixing code.

    The development of SQL Server has accelerated in the last decade. After the five year span from SQL Server 2000 to 2005, we’ve seen new versions coming just over every 24 months, and I expect that to continue in the future. This rapid release cycle means that many of us end up supporting 3, 4, or more versions of the platform at any one time.

    We often install the latest version for new instances, often because that’s the only version we can buy at any time. However we don’t seem to upgrade older instances quickly. This week I’m wondering why.

    What are the reasons that prevent you from migrating those 2005/2008/2012 instances to 2014?

    Are there technical reasons you don’t upgrade? Is it cost-related? Or is there no compelling reason to adopt the newest features and enhancements to the platform? I suspect a combination of these reasons for many of you, though I also feel the platform is very mature, and has been for many versions. The applications I run, primarily SQLServerCentral, don’t really benefit from any of the features in later versions.

    Let us know this week, and I’m especially interested in knowing if there are technical reasons any of you can’t upgrade.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.2MB) podcast or subscribe to the feed at iTunes and LibSyn. feed

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

     

  • DevConnections–High Performance Encryption

    The talk page is updated, but in case you attended my talk, the downloads are here:

    Slides: EncryptionPerformance.pptx

    Code: EncryptionPerformance.zip

    There are also a few great questions in the talk. One that I certainly need an answer to is how do clients deal with the change of SSL certificates in communications. If someone knows send me a note.

    For those of you that attended, the Asymmetric Encryption query was still running at 24 minutes when I killed it.