Voice of the DBA

Tag: career

  • Developers, developers, developers

    StackOverflow ran a survey for their members in 2013 and released some results recently. The results are on their blog, along with some observations about the data. While most of this audience aren’t in the development space, some may be, and the impacts of the results could certainly affect our careers.
    Most developers and applications aren’t getting much accomplished without data, and whether they use SQL Server, another RDBMS, a NoSQL platform, or a dumb data store, chances are we can help them. Chances are also that if they make a poor decision, we’ll be dealing with the mess in some way.
    The observations note that mobile is still growing, and I believe that. I still think the mobile market will dwarf the PC explosion we’ve seen the last 20 years, and that means we should be preparing and understanding how to deal with data from mobile devices, think about scaling to meet lots of small, quick calls for data from a device.
    I also like the fact that more people are working remotely. If they let developers work remotely, that’s a good step towards DBAs becoming remote as well. As someone that has worked from home for over a decade, I appreciate the challenges, but I still can’t help but thing my productivity is much higher than it ever was in an office.
    It’s also nice that the second most popular language (in use) is SQL. Not necessarily T-SQL, as I’m sure various other platforms are developed on, but it does show that SQL is very important, even to developers. Perhaps the next time a developer is struggling with SQL, you can refer them to this survey and then see if you can help them improve their query skills.
    Steve Jones

    The Voice of the DBA Podcast

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

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

  • Powershell in a Month – Day 19 – I/O

    This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

    Not the I/O that we think of in T-SQL, but more the I/O that’s a part of many programming languages. This reminds me a bit of C, with the explanation of how the powershell environment interacts with the user. It’ s not standard in and out, but it’s close.

    This chapter also feels like it was written by a different author than some of the previous chapters. The chapter goes into some of the ways in which output commands interact with the shell, and how some do not. For example, the difference between Write-Host and Write-Output. The chapter uses diagrams of the pipeline to explain this. I was surprised that these diagrams weren’t used earlier in the discussion of the pipeline and how objects and data can flow through the pipeline. That’s a big omission from my point of view. I have a good idea of what a pipeline is, but the diagrams would have made it easier for many other people to understand what a pipeline is.

    In any case, this chapter mostly deals with the relationship between the input and output and the PoSh process. There are mentions of the separation and how other editors might deal with the input and output differently, but not good examples. In some ways, I found this chapter a bit lacking. In a few sections, it seems that the prose is devoted to more about what not to do than what to do and how to build I/O interaction with the user.

    The lab wasn’t great and overall, I didn’t like this chapter very much. Felt a little confusing about how I use this information.

     

     

  • Powershell in a Month Day 18–Variables

    This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

    I’m slightly behind here after holidays and some travel. Apparently my pop-up reminder for my own studies bears about as much value as quite a few other reminders that appear from people at work.

    I’ve had to deal with variables in any number of languages in my career: BASIC, Pascal, C, C++, Java, C#, VB6, VB.NET, Foxpro, T-SQL, and a few more. I thought this chapter would be simple and it certainly started out that way, but I learned a few things and was pleasantly surprised.

    NOTE: The editor here is substituting left and right quotes, and left and right double quotes as part of formal writing. In executing this code, the normal straight quote and double quotes are needed in PoSh.

    The chapter starts out with the simple stuff, assigning values to variables. Unlike most languages,we don’t need to declare variables. You need one, just use it.

    $domain = ‘SSCLab’

    I’ve done this quite a bit in some of the practice for this series, but also in setting up my virtual lab. However I wasn’t sure why single and double quotes matter. If you’re not sure, this this:

    $computer = ‘Tiny’

    $Phrase = ‘Computer: $computer’

    $phrase

    and then this

    $computer = ‘Tiny’

    $Phrase = “Computer: $computer”

    $phrase

    You’ll see a difference. The first produces

    Computer: $computer

    The second actually does substitution and produces

    Computer: Tiny

    That means that you really need to pay attention to which set of quotes you are using in code. That’s an area I need to be careful. I also learned about the backtick as an escape character, but that’s an easy one as it’s similar in lots of languages to escape things out for newline and other special characters.

    What’s interesting about PoSh variables, and probably one of the more powerful things, is that the variables can contain objects. That’s big. It’s like being able to overload classes into variables easily and quickly. I’m sure the exercises just scratch the surface, but it’s cool.

    The lab was easy, just getting a job running and putting results in a variable. A combination of a few of the last few chapters.

  • The Remote Balance

    I still have hope that we will see more and more remote workers in the future. As large companies downsize and choose smaller facilities, and as many new companies start from scratch, we’ll see many of them considering telecommuting to find the best technologists for their openings as well as reduce their infrastructure costs. As noted in the book, Remote: “Today, the new paradigm is move work to the workers, rather than workers to the workplace.”

    I don’t know if we’ll ever get the majority of people working remotely from offices or at home, but I do know that I see more and more people able to get work done outside of a traditional office. I see people checking email and responding to trouble tickets in all sorts of situations, and with all sorts of jobs. I suspect that businesspeople continue to do this more and more as devices and software expand to allow it.

    I saw that quote from Remote in a blog from Scott Hanselman where he also commented on that idea, but noted that we need to strive for some balance. It is great that you can fix a problem at your kid’s soccer game or dance recital, but it’s also important that you attend and enjoy those events.

    Like most tools, our remote access can be good or bad. If you check too often, become tethered to devices, and ignore the real world, that’s bad. However if you leave the office early, get to the game, and get some work done before the action starts, that’s good. Just don’t forget to prioritize the important stuff, which is usually not work. It’s the event you’re attending.

    Steve Jones

    The Voice of the DBA Podcast

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

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.