Author: way0utwest

  • Honored to be a Microsoft MVP

    Today is the renewal date for Microsoft MVPs. I received an email a short while ago informing me that I was being awarded again for the July 2019 – June 2020 timeframe. This is my twelfth award, and I’m quite honored that I was chosen again.

    If you don’t know about the award, you can read more on Microsoft’s MVP site. This is a community award for your efforts to promote and help others work with Microsoft products. I’ve spent a lot of my career in this area, as have many others. Often these are the people that write and speak often, and are friends I get to see at various places all over the world.

    Microsoft wants to recognize people that do a great job, but there’s a limited budget for doing so, and they pick who they feel are the top contributors, even though there are many more that don’t get recognized.

    I want to congratulate all those awarded the MVP designation, whether today or in the past. I also want to thank those of you that answer questions, speak, write articles or blogs, and more to help the community. Many of you have taught me something over the years, and I appreciate all your efforts.

  • The Road to Better Data Handling

    Recently I was on an internal communication thread with multiple people at Redgate Software. We have various ways to keep our (semi-) distributed teams in touch with one another and handle issues. While email works, I think many people like Slack better for quick discussions. I appreciate that as a remote worker since I’m not around to hear a conversation around a desk. To be fair, with a busy staff, others often aren’t as well, so a thread in Slack often saves details others can see later.

    In any case, we had some issue. I don’t know if this was a product issue with a customer or a communication item for our marketing group. No matter what it was, we had someone mention they could help if the first poster would provide details. The next message that I saw was great. It said something along the lines of

    “Please do not post email details in Slack.”

    A gentle reminder, but one that was needed. It’s great that we want to help others and work through problems, but in many companies we’ve played far too fast and loose with data. Not necessarily technical people, but often our customers have. Many of them will put sensitive information in “notes” fields in our databases. It’s a hassle when we want to work with data that hasn’t been put in a normalized space and must extract it somehow.

    It’s also a source of data leakage. While we might appreciate saving a quick note, these aren’t secured communications, and more importantly, they provide yet another attack vector for problems if we lost control of the backups, archives, etc. Even worse, we could have gotten a request to remove emails and we now have another security risk with the email email searchable in old Slack messages.

    This is likely a bit of an extreme example, but still a place where data handling should be better. We have secure systems for tickets or issues where we can store data. Or we can reference their information in another way. I’ve started doing this in GitHub, where we often log issues for SQLServerCentral users. Rather than putting in an email, I’ll put a user ID or other identifier. If the user wants to delete their account, I don’t want their email floating around anywhere it isn’t required.

    While it might be a bit more hassle to be careful with personal information, I think it’s much better than treating it as unimportant and potentially having it disclosed in some security incident. Whether it’s my email, tax ID number, or credit card, I’d want my own data handled carefully and am trying to do the same for others.

    Steve Jones

    Listen to the podcast at Libsyn

  • The Non Profit Cloud

    I ran across someone awhile ago that works with a nonprofit charity. The organization was seeking to move some of their IT infrastructure to the cloud. This person was wondering if Azure had any discounts or programs for charities, and it didn’t appear there was any type of program when I looked. That was disappointing as many charities work hard to help those affected in some way, but budgets and money are always tight.

    I wish I’d know at the time that Microsoft had announced a program that can help. They are donating $1 billion over five years to nonprofits and university researchers. Their goal is to reach 70,000 nonprofits and help them use IT to better serve their causes. This is part of the Microsoft Philanthropy segment of the company and it’s a welcome change to me. I support Microsoft and use their software, but I also am glad to see them looking at more than profits and incorporating some social responsibility into their work.

    I’m sure charities appreciate the assistance, though this isn’t without some costs. Moving applications to the cloud can be expensive in terms of software development, and certainly there are ongoing costs. I’d like to think that the ability to scale resources to meet demand works better in the cloud, and certainly there are some software products Microsoft has that charities will find cheaper in the cloud over time.

    The donations will also help many university projects, which I’m guessing will both gain insights from data analysis in the cloud, and hopefully also help Microsoft (and the rest of us) better understand what techniques for working with data work well and don’t work well in the cloud. I know the Azure SQL Data Warehouse looks interesting to me, especially in terms of building a DW in a way that doesn’t require large on premise investments. I’m hoping to get a chance to take some SSC data and experiment with it there in a limited basis, turning off the systems when I don’t have time to work with them.

    I’m glad to see Microsoft supporting nonprofit organizations, and I hope that I see more GiveCamps and other efforts from software professionals to likewise support organizations that are aligned with their own values.

    Steve Jones

    Listen to the podcast at Libsyn

  • Basic User Functions in R

    As I’ve been learning more about the data platform, I’ve been exposed to some R language code. This makes sense, as more comprehensive data analysis needs something other than SQL. Or at least, some people think that and it behooves me to better understand what they do with R. I’ve also had to build questions for SQLServerCentral, so I’ve spent time working through different R language items.

    One of those items is the function. I first found this strange, but the more I think about it, the more I like this. Rather than some code that is a “create function double”, I actually assign a variable, which is really just some token in memory, to the function. I could do this as:

    double <- function(x) { x * 2 }

    This means the variable double contains a function, and I can call this as I would any function.

    i <- double(4)

    At this point, i would have the value 8.

    Simple and easy, but powerful. This can get more complex, and I’ll experiment more in future posts.