Author: way0utwest

  • Code from Redgate Streamed

    I presented a session today at Redgate Streamed and did a number of demos. The code consists of a few flies, which I’ve made available here: BasicUnitTesttsqlt.zip.

    This consists of:

    • 00_tsqlt.sql – Creates a database and adds the tsqlt framework.
    • 01_GetTesting_tsqlt_Setup.sql – adds objects you need.
    • 10_SQT_SQLCop_Demo.sql – The standards test demo
    • 20_SQT_RefactorArticles_MetaData.sql – Testing a table API
    • 30_SQT_RefactorArticles_IsolateProcedure – Test a function and procedure separately
    • 40_SQT_RefactorArticles_Exceptions.sql – Testing edge cases and bad data
    • 50_SQT_RefactorGrouping.sql – Sample test class breakdown
    • 99_SQT_Cleanup.sql – cleans things up

    You do need to have the SQLCLR enabled, and you will enable TRUSTWORTHY for this test database.

    Any question, let me know.

  • Daily Coping–2 Apr 2020

    I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

    The tip for today was to notice five things that are beautiful in the world around you.

    I’m writing this a day or two in advance, so here goes.

    I like to take pictures. My wife laughs at me, but I find these to be nice reminders of life over time. Sometimes I just flip through them. In any case, here are some beautiful things.

    I’m leaving out friends and family, as those are certainly beautiful, but I tried to think and notice things that were in my life, but I sometimes don’t think about.

    The Wide Open Spaces

    I love Colorado. I love being outdoors, but of all the places I’ve lived, I enjoy Colorado. The dry air, the changing seasons, the openness of my ranch. The view is often the same, but walking around the other day, I find this to be beautiful.

    20200329_104916

    The Sky

    The sky in Colorado is often sunny (300+ days a year), it’s big and expansive, and it’s beautiful. Even as much as I see it, I still like looking at it’s beauty.

    20200330_131654

    My Guitar

    I’ve owned a few, but my wife bought me this one a year ago. I’ve enjoyed messing around on it, and I spent a lot of time during my sabbatical practicing. I built some skill, confidence, and found joy again in making music.

    I’m not great, but I did feel good enough to provide a light backing track for Mike Walsh’s weekly call on Friday.

    20200330_132716

    My Animals

    This dog is amazing. Her name is Azure, and she loves playing fetch. She drops balls, scraps of paper, and twigs at my feet on a regular basis, asking for them to be thrown so she can chase them.

    She’s a beautiful reminder of the joy of simple things, and of simple pleasures.

    20200330_131106

    My Charging Stand

    I built this.

    20200330_151009

    I cut two pieces of wood, got them to fit together, and stained them. I’ve dropped my phone on this for 3 or 4 years. Last year I moved to wireless charging and didn’t use this as much, but over my sabbatical I routed out a hole for a wireless charger (thanks, @United) and then plugged it in. Now, I can drop my phone here and it charges.

    This is beautiful to me, a useful thing I made. It’s not perfect, it’s not something anyone else would want, but it’s beautiful to me.

  • Learn SSIS and ADF for Free

    It’s not from SQLServerCentral, though I hope to do more training across the next few months.

    Andy Leonard is offering Free Training for People Who Have Lost Their Jobs. This is Andy’s gift to the community for those that are struggling. This isn’t an open class, and you do need to email Andy, but this is a great offer.

    There are a number of classes upcoming:

    08-09 April 2020: SSIS Administration
    13-14 April 2020: SSIS Data Flows
    27-30 April 2020: From Zero to SSIS
    11-12 May 2020: Expert SSIS
    13 May 2020: Master the SSIS Catalog
    14 May 2020 – Master the Fundamentals of Azure Data Factory

    If you’re struggling, if you’re looking for work and want to gain some skills without a big investment, take advantage of this offer.

  • Next Person Up

    I have a friend that has had a lot of success in technology. This person was a consultant when I met them, working hourly as I was. Over the last few decades, they have found new opportunities and joined a few large corporations. Eventually this person became a vice president, managing a division. It’s an impressive job, with a big salary, lots of travel and perks, and a lot of work.

    I had dinner with this person recently and they lamented all the hours and stress that comes from a high profile job. Working lots of hours, constantly in touch with others, and pushed to do more. In some sense, this person felt their situation wasn’t that  different than some IT jobs they’d had in the past, though with less pay but similar hours.

    I thought about that for myself. I’ve certainly worked 100 hour weeks while on salary. I’ve slept with a beeper on my chest while on call because I knew it would go off multiple times at night and I’d shut it off quickly without waking my wife. I’ve had the stress and pressure of management pushing and pushing.

    I’ve learned to say “no” quite well in my career. I’ve also learned to find another job when I felt abused. It’s worked well for me, and I think it’s the better way to handle things. That being said, I have never made a huge salary, certainly not anything close to what my friend makes. At the same time, I haven’t felt trapped in a long time, and when I did feel trapped in the past, it was my fault. Usually I learned to move on fairly quickly.

    The thing to remember is that you have to ensure your work and your compensation make sense for you. The trade has to feel fair, because many organizations don’t care if you don’t. I’ve not met many companies that would let me work half as much for half pay, even if I cut some benefits. They aren’t set up to adapt there, and they usually have options.

    For every great job, or at least any well paid job, there are often plenty of other people willing to do the job. For employers that don’t value individuals, either you deal with it, or they will remove you and pick someone else. The higher you go into the org chart, the more true this is, and often this is where the sociopathic tendencies of some executives take over.

    I wouldn’t judge anyone else for choosing their situation, but I do caution you to think about what jobs you take and make the conscious decision to do them. Don’t let yourself get caught into a bad situation, which can sometimes be easy to do, especially when a larger paycheck is dangled. Pick the work that suits you and your family and that you enjoy doing each day.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.