Tag: misc

  • The End of 2017

    This is it. Today ends 2017 for most of us at work and when we come back on Tuesday, it will be a new year. It’s kind of amazing to think another year has gone by, though it’s been a long year for me. I can barely remember last New Years, though I know I was skiing this time last year with my daughter. Maybe I’ll get the chance to do that again this weekend.

    This has been a busy year, full of SQL Server and database changes. We got a new version of SQL Server, and a new platform with the release of SQL Server on Linux. This has been in the works for quite some time, and I’m glad it’s come out. I keep seeing more people interested in working on the Linux platform, so I expect this will be more popular than I might have guessed. We also got the addition of Python as a languge inside SQL Server, which is cool. I like it better than R, and I expect we’ll see more and more Python code inside the platform over time. Add to that the addition of graph capabilities, and SQL Server is becoming a more well rounded platform.

    As is the case most years, security issues continue to haunt us. More data breaches, including a wide reaching set of lost data with the Equifax issues. I had hoped this would stir the US to move towards something like GDPR, but so far nothing has been done. We’ll see how GDPR affects things, though I see plenty of Redgate customers asking for features and support that will ensure they are compliant. We’re hard at work, as are many other vendors. I hope you are as well. This reminds me of the year 2000 efforts, though at a smaller scale. Now we don’t have an unknown issue as far as technology goes, but we might still have business problems if our organizations violate GDPR. I expect late 2018 and 2019 to be boom years for European solicitors.

    What seemed like a set of niche technologies, AI, ML, and bots, seem to be growing more and more important all the time. I’m somewhat amazed at how often I see talks on these topics, from both consultants and vendors, who are building systems. As I’ve looked into these areas, I’m surprised at how widespread the use of machines is already, doing work that I thought humans were doing. What’s more, the demand for data has grown tremendously in order to feed and train the systems that people are building. FWIW, supplying training data has become a big business, and I’m sure we’ll start to see yet more data about us being sold and compromised as companies seek to build more helpful systems. Helpful to their business, perhaps not to us as individuals.

    In any case, I see more and more posts and experimentation from data professionals that are using the R language, Power BI, and other tools to better analyze data. While writing reports and creating queries has been something many of us do, I think some of our colleagues have found that producing more complex data visualizations is a way of adding more value to the skills they bring to an employer. With lots of deeper analysis in the news, I think that the management in many companies appreciates this and may expect it from future employees. Something to keep in mind.

    There has been plenty of technological change, but overall the year seems to have focused on many soft skill matters. With the awareness and outrage over various behaviors by those in power, I wonder if we will start to see changes in our industry. I’ve been proud of the Women in Technology efforts from PASS and others across the last few years, and I hope we continue to grow and evolve to treat each other as the capable professionals we are. I also am glad to see more and more tech companies and events embracing a more professional, less bro-grammar culture.

    It’s been a long year, and an interesting one as DevOps continues to dominate the world of software development. I hope to see that continue, especially as my employer has devoted a lot of work to help include databases any DevOps culture. However, as I heard recently at SQL in the City, DevOps isn’t an excuse to ship more crappy software to customers. That include databases, so as you move forward, perhaps at a quick pace, don’t forget to evolve your database in line with well known and well documented database design principles.

    2017 has been a good year, and I look forward to 2018. Happy New Year, have a safe holiday, and I’ll see you in 2018.

    Steve Jones

    The Voice of the DBA Podcast

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

  • Back to Work

    It seems like it’s been a long time since I wrote any SQL code or did any work. Two weeks ago I was in the UK for SQL in the City, which was a lot of prep work when I arrived with little actual work on the site or with customers. The few days after the broadcast involved meetings and getting ready for the annual Redgate Christmas Party and company awards. I was hosting, so I had to practice and prep for the night. It went well, with everyone indulging me with an on-stage selfie:

    IMG_3405

    Last week was another trip, my final of the year, but a good one. I was luck to spend a week unwired with my wife in Athens. We enjoyed the time, and got to relax without commitments, something that I don’t do often. We didn’t do much except enjoy the time and sights.

    Now it’s back to work after Christmas. I’m ready to go, though that might have something to do with my body still being on GMT time, but in any case, I’m ready to fire up SSMS and do some work.

    Merry Christmas, Happy Holidays, and Happy New Year to everyone.

  • Interviewed

    I got sent an interview by Mohammad Darab, a fellow SQL Server professional in Northern Virginia. I thought the questions were interesting, and spent a bit of time on them. You can read the interview here: https://mohammaddarab.com/interview-steve-jones/

  • The New New World

    Star Trek Discovery premiered this past week as a new entry in the Star Trek series that has been a part of my life since I was a kid. I was enamored with the idea of exploring the stars, meeting new civilizations while maintaining a strong ethical stance about not interfering with their development. The idea of beaming up to a ship instead of dealing with long shuttle flights seemed like something I’d like, especially as I sat on a long bus ride to and from school for most of my youth.

    Since then I continue to dream about Star Trek technologies, which are still likely as far in the future as I thought as a kid. These days I wouldn’t want to go to space without artificial gravity, and I feel that the HoloLens, which interesting, is still miles away from any sort of Holodeck. Even the advances in speech technology, across many devices and slowly becoming more and more ubiquitous, don’t seem to be anywhere close to the fictional computers on board the starship Enterprise. I still can’t see how a general purpose speech device in a crowded area would work. Unless we all have our own moment to speak our lines.

    There are so many ideas about the future of technology and where we might go. I know that in some ways my imagination of the Jetsons, Dick Tracy, and Star Wars aren’t anything like what we have today, well, maybe Dick Tracy has come true. We are barely in space, we haven’t gotten anyone to another planet, much less explored other galaxies. We have computers that are way more reliable, but software that is maybe not quite as reliable, and certainly VR far behind what many science fiction writers imagined. Communications occur at a rate I’ve rarely seen in fiction, though with a darker overtone than I ever expected or like.

    There are still dreams out there, and plenty of thoughts and views of the future. Some sad ones, some scary ones, maybe some exciting ones. Most views are so far in the future, with plots that are too outlandish, but there are slices and glimpses of technology that could come true. Maybe instead of quick subspace orbital elevators we might get lots of hyperloop transport. Perhaps we won’t have warp drive, but is it possible to get people onto Red Mars?

    I don’t have any great predictions about the future. I tend to see more the downsides and problems that technology can bring us, especially with more data being captured. However, maybe you have some ideas. Can you come up with something that you think our children might experience?

    Steve Jones

    The Voice of the DBA Podcast

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