Voice of the DBA

Category: Editorial

  • Truth and Demos

    Demoing SQL Server on stage

    In my career, I’ve given quite a few demos of various types of software, usually in an attempt to show how the application in its best possible light. I suspect that most people giving software demos engage in some level of simplification of a problem, or contriving one completely so as to make the software appear as simple as possible to use. One university thinks that Oracle went a bit too far, promising capabilities and misleading them about the costs and customizations that would be needed.

    I’m sure there are similar examples of this for all software vendors, especially those that sell large software packages such as ERP applications. Some are probably without merit, and are the result of customers not fully understanding what they are buying, but some are probably valid complaints where salespeople have misled customers in order to complete a sale.

    Most of us that work in technology and develop applications never sell our products for money. We often build our systems for internal users, but we are still selling something that I think is more important than money: our professional reputation. We work with clients, we promise to deliver some feature or solve some problem. If we do not complete the work as we agreed to, either we are not doing a good job, or we are misleading our clients. It’s the same way we might feel misled by salespeople when some purchase we make doesn’t work as expected.

    It’s your career, it’s your reputation, and I’d hope that most of you would want to ensure that when someone speaks of your work, they do so positively. Learn to communicate well with your clients, but do so in a fair, and truthful way that not only promises when you can deliver, but warns them about what you cannot. Or at least what it will cost.

    Steve Jones

    The Voice of the DBA Podcasts

  • Cloud Patches

    One of the very cool things that I find in technology is that I learn new things constantly, usually from other people. In this case, I heard about a new site from my employer, Red Gate, that is designed to talk about the challenges and solutions of working in a cloud computing environment. It’s called A Cloudy Place, and it’s slowly getting moving as we develop new tools to work with cloud services.

    I was reading an interview with our main administrator, Simon, who also manages the SQLServerCentral servers, about the recent challenges of managing infrastructure for the DBA in Space contest. We had no idea how big the contest would be, and we knew that there might be a need to scale up rapidly to handle thousands of users accessing the site in a short period of time as new web-isodes of Brad’s adventures were released.

    Typically when you need to handle a large load, you set up a load balancer (hopefully clustered) and then you have a dozen or so web servers behind it to handle requests from clients. If you need to patch the web site, you typically make a change to one server (hopefully scripted), then make the change to the next server, and the next, rotating through them in order. The good administrators have some automated mechanism to do deploy changes, but those change scripts need testing, error handling, and more. It’s a simple process that can end up being fairly complex in it’s execution.

    However Simon had a different solution. He would make the change on one machine, then clone it using the Rackspace cloud environment, deleting the old machines from his environment. That’s pretty cool and a neat solution. Make changes on one machine, then clone the machine.

    That’s a neat idea, and it’s a great example of a place where cloud computing and the rapid provisioning of resources can cause us to rethink the way we deploy changes. I’m not sure if we’ll find advantages for databases, but I hope that we get people pushing the limits of cloud computing to see if there are better ways to handle database work in the cloud.

    Steve Jones

    The Voice of the DBA Podcasts

  • The Data Resolutions

    Happy New Year

    Making a new year’s resolution is an annual tradition for many people on January 1. Breaking those resolutions seems to be another annual tradition that often takes place during the month of January as we struggle to live up to the changes that many of us often want to make in our lives.

    It’s the last Friday of the year, and rather than ask you about the resolutions you are making overall, I wanted to ask this question:

    What would you like to do differently in your career in 2012?

    It’s easy, and I hope it makes you think a little about where you want to go ni the future. Are you looking to move to a new job, a new kind of work with SQL Server? Do you want to learn more about some aspect of SQL Server? Do you want to get out of technology?

    As you think about what you might do differently in 2012, it’s not always about growth. Perhaps 2012 is a year where you slow down a bit and maintain some skills, or even reduce your hours as you spend time on something outside of work.

    For me 2012 will be a slower year. After attending over a dozen events in 2011, I am planning on many fewer in 2012. My wife’s career will take a little more precedence over mine, and I’ll concentrate on writing more, and bringing you more news, knowledge, and training as SQL Server 2012 is released.

    Happy New Year, be safe and responsible over the weekend and I will see you in 2012.

    Steve Jones

    The Voice of the DBA Podcasts

  • The Year in Review – 2011

    Big Data and The Cloud were a large part of 2011

    It’s the end of the year, and I’m taking a look back at 2011 from the data perspective. As we close out the year, it’s apparent that “big data” has been catching on with many companies. It seems that every week we have some headline that talks about “big data” in some way. Even Microsoft has joined in with  their work with Hadoop and SQL Server.

    The other big push in 2011 seems to have been “the cloud”. It’s everywhere, from consumer Windows 7 commercials to the updates to the SQL Server tools to support the SQL Azure platform. I haven’t found many people that are excited about moving their databases to the cloud, but more and more people are testing the platform, and I suspect we’ll start to see some apps that don’t require high security or extremely high performance appearing in the cloud in 2012. I have embraced the cloud in many ways over the last couple years (Evernote, Dropbox, Live Mesh) and I find it to be an advantage in managing a busy life.

    We had our share of high profile data breaches as well, with some very high profile ones, including RSA, the security vendor. We could add in the Carrier IQ fiasco, which showed a little abuse of consumer trust with the debugging code they developed.

    A few other notable items in the data world for me. The first was the death of Steve Jobs. While most of us working with SQL Server don’t use Apple products, the changes that Steve Jobs brought to the world, most recently the iPhone and iPad, have altered the way we consume data in many facets of our lives. The second item, was the split of Netflix into two businesses, and the failed idea that splitting our online and physical DVD data into separate sites wouldn’t be an issue. The reversal of that decision showed me just how valuable centralization is for many consumers.

    There were many stories that touched data in our lives in 2011, and it seemed to be a busier year than ever before for me. However one large milestone for me was the 100th SQL Saturday event in Brazil. It’s hard to believe there have been 100 events, with 45 events in 2011. Seeing the SQL Server community come together to embrace, help, and inspire each other, both online and off, has been amazing. If you haven’t tried to interact with others through LinkedIn, Twitter, Google Plus, or some other social media, I urge you to try in 2012.

    I hope that you have had a great 2011, and I look forward to an even better 2012.

    Steve Jones

    The Voice of the DBA Podcasts