Voice of the DBA

Tag: databases

  • The Cloud

    I like the cloud. It’s very handy for a lot of the things I do. I like having backups restored for my iPhone upgrade. I appreciate having my documents synced through Evernote, Dropbox, and OneDrive (formerly SkyDrive) automatically moving to new machines. These services are incredibly convenient and handy. I expect that my mail will be accessible from multiple machines and my blog posts can be created, edited, and published from anywhere. Many of us work in a similar fashion, using the cloud as a service construct in much of our lives. In fact, many of us expect our own knowledge will be supplemented by the cloud. We use Google to search, getting us syntax,  solutions, or ideas from sources that we expect to just be there.

    Someone was talking to me about their concerns with the cloud recently. This person thought the cloud would be a fad that passes quickly and businesses will get back to owning, hosting, and managing their servers from the bare metal up to the network connection. I disagreed, and not because I use the cloud personally.

    I remember setting up a web server in 1996 for a company. I remember installing an email server in 1999. I would never do either of those things again for my own company, and I wouldn’t expect it from most companies. These days we’ve learned that email can easily be handled by a third party and more and more companies are using email services instead of managing their own systems. Web servers are mostly a shared service that we rent from any number of other companies, sometimes even stitching together a presence across multiple providers. Even many companies that want to manage their own host operating system are turning to third party companies to manage the hardware and networking. More and more we accept renting the things we need from others.

    We’ll get there with databases as well. Not all databases, but more and more of them will be hosted at third party companies. Whether this is in some type of VM environment or a service that hosts data, it will still be hosted at a third party. We will have concerns and we will have reasons to not do this, but I think for more and more of our data, we won’t care.

    Companies have lots of systems in place. They have legacy investments in infrastructure and facilities. In those cases, it’s hard to justify the cost of cloud computing. However as we grow into new areas, or with new companies, we’ll have to re-evaluate whether it is a good idea to continue to make those investments. As the management of software grows to allow the quick scale up and down of assets, I think we’ll be much more likely to consider moving applications into the cloud than ever before.

    We’ll never be 100% in the cloud, or out of it, in the future, but increasingly, we’ll be partners with the cloud.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 3.4MB) podcast or subscribe to the feed at iTunes and Mevio . 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. Support this great duo at www.everydayjones.com.

  • Looking to 2014

    It’s amazing to think that 2014 is already here. We’re 13 years past the fictional 2001 and now 4 years after the 2010 movie sequel. I’d still guess that those movies should have been set another 100 years into the future, given where we are today with technology. We start a new year today and I wanted to look forward to guess where the data world might go in the next year.

    As I think about SQL Server in 2014, there’s one big item that will change; we’ll have a new version. SQL Server 2014 will be released, and while I don’t think there are a lot of changes coming, there are a few noteworthy items. The two biggest items that I see coming with SQL Server 2014 are the In-Memory-OLTP Tables and writeable columnstore indexes. There are many other improvements to Resource Governor, Azure integration, incremental statistics, Power View, and a few more. However overall, it seems as though this isn’t worthy of a full release to me. There are two big features, but most of the rest of the changes feel small and incremental.

    In the rest of the data world, I see 2014 as a ho-hum, continue along the path evolution. We will see lots of people realize the Hadoop is more of a solution in search of a problem than vice versa. Hadoop works well, but it isn’t necessary for most problem domains and might be more work and cost than is needed. I suspect we’ll find that many people are also trying to use the various NoSQL platforms as a magic bullet to solve some problem they have and will realize that they really haven’t attacked the problem properly. Most of the time it’s not the platform, it’s their approach and changing platforms won’t fix that.

    I do hope that people continue to experiment with, use, and write about NoSQL platforms. We need to learn more about where and when these platforms are useful. I saw 5 database predictions from Michael Stonebraker recently and overall I agree with them. We will see more options for solving data problems, and more often than we expect, we will find that multiple solutions can, and perhaps should be, used. However we shouldn’t use platforms to use platforms, and we certainly need more expertise.

    I do think we will start to see more interesting hardware being released in 2014 and beyond. Tablets are maturing and I suspect by the end of 2014 we’ll have many, many choices from manufacturers of different sizes, form factors, and types of convertability for laptop devices. I suspect we’ll the line between phone, tablet, and laptop will continue to blur, and while I’m not sure we’ll get more types of new devices than watches or eyeglasses, I am hoping that we see more creative attempts. Personally I’d like to see new monitors that can project onto glass or semi-transparent surfaces and still handle touch (ala Minority Report).

    Finally, I think that Microsoft will truly abandon the RT experiment and move to a dual desktop Windows and Windows Phone platforms. They’ve talked about a unifying platform, but I don’t see that working, and certainly not in 2014. However I am hopeful the restructuring at Microsoft will have Windows Phone moving to take over phones, some tablets, and perhaps even some laptop-style devices while Windows on the desktop and server will scale from hundred-core multi-terabytes of RAM servers to tablet style devices. Perhaps even with the option to turn off all touch-screen like items. At least, that’s what I’d do.

    I look forward to 2014 as the start of a new year and with the optimism that I’ll be surprised and amazed at some point by technology.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( MB) podcast or subscribe to the feed at iTunes and Mevio . 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. Support this great duo at www.everydayjones.com.

    Follow Steve Jones on Twitter to find links and database related items and announcements.

  • 2013 in Review

    Last year I took a few guesses about 2013. I was right about smartphones, and encryption has slowly become more important late in 2013. BYOD has become a hot topic that continues to be a problem, but I think most companies are resigned to the fact that they’ll have to accept and co-exist with personal devices in the workplace.

    As far as SQL Server goes, it seems more and more companies are looking to implement SSD storage, but I’m not sure it’s the standard for new hardware. I see plenty of people still stuck with spinning disks as part of their SAN storage, or even in local disks. We didn’t move to dedicated SAN storage for SQL Servers, at least not in any large wave. However there has been trends for some companies moving away from SANs and back to local storage, especially for the people that are thinking about flash storage, like the FusionIO cards.

    It has felt like a quiet year for SQL Server in 2013. Microsoft is in between releases, with 2012 slowly maturing this part year as people adopt it, find issues, and publish guidance, solutions, or workarounds. Some of us have been following the upcoming SQL Server 2014 release, but that is still months away from RTM. There were two big changes with SQL Server this year: HDInsight (Hadoop) and the growth of SQL Server in the Azure cloud as Windows Azure SQL Database. While both of those were used by a small group of SQL Server pros, they have dramatically expanded the cases and situations in which SQL Server can be used.

    In the SQL Server community, I don’t think we had any radical changes occur. We had a lot of SQL Saturdays in 2013 ( 84 by my count), a new conference (SQL Interesction) along with ones we’ve had for years (SQL Bits, PASS Summit, SQL Connections). We continued to publish lots of information at SQLServerCentral and Database Weekly, and there was no shortage of new bloggers and writers sharing their knowledge with the community.

    In the database world, there was continued media attention given to a variety of RDBMSes and NoSQL platforms, but all the news has felt evolutionary, not revolutionary. The world at large continues to underestimate the importance of data and data professionals, but slowly more managers and companies are having more respect for the jobs that we do. However, despite the many people that were awarded MCMs before the termination of that program, I still find large numbers of SQL Server professionals learn the bare minimum they need to acceptably do their job. I keep hoping that the efforts of sites like SQLServerCentral and events like SQL Saturday will change that, but it feels like we’ve barely made a dent in our profession.

    However we’ll keep trying, and encouraging people, and I hope you continue to do the same.

    Steve Jones

    Video and Audio versions

    Today’s podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

    Follow Steve Jones on Twitter to find links and database related items and announcements.
    Steve Jones Windows Media Video ( 20.9MB) feed

    MP4 iPod Video ( 23.9MB) feed

    MP3 Audio ( 4.9MB) feed

    Feeds are available at iTunes and Mevio

    To submit an article, rant or editorial,
    log in to the Contribution Center

  • Mining for Quitters

    This editorial was originally published on Jun 10, 2009. It is being re-published as Steve is on vacation.

    I thought this was pretty interesting, a story about a story about Google trying to figure out which people are likely to quit. Apparently Google is worried about losing talented workers, like  those they’ve taken from Microsoft, Yahoo, and other places. Actually they haven’t taken anyone. They built a company that excited people and anyone that wants to get a job there (and can), should be allowed to go work there.

    Some people have decided they don’t want to stay, and quite a few executives, and Google wants to try and see if they can keep them. So they are looking for signs that a person might think about leaving, and then hopefully doing something about it. And in typical Google fashion, they’ve built an application that crunches data to identify those people likely to leave.

    I think it’s great, especially in an age where it seems so many companies don’t care if you stay or go. While there’s no guarantee that they’ll be able to convince people to stay, at least they can make an attempt to convince them. Sometimes that’s all takes. Show someone that you care, and that you want to keep them around, and many times they might decide to stay. And perhaps it’s in response to this note that the Justice Department in the US considers any agreement among tech firms illegal. Even if it’s an understanding not to poach each others’ executives.

    With any technology, there’s a flip side as well. Who knows if employees at Google will try to “game” the system, fake the data that shows the might leave, and then see if they can get a raise or some other benefit from the company. It might not work for all employees, but it might work for some.

    It will be a flawed system, but it’s a good idea. It’s a good use of business intelligence computing to try and protect the company’s most valuable assets: its people.

    Steve Jones

    The Voice of the DBA Podcasts

    Everyday Jones

    The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

    You can also follow Steve Jones on Twitter:

    Overall RSS Feed:  or now on iTunes! 

    Today’s podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

    I really appreciate and value feedback on the podcasts. Let us know what you like, don’t like, or even send in ideas for the show. If you’d like to comment, post something here. The boss will be sure to read it.