Voice of the DBA

Category: Editorial

  • Who’s Licensed?

    My employer licenses software to users. Many of you might have SQL Compare, SQL Prompt, or one of our other handy products. If you do, you might have noticed that we have a Redgate login for you that shows your licenses and lets you activate/deactivate them. This was surprisingly a big project across the last year to streamline and smooth our licensing process.

    Early on, I realized this was an issue in one company I where I worked. This was during the 1990s and I started working at a small company with a fancy imaging system. We had purchased software to receive all our faxes as images and file them in a digital system. I’m sure we had one of the smallest (and cheapest) installations of this software, which one of our executives had managed to negotiate. However, the exec had left the company and a few months into my tenure, I needed support.

    Finding our account, verifying our status, and re-enabling an old email account were a few of the cumbersome steps we completed to link the software to our organization. As soon as this was done, I realized this process had created a single point of failure, something I’ve tried to avoid as a technology professional. Immediately I set up a new email (licensing@ourdomain.com) and changed our account to this email. In fact, in all future purchases of software and hardware, I linked all support, warranty registrations, purchasing contacts, and more to this email. I also had this email forward to both myself and the CFO (he got an email rule set up to file this away).

    Since that time, I’ve tried to use centralized contacts for my employers, ensuring that any vendor contact would outlive my tenure. I haven’t always been consistent, and certainly with SQLServerCentral, I purchased any number of things under my own email, assuming if I weren’t there, the company wouldn’t be. However, I did make sure that I put all contact info in a Password Safe that my business partners had copies of.

    I wonder how many of you bother to worry about longevity when you contact a vendor or purchase software. There are certainly times when a personal email makes more sense (research, working to craft an ROI), but for formal contacts, and registrations, a more generic contact might make sense.

    Actually, I’d like to see more vendors take this approach, building their CRM and sales systems to take a general contact and then a list of individuals that might be personal contacts. They could easily add new licenses to this account, tracking them in a central area, perhaps even ensuring that renewals would be a more efficient process.

    Steve Jones

    The Voice of the DBA Podcast

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

  • Data Science en Masse

    GE is an amazing company. They seem to have so many divisions and produce a wide variety of products. Their financial investment success amazed the world and made Jack Welch an icon to many businesspeople. I remember reading about revolutionary management techniques at one of their jet engine plants that dramatically increased efficiency and performance of that location, similar to the ways that DevOps can produce better software. They have transformed the company from light bulbs to televisions to nuclear power and more across the decades.

    And they’re not done yet. GE is building a workforce for the 21st century, teaching many of their employees about data science and machine learning. The company is working to retrain scientists and help them explore new ways of using AI techniques to build better software. There are machine learning and data analytics courses available to employees, with the aim of creating hybrid employees that add digital skills to the knowledge they already have in other areas.

    Why is GE looking to transform it’s workforce with data science skills? They are creating AI software for their products and hoping to expand this further into more areas. With the competition from many other vendors, the ability to generate better results for clients, even just slightly better, might be enough of a differentiator to allow them to continue to grow as a leading industrial company.

    Would this work for your company? Your import organization, service company, retail business? Perhaps. Machine Learning isn’t perfect and doesn’t produce the best decisions, but if it can slightly improve the performance of your organization, perhaps it’s worthwhile. Microsoft is certainly making some of practical elements cheaper with the easy to use with new products, such as Azure Machine Learning.

    The challenge is that this is just the final element. Your company still needs someone that has built some knowledge of the deep mathematical concepts behind machine learning and has spent quite a bit of time experimenting with your data, building models and determining the relevant features needed. Preparing and loading data is also a challenge, which is why I think one of the core skills future data professionals need is the ability to quickly and effectively build ETL pipelines. If you can get those things done, a tool like Azure ML might be just the thing to add a few efficiency (or profitability) points to your bottom line.

    Steve Jones

    The Voice of the DBA Podcast

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

     

  • The Second Best Job

    I think I have one of the best jobs in the world. I get to run SQLServerCentral, focusing on the Microsoft Data Platform, writing articles, experimenting with technology, speaking at events, and more, all with a bit of autonomy. I’ve been doing this job for well over a decade, and I’ve built routines and rhythms that have allowed me to balance work, family, and life. I really enjoy my job with Redgate.

    Redgate also runs Simple Talk, a companion site that seeks to educate and inform the community, just like SQLServerCentral. Simple Talk runs somewhat longer pieces and has fewer newsletters, but it’s a part of Redgate’s effort to give back to the community and help our current and future customers get better at their jobs. And now, we’re hiring a new editor for Simple Talk, which means the second best job in the company has an opening.

    This isn’t necessarily the easiest job, and it does take a certain kind of person. I’ve told many people for years that almost anyone versed in SQL Server could do my job for a few days, but few could do it for a month. Or maybe, few would want to do it for a month. Producing new content on a regular basis, handling some of the tedious duties of an editor, these can be difficult tasks for many people over time. Even managing yourself (we need an independent self-starter) can be a challenge.

    We have a great team in marketing, and Redgate is a fantastic company. The highest praise I can give them is that they have been the kind of company I’d want to build if I were to start a new venture. There are great benefits, you can work from home and work with autonomy. Plus, you get to work with me.

    We need good technical skills, strong communication skills, and someone that wants to help grow the site even further. If you think this might be your kind of job, think about applying. Who knows, maybe the second best job could be yours.

    Steve Jones

    The Voice of the DBA Podcast

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

  • Auto DevOps

    As much as I like DevOps, this scares me. There are a lot of employees (20%) at BMW that are software engineers. They want to increase that to a larger percentage, which I assume means that we’ll have more and more code in our automobiles, with more systems tightly integrated. We’re even gathering more and more data in modern vehicles. Maybe there are good database job opportunities for some of you with automakers.

    If there’s one thing we’ve learned in a few decades of writing software, it’s that large monolithic systems are a mess. They contain vulnerabilities, and more importantly, they are very difficult to patch and change. All of the DevOps success stories I’ve seen from large systems have either been a complete rewrite, or a long term refactoring that removes dependencies and tight couplings between modules.

    In cars, we’ve seen all sorts of hacking issues. Hackers can attack a vehicle remotely and a faulty (or hacked) update might leave you in trouble. Granted these things aren’t that likely, yet, though I think this piece understates the potential problems. I think that because once a hack is discovered, how sure are we that a) it will be reported to vendors (hackers might just exploit it), or b) that a fix will certainly be developed that works well and doesn’t cause any issues (remember 10s of millions of lines of code current year cars), and c) consumers will apply the patch. That last item worries me, especially if cars become more connected and share data about operation or as we move to autonomous (semi- or total) vehicles.

    Personally I’m not against code in vehicles. I’m not even against some connected systems. What I am against is a monolithic, tightly coupled system. I don’t want engine control or drive by wire sharing a network or code with a CD player or navigation system. I don’t want one computer controlling vehicular functions, entertainment, and climate control. I also want to be sure that there is some protection for all this data, to be sure it doesn’t overwhelm any system. I’ll also admit I like idea of upgrading or replacing parts from different vendors, some of whom might do a much better job of building systems.

    We’ve learned a lot about software and complex systems. While I don’t want all manufacturers to use one system or have tight regulations, I would like to see some mandates that separate critical systems from each other. Both in code, and physically. We don’t need to specify code standards, or encryption, or any details, but let’s ensure that a base bar of building software is being used in any of the mass produced vehicles, planes, trains,  automobiles, or anything else of substantial size that is operated by the general public.

    Steve Jones

    The Voice of the DBA Podcast

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