Voice of the DBA

Author: way0utwest

  • Learning Data Modeling

    Last week I wrote about database design tests in interviews. Many of you noted that you hadn’t been asked to perform any design in tests, and plenty of you noticed that ER diagrams are a rarity. Those experiences match mine and are a little disappointing for our industry. Even for software developers, many of whom don’t build databases, I’d expect that ER diagrams to be helpful and plentiful. Our clients are often developers and report writing businesspeople. Why don’t they demand better documentation?
    If they were to ask for us to produce ER diagrams and documentation, I’d hope most of you could produce one, even using SSMS or some other tool. However, can you design the storage for your business requirements in a way that you would feel comfortable presenting to your peers? Do you think you can build a database that efficiently stores data, performs well, and is easy for application developers to work with? If so, I have a question.
    What resources would you recommend for others to learn about data modeling?
    We have a dearth of database design articles on SQLServerCentral, though we do have a Stairway Series on Database Design. I don’t know how easy it is for most developers, or even database architects, to read and understand. I realize that modeling and designing databases can be complex topics, and it does take some effort to learn to do it well, but I also believe that we need practical, easy to approach articles that lead people through the concepts.
    I’d love to see more articles from real world people that discuss designing sections of databases. How do you handle scheduling systems? Inventory tracking? Customer details? If anyone wants to write articles that might lead a reader along (such as Paul White or Brandie Tarvin did), we’d love to have them submitted at SQLServerCentral.
    Steve Jones

    The Voice of the DBA Podcast

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

  • The March of AI

    Machine learning and AI systems are becoming more and more popular all the time. The constant onslaught of media articles and hype is pressuring more and more companies to experiment with AI systems. Whether these techniques work or not, no manager wants to be the one that has ignored the trend. A failed machine learning venture might be preferable to the lack of any project in the eyes of many in upper management.

    Our vendors press as well, after all, sales are on the line. I wasn’t sure how useful the R language would be inside SQL Server, but I am amazed at the effort and popularity of R among SQL Server professionals. R, and possibly Python soon, are becoming integrated into every product and tool from Microsoft, as well as other vendors. Every month I see more and more people experimenting and learning how to use R for a wider variety of tasks, from analyzing disk space and database performance to extrapolating business measures.

    Most of us aren’t skilled enough in math and statistics to really develop and build intelligent systems. We don’t have the background, or we haven’t worked in those areas for a long time. However, many of us can learn to work with ML and AI systems, managing the models, integrating the code others write into our applications. I do think there is value in learning a bit about these technologies, though I don’t think you need to become an expert. Some of you might want to be experts, and I wish you the best of luck on your journey.

    I do believe that AI will change the world. It’s going to become a larger and larger part of many systems and processes throughout the world. These intelligent systems will press and push humans in ways that we don’t expect and that we might not like. For us data professionals, we will be at the heart of many of these changes, with opportunities to grow our careers we might never had considered.

    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.

  • Becoming an MVP

    “Climb the mountain to see the world, not be seen by the world.” – from Tim Ford.

    This past July 1 was the renewal date for a number of Microsoft MVPs. The program has changed in the last year, moving from a quarterly nomination/renewal to a monthly award. The first of every month moving forward will see new MVPs awarded. All MVPs are now renewed on July 1.

    For existing MVPs, we had a bit of a change, and some of us were up for renewal this year, and some next year. I happened to move from my Jan 1 date to next year, so that’s when I’ll find out if I am going to be recognized by Microsoft again.

    There were a few surprising changes last week, when a few people were not renewed as MVPs. I expect that the bar for being an MVP has been raised, with so many more individuals participating in blogging, speaking, software, and more. The level of community participation in 2015 might not have been enough in 2016 to be renewed.

    How do I Become an MVP?

    “Climb the mountain to see the world, not be seen by the world.” 

    As the quote notes, you should tackle the challenge without any concern about whether or not the world, or Microsoft in this case, notices.

    Help the community publicly. You can do this in many ways:

    • Write technical articles
    • Speak at technical events
    • Organize events
    • Build OSS software
    • Answer questions online

    There are any number of ways to be a community person, but do so because you want to. Become the best technical community person you can, and you won’t be sorry.

    If you meet some bar, and are nominated (feel free to ask others to nominate you), then you may be awarded, but you should help others because you want to. Not because you expect to be repaid with an MVP award.

    Help others because you want to help others, not because someone will see you helping.

    Once an MVP, always an MVP

    The people recognized by Microsoft are chosen based on their community contributions in a period of time. However, these are smart people who are capable, helpful, and friendly. They will always be an MVP to me, and likely always willing to help. They continue to learn, teach, and expand their knowledge of technology.

    They can always remember that they were recognized as an MVP by Microsoft, even if they aren’t today.

  • SSoL–Exiting Root

    I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember the skills I used to have back in university.

    There are times you need to execute a bunch of commands as root. Rather than sudo x, sudo y, sudo z, you might just sudo –i to change to root.

    For example, I often will do this:

    sudo apt-get update

sudo apt-get install mssql-server

sudo systemctl start mssql-server

    I could just run those as root. However, when I’m done, how do I get back to my normal user? It’s been a long time, so I had to look it up. I wrote this post so I’ll remember since I don’t use Linux daily.

    2017-06-15 10_05_14-Ubuntu 64-bit SQL Server .210 - VMware Workstation

    Type

    Exit

    That’s it.