Author: way0utwest

  • The Most Wanted Upgrade

    I replaced the case on my desktop recently, though not without a few struggles. A damaged motherboard in the move, and then a DOA replacement caused me a bit of a headache while troubleshooting. Fortunately, I was able to get a few minutes with Glenn Berry to find the issues. Things are back up and running now, which is good. I like my desktop and I’m more comfortable doing most of my work there.

    The process got me thinking about upgrades, especially when I got a look at Glenn’s newest machine. He hasn’t published details, but he did post a few results for his Intel Optane 900p PCIe cards. He also dropped a picture on Twitter of his Threadripper CPU. That’s quite a Task Manager display for a desktop workstation. I don’t know that I need that much power, but it’s still impressive and exciting. Seeing a recent picture of Andrew Kelly’s 38″ 4K monitor for his new workstation has me drooling a little, even though I don’t really need more hardware.

    It’s Black Friday, and while I doubt many of you are out shopping for yourselves, I do wonder if there are upgrades that you’d be excited to get. If someone were to gift you some computer hardware, what would you want? It could be hardware or software, desktop, mobile, whatever type of upgrade you’d want. Let me know today what you wish someone would give you for a present.

    I’m not an enthusiast. I think my son spent almost as much on his video card upgrade as I did for a motherboard, CPU, and RAM. However, I did get a little excited in looking at the various options in the Denver Microcenter store last week. From 3D printers to CPU water coolers to fancy video cards, I was tempted by no shortage of high end hardware. I don’t really need anything, and even passed on adding RAM to my desktop. 32GB works great for me, and while I might squeeze a touch more performance out of another 16 or 32, I don’t really need it.

    I am tempted by a set of larger, high resolution monitors. The idea of a couple of large, 38″ monitors that would spread work across my desk is tempting. Probably overkill and silly, but enticing. If I were to really dream about some upgrade, I’d like to get some faster internal 3D storage for my system. I hate waiting for programs to start, and getting some faster internal NVMe storage to replace a legacy 1TB HDD and get my system moving quicker.

    At heart, I’m a practical computer user, but I can appreciate the effort that some people put into build their systems. I’m just not sure that I’d want any of the fancy RGB lighting or as many cores in my video card as I have in my CPU. I’m also quite pleased with my mobile devices, so I don’t want an upgrade there, though I wish I could get a device with a different (bigger) battery.

    You might feel different and perhaps you can change my mind today. What cool upgrades would you make if cost were not an issue?

    Steve Jones

    The Voice of the DBA Podcast

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

  • Thankful

    It’s been a long career for me. In fact, I’ve been a SQL Server data professional for 17 years, just over half my life and almost the entire lifetime of the product.

    In that time, I’ve worked for a number of companies in different positions. Some were good jobs, some were less good. Some lasted quite a awhile, some were short term engagements.

    No matter how the experience ended, I find myself thankful for each position that continued to move me forward in my career. Even the tough experiences were ones that taught me something that was valuable later on.

    I’m also very thankful that I had the support of my wife, both emotionally and with her own career. That gave me the freedom to try new positions and even start my own business. I’m thankful that I haven’t had any major health issues, nor has my family. That certainly made it easy to focus on my career.

    I’ve had a great life and tremendous opportunities. On this day of thanks, it’s worth reflecting a bit on what has gone your way in life. I do think about this often, but I certainly am happy to take a few minutes and note that there is an abundance of things for me to be thankful for on most days.

  • Finding #dbatools #PowerShell commands

    I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

    I was reading about Pester from Rob Sewell and saw he talked about a new command I hadn’t seen in dbatools: Find-DBACommand. This is a fantastic idea, and I think it’s my new favorite dbatools command, err, cmdlet.

    This is the search cmdlet for dbatools. With this, I can pass in a parameter of something I’m looking at and get results. For example, if I run this with “attach”, I get:

    2017-11-16 08_58_34-cmd - powershell (Admin)

    If I use “security” I get:

    2017-11-16 09_00_15-cmd - powershell (Admin)

    These are the ways that I’d most often use the command, but I can certainly do other things. There are tags on some cmdlets, so I can do this: Find-DbaCommand –Tag job

    2017-11-16 09_03_31-cmd - powershell (Admin)

    This gets me less results than just a search for the string “job”, and these are items focused on jobs themselves.

    I can loo for specific authors with the –Author parameter. I can also look for minimum or maximum versions of SQL Server, though I haven’t found anything that returns here in quick testing. In looking through some help and source code for other commands, I don’t see version tags, but hopefully that comes over time (Submit your PRs here).

    This is a fantastic addition, and certainly better than trying to search all of PoSh help for something like Backup. I might get way more commands I don’t care about there.

    If you haven’t tried dbatools, do it today. It’s a fantastic administration tool for your toolbelt.

  • The Pressure to Perform

    I’ve worked as a technical person for most of career. I’ve often been responsible for building or managing systems, and ensuring they operated according to some set of requirements. If things didn’t work, I’d have to fix them, but often there wasn’t the threat of losing employment unless I was grossly incompetent. If I made a strong effort, I’d get other another chance, or maybe be shuffled to work on some other application or system.

    Throughout my career, I have worked with various salespeople in different companies. Either they were my customers/clients or they were just co-workers. However, they operated under a different mindset. Most salespeople are expected to make a certain amount of sales in a time period, and if they don’t, they may be let go. In fact, in quite a few companies, a salesperson couldn’t miss their target more than two time periods in a row without finding themselves out of a job.

    I realize that sales isn’t like the creative work that developers do, or the tedious work of managing systems, but what if we were treated like salespeople? Do you think you’d want to work in an environment where you had some quantifiable measurement, such as uptime for a quarter, plus tickets closed, and if you couldn’t meet the goals, you’d be let go from your DBA position?

    Imagine if you were a developer. You might have the demand that you meet the expectations for delivery and you are held accountable for estimates within some amount of variance. Perhaps as a developer there would be a requirement to complete xx amount of stories in some time period. I don’t this would work well. I think we’d try to make longer estimates and more granular stories to better define out work, but I’d also expect the business might press back and put more pressure on us.

    In plenty of organizations, there are these pressures. I certainly see developers working harder to get things done, not because of the threat of their job, but because many of us that choose technical work feel a sense of pride and responsibility in the work we do. We work long hours to meet deadlines, sometimes because we’re afraid not to, but usually we do want to complete our projects in the best way we can.

    I think we’d all be worse if we were treated like salespeople, and likely many of us would have more job changes. I also think our organizations would suffer more, with higher turnover and a lack of detailed institutional knowledge among those that build systems. Certainly some high performers might thrive, especially if we received large bonuses, like salespeople often do, but I also think we’d find shoddier work overall, with applications even more cobbled together with patches and prayers, with the hopes that our workload doesn’t overwhelm our systems.

    I know I wouldn’t like working in that type of environment, and why I’m not sure I’d ever want to go into any sales role.

    Steve Jones