Author: way0utwest

  • Contracting for Work

    Throughout my career, I’ve primarily been a full time employee for an organization. I have worked for myself, as well as for consulting companies. For the latter, I’ve been an employee as well as a contract worker. There’s a bit of difference between those, at least in the US, and it isn’t always easy to understand what that means for an individual.

    I thought about my various experiences while reading about Jon Shaulis’ T-SQL Tuesday post recently on changing his mind about contracting. He also has a section on T-SQL (bonus points for Jon), but the post is mostly about contracting and employment. Jon talks about some of the differences he’s seen between working for someone as a contractor and as an employee. His experiences are similar to mine, but I certainly wish I’d had a good list of these things when considering job offers in my 20s.

    There are lots of people in our #sqlfamily that have started consulting businesses, wanting to work for themselves and make more money. You can read various accounts of how well this works, but it certainly isn’t as smooth for everyone as it might seem. I like reading Brent Ozar’s yearly evaluations, and I’ve been following Eugene Meidinger’s journey as well. These aren’t about contracting too much, but they do give you an idea of what it’s  like to operate your own business, and as a contractor, you are your own business, though you have a little less of the “business” stuff to do since someone does the admin, selling, and marketing and just tells you what to do.

    I actually encourage everyone to consider themselves and contractor and don’t get too complacent with your job as an employee. You never know when you situation will change, and it’s good to be prepared. It might not even be you, as your spouse or partner might force you to make a change.

    Or your employer might.

    Just like a contractor might have one client for 10 years, I think it’s prudent to keep an eye on the environment and be prepared to find another client if some unforeseen event occurs. The days of single company employment for life are over for most of us. I have the best job, but I keep an eye on the market. One never knows when things might change for them.

    Deciding how to structure your employment is a decision each of us should make, but do so with an open mind and some understanding of the changes for work, benefits, savings, medical coverage, and more. While Jon has a good list, I’d love to see more people build and publish a structured checklist in terms of decisions and costs, even sample ones. This can help others get an idea of what the impact might be on their life when making a decision like this.

    No matter whether you choose to work for an organization or as a contractor, it’s not a final decision. You can change your mind anytime, though do so with some planning and consideration of the impact on you and your family. It’s not an easy decision, but you should be comfortable with your choice when you finally do make it.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Make the most of your PASS Summit Evenings

    At this year’s PASS Summit, I’ll only be around for a short time, and really only Monday night. I have two pre-cons to do and then need to get home for some personal commitments. I am hoping to make the first of these events, but if you’re there all week, I’ve got two things for you to attend.

    Monday Night Networking

    Years ago Andy Warren and I (mostly him) set up a networking dinner on Monday night. The idea was to get people together that were there early and have them socialize and meet fellow professionals. We ran it for a number of years before handing it off to Lisa Griffin Bohm, who continues to run it now.

    This is listed as one of the community events, and it’s on Monday, Nov 4, at the Tap House on 6th. It’s from 5:30-8:30 and I’m going to drop by and say hi.

    You can sign up here, and I highly recommend this if you don’t have plans. There are free tickets, but this is mostly to manage the flow of people. This is buy your own, but it’s a fun time for everyone.

    Come meet some people and share a drink or dinner.

    Game Night

    Another idea from Andy and I (again, mostly him), but this one was fun. We decided that we didn’t want a loud night in a bar that some vendor hosted. We knew lots of fellow attendees felt the same way, so we hosted a game night in a room at the Convention Center. Quiet, bring your own games or join in with others. There are lots of gamers out there and some really fascinating games.

    To ensure we can cover a bartender with both non-alcoholic and alcoholic drinks, tickets cost something here, but the tickets can be exchanged for a drink.

    Kevin Hill hosts this now and there are two nights. Sign up for Wednesday with Kevin or Thursday with Matt Cushing (or both nights).

    Community and Vendor Events

    PASS doesn’t run a party anymore, but there are lots of things happening all throughout the week. There are a number of events (including those above) listed on the PASS Community Hosted Events page. Click the various boxes at the top to see different events that are happening.

    I urge you to engage in some social event. Something quiet, something fun, it doesn’t matter. Just meet and network with others. If nothing else, sit with someone at lunch and then ask if they want to get a quiet (or not so quiet) dinner later.

    Or set up your own event. A number of these events are started by someone in the community, and the next fun thing could be yours.

    One hint: if you want to attend a vendor party where things are paid for, go have an honest conversation or two with a vendor in the expo. Ask them questions, learn what their products do, and see if something might help you at work. Regardless of budget, educate yourself and maybe you’ll get a ticket to one of their evening parties.

  • Republish: Have a Think

    Traveling to London today for the SQL in the City Summit, so you get to Have a Think

  • Arrays in PowerShell–#SQLNewBlogger

    Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

    This isn’t necessarily an expert post, but more a recognition that I learned something. I knew about objects in PowerShell, but I’d never actually used an array. Never had a need.

    However, while writing my article about striped backups, I ended up using arrays. This was mainly from the example shown by Anthony Notencino in his Restoring Backups from Azure Blob with dbatools.

    Here’s a way to initialize an array:

    $a = @()

    If I look at this, I get nothing back, which makes sense. There’s nothing in there.

    2019-10-10 14_41_05-cmd - powershell

    I can “add” values to this array with +, as in:

    $a += 1
    $a += 2

    If I now look at the variable, I see this:

    2019-10-10 14_44_41-cmd - powershell

    One interesting thing here is that += is different than Add(). Look at this:

    2019-10-10 14_52_15-cmd - powershell

    So why does += work? In the array doc, there’s this quote:

    When you use the += operator, PowerShell actually creates a new array with the values of the original array and the added value. This might cause performance issues if the operation is repeated several times or the size of the array is too big.

    Worth knowing this. I think for most scripts this isn’t a big issue, but be aware that you are allocating a new array.

    Working with arrays is a topic for another day, but this is a short look at how you might store something like a list of files in a single place.

    SQLNewBlogger

    While working on solving the problem for a customer, I realized this was a little thing I learned. A quick post to show that here, just about 10 minutes or writing and structuring code.

    A good chance to give an interviewer something to ask you. Write your own post on arrays.