Voice of the DBA

Author: way0utwest

  • Surface Book

    It’s almost time for me to get a new laptop. I’ve had a Toshiba for about a year, but it’s not held up well. The screen has gotten loose, the trackpad and clickers are not consistenly responsive, the pointer device sometimes drifts on its own, and I have had a couple memory related crashes. All in all, despite a similar travel schedule to what I’ve had the last couple years, this laptop is showing its age quicker than others. These are flaky issues, not easily reproducible, and something that the warranty doesn’t seem to cover.

    As I look to future travel and talks, I realize that I need to find something that might be more reliable. That’s always tricky as it seems people have a variety of different experiences with the same model machine. This last year has made me hesitant to think about chancing a new, or unpopular brand, something I did last year in trying to find a small, lightweight machine that can handle 16GB of RAM.

    I read a review of the Surface Book after two months, which is one I’d like to consider. I’ve been impressed with the Surface Pros, but prevented from using them as I need 16GB on the machine. The Surface 4, on which the Surface Book is based, has that capacity, so I am intrigued. I worried about the new hardware, but it seems that the Surface 4s have been fairly solid. A couple of firmware glitches relating to sleep mode, but I’m hoping those get ironed out in the next couple months. At least I hope they do because I really like the idea of a Surface machine.

    I do suspect that like the reviewer, I’d mainly use the machine as a laptop. That’s what I need, and I’m not a big consumer of media. However the option to use the machine as a tablet is interesting. I had the chance to use Rob Sewell‘s Surface 3 as a notebook with a stylus during a presentation at SQL Relay and enjoyed the experience. There are some nice OneNote integrations, though I’m not sure how often I’d want to take notes on a computer rather than paper.

    However the main contender for me is probably a MacBook Pro. I loved the MacBook Air I had, and was disappointed to move away from it. I also want to do some iOS and cross platform development, which a MacBook would allow. The hardware is solid and proven, and it’s a similar cost to the Surface. I have a few months to decide. If I go MacBook, I’ll wait for the March (rumored) refresh. If I’m unsure that that time, I’ll probably think about the Surface as a backup. Either way, I’ll be in hardware search mode across the next few months, with fingers crossed that my current machine survives.

    Steve Jones

    The Voice of the DBA Podcast

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

  • Happy New Year 2016

    Happy New Year from everyone here at SQLServerCentral and Redgate Software!

    I do hope you’re not working, and enjoying a start to 2016. If you do happen to read this, I hope you are relaxing and have a big smile on your face.

    This year we’ve got a new version of SQL Server coming, and I’m sure lots of exciting new technologies we’ll see released. It’s a new beginning, and a chance to move forward. With that in mind, a simple question today.

    What new technology, language, or skill do you want to improve in 2016?

    Today is a great day to make a resolution and start growing your skills, for fun or profit, in 2016.

    The Voice of the DBA Podcast

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

  • The End of 2015

    I’m off on vacation, so I won’t be able to respond, but I decided to take a few minutes and look back at 2015 before leaving for the year.

    This was a year that seems to have been marked by lots of data loss and breaches. Certainly these were on my mind as I worked on the SQL in the City keynote, but as I’ve been following Troy Hunt, it seems that every week or two he’s uploading more data to HaveIBeenPwned.com. We had some larger ones, with tens or hundreds of millions of account records released. Despite all the press from the Sony hack over a year ago, it seems that few companies have bothered to update their security. In fact, it seems that until they’re hacked, no one bothers to fix fundamental security issues in their systems. Perhaps some companies are doing so in the background, and aren’t being attacked, but I’m not so sure.

    We didn’t have any SQL Server releases this year, but we had lots of news, and an unexpected Service Pack. Service Pack 3 for SQL Server 2012 appeared out of the blue for me. I hadn’t seen much news on it, and had given up on bothering Microsoft about new SPs for versions. Perhaps they’ll continue to build these yearly for supported versions, which is what I hope, but we will see. It does seem that Cumulative Updates have been appearing regularly, with relatively few issues in them, but I’m still wary of using those as the main patching mechanism for critical servers.

    We did have a lot of growth in the SQL Server space, with many features being announced and starting to take shape. If you’re looking to get up to speed, check out our collection of Learning SQL Server 2016 topics, where we try to keep a growing collection of links to help you learn.  I am excited to see some of the growth of SQL Server to include newer features that people want in their data platform. I’m also glad that things like Stretch Database can be used to help manage the ever growing amount of data we have. Of course, encryption is big on my list, and Always Encrypted is something I am hoping gets lots of adoption.

    We’ve also seen Microsoft really pushing the envelope in terms of data analysis. There is a constant set of articles and blogs written about data scientists, and some of us are moving to learn more about how to better analyze data. Microsoft continues to help, with their forays into Machine Learning, the expansion of the Power set of products (Power BI, Power Query, Power View, Power Pivot, etc.), R language integration, and more. I suspect that more and more of us will get the chance to play with some interesting data analysis tools if we want to. Even if you don’t use those to help your business, I have already seen these tools being used to perform index analysis, DBA monitoring, and more. I’d urge you to let your imagination run wild and see what things you might build.

    It does also seem that more companies are starting to realize that their data and its integrity and management are important. Data professionals are becoming more valued, but the skills required are growing. There are more and more services and tools to help us manage systems that I do think the simple DBA that administers backups and security is really on the decline. At some point, our employers will demand more.

    It’s been a good year, and I look forward to 2016. If there are things you want us to help you learn about, leave a comment here, and I’ll review them when I get back from vacation. Have a safe, Happy New Year, and I’ll see you in 2016.

    Steve Jones

    The Voice of the DBA Podcast

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

  • 2015 For Me

    This was an interesting year for me. Certainly a time of change with one kid starting high school, one entering his last year, and one graduating from college. These events signal a bit of a change for me, and have me starting to look forward to a life without kids, where I may work more, or differently, and explore other interests. As I freed up some time, and became a bit excited by changes in learning for my kids, I also kick started some of my learning.

    After lots of puttering, I finally decided to actually get back to writing some code this year. I’ve been working to build small utilities in C#, Python, and M this year. My goal has been to not only improve and expand my skills, but also get back to some software development and observe how this aligns with my work on ALM/DLM for Redgate. It’s been exciting to follow along with the San Diego Tech Immersion Group, Pluralsight, and even the Advent of Code.

    In terms of travel and vacation, this was a pretty good year. Despite some long trips (two 10+ day journeys), I managed travel pretty well overall. Still a bit much as I was worn out by the time November hit, but I learned a few things. I am managing things better for 2016 already, limiting the number of trips I’ll take. I also managed to take almost all my vacation, and spend a few different trips with family. I’ve got at least one big family trip planned next year, so I don’t feel bad about carrying over the 3 days I have left.

    Career wise, I’ve enjoyed some of the changes that have come along in my work with Redgate. I do more development than administration, which I enjoy. I started more as a developer, so getting back to those areas, at least for a year or so is nice. I’m looking forward to some of the changes at Redgate, and am especially interested to see where we go with Ready Roll. I really like the product and that style of work.

    I’m certainly getting older, and felt my age this year more than ever. I struggled to run, even sporadically, and while my surgically repaired knee is fine, I think I hurt the other one playing baseball. We’ll see how it does over the winter with snowboarding, but I am more conscious of how I work and take care of myself than ever before. I think 2016 will be a rededication to building more muscle and improving health. In line with that, I think I may actually get a real standing desk I can adjust to allow me to go up and down during the day. I don’t mind standing too much, but I do get a little worn out and I’d like to have my desktop and laptop set up semi-permanently in one environment. Right now I drag my laptop to a couch or table, which isn’t ideal.

    All in all, a good year. Hope it was the same for anyone reading this.