Voice of the DBA

Category: Editorial

  • Evaluating Life at Work

    One of the more interesting things that we do at Redgate is regularly ask workers to evaluate their environment. We use a company, called Thymometrics, and periodically employers as asked to rate various factors, both in terms of how important are they to us, and how satisfied are we. I tweeted the general dashboard, but essentially there are a series of sliders we use to rate things, between a max and min. No scale, just a visual choice of are things more or less important. Am I more of less satisfied.

    The range is factors are here:

    • Work Environment
    • Wellbeing
    • Salary
    • Benefits
    • Culture and Values
    • Giving Something Back
    • Leadership
    • My Manager
    • Personal Growth
    • Recognition
    • Redgate’s Purpose
    • My Team
    • My Role

    When I log in, I can see how I last set things. I can also reset everything to the middle and re-evaluate how I view the world. Usually I look through and see if I want to change my satisfaction. Rarely do I think that some part of my job situation has changed in importance. However, at least once a year I do reset things and start over.

    While I know plenty of people see this as a pain in the sitting part of the body to go through, I appreciate it. This lets me evaluate how I feel about my job situation, and about my company. I get to think for a few minutes about whether I am truly satisfied with my position and how I am treated by this organization.

    This is a somewhat formalized process. I checked with the team that looks at this and they get anonymized rollup of data, unless someone puts in a comment and asks for a reply. Even then, they don’t send the raw data to managers, but attempt to mediate if there are issues. It’s a good idea, and really, this is what I do and recommend for others.

    At least once a year I take a serious look at my employment situation, in conjunction with how my personal life is going and think about what I like and don’t. I think about my other options, and discuss this with my wife. Is this the best way to live my life? So far it has been every year, since I think I have one of the best jobs out there. That doesn’t mean I should assume there aren’t other options or ways that I might want to change my job.

    I think you should do the same thing yourself, at least once a year. Honestly evaluate your situation, ask others about theirs, and make the best decision for you. After all, you only get one chance to go through this life. If it’s not working, plan to make a change.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Why Billing Will Be Part of Our Job

    I am old enough to remember when many large corporations implemented chargebacks. Essentially, each internal department was charged for their usage of IT systems, similar to how we are charged in the cloud. It was a mess, and individual departments had to answer for excessive charges. I don’t know that any department ever lost service, but their shared of the IT budget was certainly discussed in management meetings.

    These days more and more of us are going to move systems to the cloud, and some of those systems moved will be databases. We may not move all our systems, but we will move some, and the ongoing cost of those systems is something that we will periodically be asked to justify. In the past, we rarely dealt with billing, usually just when specifying and procuring new hardware or requesting a VM.

    Moving forward, I can see us spending time every quarter, or likely every year, analyzing the resources we are paying for and then determining if we are overspending.

    Or, if you’re proactive, perhaps you’ll start looking at costs and performance, as Brent did, and try to write better code to reduce your outlay every month by more efficiently using resources. Have you built in-efficient designs? Are you pulling back too much data with SELECT * from a table or view? Are you building code that recreates the N+1 problem?

    We’ve known for years that writing good code to interact with databases can prevent scale problems and overloaded hardware, even with large workloads. Many case studies over the years show SQL Server backing extremely large databases and busy workloads. Multi-TB databases with thousands of concurrent clients are common these days, and often we find that workloads at clients would easily be run on existing hardware with some better code.

    For some of us, the refocus on the cost of systems may give us some help in pushing developers to write better code from the beginning, learn to use efficient patterns and avoid anti-patterns, and perhaps even get more time to tune systems. However, those are skills that many of us need to improve, learning how to find code that can be improved, and what techniques to use to do so. We have lots of articles that help, as to Brent Ozar, Erik Darling, sqlSkills and others. There are lots of ways to improve your skills, and they can help improve your bottom line. If you work on them.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Other IDEs

    Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us database options with Visual Studio, VS Code, and Azure Data Studio. It does seem as though Microsoft would prefer more of us move to ADS, but I’m not sure I’m ready, and I wonder if you are.

    I saw a list recently of some other tools, and I wonder if anyone uses these in their work. Most of these are cross platform, and support a number of different database platforms. Datagrip might be the most popular, but there are others. SQL Manager, Adminer, DBVis, SQLPro, and Flyspeed are ones I’ve heard of in the past. I’ve used DBArtisan at one company, and loved it as I could work disconnected. At the time, Query Analyzer didn’t support offline work.

    Having an IDE that you are comfortable using is important to working efficiently. Many of us become quite used to the flow of our tool, we develop habits, muscle memory, and shortcuts that work for us. We get used to where things appear on the screen and what icons to click. Changing IDEs can be very disruptive and frustrating while you get used to a new interface. I still remember going from Enterprise Manager to SSMS and it was an annoying period of a few months as I got used to SSMS.

    These days I find myself trying ADS often, but usually falling back to SSMS. I think that visually the basic HTML-like display is annoying. I have much preferred the thick client look at SSMS. It doesn’t help that some of the tools I often use don’t quite work the same in ADS. If we get a bit more of SQL Prompt in there, I might change my mind, but using the Command Palette rather than keyboard shortcuts is somewhat unfamiliar to me. What’s strange is that I like VS Code overall, and use it for PoSh, but for some reason it’s not the same with databases.

    I am glad we have choice in tooling, though I don’t know that any large set of users actually use anything more than what is installed with SQL Server. I don’t know if other tools will allow anyone to produce more, or better, code, but I do know that I have found that some tools do help. It can be worth spending a bit of time experimenting with some other IDE to see if your work improves.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Making a Donation to PASS

    This year the PASS Summit will be virtual, though not free. Until June 19, the conference will cost $500 for the 3 day conference, $900 with precons, and $349 for a single pre-con. SQL Bits is still scheduled for September, and I wonder if they will move to virtual. Microsoft has moved all events to virtual for the next year, which puts pressure on others. The flip side is Microsoft events are mostly marketing and many other events are fundraisers for their organizations.

    PASS reopened their call for speakers, which is interesting. I wouldn’t expect any speakers to pull out from the event, but perhaps I’m wrong. Or maybe they’re expanding the schedule, since I know time zones will be an issue and I suspect we’ll see some broadcasting across the 24 hour clock. To do this isn’t free, as the infrastructure and coordination of staff to make an event happen cost money. Microsoft can just lose money on staff, but for PASS, SQL Bits, and other events, they need help. Even with volunteers helping, you need some staff. Staff requires money.

    This means the request from PASS this year is for every speaker to essentially donate their time to create a presentation and deliver it for little to no compensation. They can watch other talks for free, there will likely be some speaker gift, and there is some marketing and exposure from speaking at the Summit, but this is different than getting an admission to the live event. I don’t know how employers, clients, etc. view anyone’s speaking experience at the Summit, but it’s on my speaking CV multiple times and I’m proud that I’ve been able to speak there.

    I didn’t submit earlier this year when the call for speakers opened. The timing was bad for me, personally, and I decided to forego attending. When the call re-opened, I decided to submit. I am happy to support the community, and a virtual event means that travel and timing is less of a factor.

    I have seen some speakers question whether being asked to deliver a talk for free that will be behind a paywall is a good idea. They question if this is a fair trade for their time and effort. I think each speaker can make their own decision. I don’t mind if you speak, or if you decide this isn’t for you. It is a fair question, and there are plenty others we can debate: the financial structure of PASS, the decisions about the Summit, and the future direction of the organization.

    PASS already had a deficit in their budget this year. The Summit will likely generate less money and potentially the deficit will be larger. If I can donate a few tens of hours to build a session and deliver it, and help with the financials of PASS, I am happy to do so. I plan to support a few other events later this year as well, helping organizers where I can to weather this difficult time.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.