Voice of the DBA
A series of episodes that look at databases and the world from a data professional's viewpoint. Written and recorded by Steve Jones, editor of SQLServerCentral and The Voice of the DBA.
info_outline
Protecting Off Hours
03/17/2024
Protecting Off Hours
to allow employees to protect themselves from unreasonable calls and emails from work during off-hours. You can read more about it, but a bill was passed to allow employees to ignore calls and messages without repercussion It is expected to pass, though I don't expect this to do a lot for bad bosses. They'll find ways to hint or imply that you need to respond, and might even remove your chances of advancement/promotion/raises. While you can sue, that rarely works out well for anyone. From the various reports I've seen, I'm not sure if this includes salaried workers or just hourly workers. I certainly think hourly workers ought to be paid if they're called after hours. I've even been paid as a salaried worker if the calls outside of core hours exceeded a certain amount per week. That seemed fair to me, and in our team, there was always someone willing to work more for extra money, so I could trade on-call work if I didn't want to do it. Read the rest of
/episode/index/show/voiceofthedba/id/30395423
info_outline
Growing Skills at Work
03/14/2024
Growing Skills at Work
Redgate released the results of their recently, and I was part of . As we were talking, one of the things that struck me was the high number of people who had picked skills as being a challenge for their organization. In a single environment, , and it was listed as . While this industry is full of self-taught individuals who have spent time learning new technologies and tools, it's somewhat amazing that training continues to be an issue. Many organizations limit their training budgets and time allocated to employees while continuing to expand the number of technologies and platforms they use. This is one reason why I think changing database platforms to avoid licensing costs is unlikely to save you money anytime soon. Retraining staff and developing competence takes time. Perhaps this is also one reason why many companies look to the cloud, thinking that they can reduce the amount of upskilling needed by their staff if the cloud vendor manages the systems. Read the rest of
/episode/index/show/voiceofthedba/id/30241258
info_outline
Navigating the Database Landscape
03/12/2024
Navigating the Database Landscape
The title of our keynote session at the is Navigating the Database Landscape, and I'll be delivering part of the talk, along with Grant Fritchey and Kathi Kellenberger today, Mar 13. This is based on the , as well as our experience working with customers and implementing DevOps solutions over the last decade. The talk was mostly written by others, but as I rehearsed the session, I found myself wondering about how I'd approach my job if we returned to being a DBA or developer. When working in technology today, there are many challenges outside of actually learning about any of the particular products, languages, platforms, etc. We have the politics of working with others, ongoing work, emergency requests outside of channels, random questions asked by others, code reviews, and probably a few other things I'm forgetting, all outside of learning any new skills. While I consider myself a lifelong learner, I know that finding time (and energy) to acquire the basics of any new technology is challenging. Read the rest of
/episode/index/show/voiceofthedba/id/30241033
info_outline
Is This a Good DBA Job Description?
03/08/2024
Is This a Good DBA Job Description?
I saw this on one of the syndicated SQL Server Central blogs: . This is mostly a list of things, but it covers a lot of the general types of things that many of us expect a DBA to do. However, my question is whether you think this is a good description for a job opening. Would you ask someone to fill this list of things? Maybe a better question is whether you could use this to evaluate candidates, and how would you go about asking questions or gauging a fit based on this. Perhaps you should ask yourself how you evaluate others and if there is a good way to rate them against a list of daily tasks. Read the rest of
/episode/index/show/voiceofthedba/id/30240873
info_outline
Assistants in the Age of AI
03/06/2024
Assistants in the Age of AI
When I started working for a living, there were secretaries in many organizations. These were people who actually did a lot of correspondence (written or verbal) and busy work for managers or executives. Over time, as email and computers became commonplace on desks, I saw fewer of these positions. As more people started to send email, we had to actually alter software to allow assistants to impersonate their bosses and manage the volume of communications that many of us deal with. We're in a new age of assistants with the emergence of Generative AIs powered by LLMs that can appear to respond in a conversational style to requests and perform actions on our behalf. In this new era, will AIs function as old-style secretaries, handling simple, but important tasks? Are they the trusted helpers that secretaries used to be for many executives? Are we all going to have an assistant, and do we want one, or need one? Read the rest of
/episode/index/show/voiceofthedba/id/30170893
info_outline
Creating Candidate Interest
03/04/2024
Creating Candidate Interest
It can be hard to find candidates for positions these days. I know there are a lot of people looking for jobs, but are they the ones you want? Are they a good fit for your team? Those are hard questions to answer when culling through resumes, conducting phone screens, and sitting in interview rooms asking questions from a template. What can be even harder is to compare different candidates when multiple people may interact with the candidates. Even if you do all the work, you're busy. Can you make good comparisons of different individuals that you've spoken to across a few weeks, in between all the real work you're trying to get done? I know I've struggled to do this, no matter how many notes I take or how long the discussions are with other team members. I have had a very mixed bag of success in hiring. Read the rest of
/episode/index/show/voiceofthedba/id/30056948
info_outline
Using AI for Security
03/01/2024
Using AI for Security
AI (Artificial Intelligence) systems and technology has been all over our industry for the past year or so, ever since ChatGPT released the initial public version in late 2022. It seems that there is a lot of hype around the possibilities, with plenty of excitement and skepticism, depending on who is talking about the tech. However, there do seem to be some places where the technology is working well, and security is one of them. There is , which seemed to have run rampant a few years ago. It's still around, though it seems fewer exploits are being publicized. That might be because systems are better protected, perhaps there are fewer attacks (unlikely), or maybe more organizations are getting better at covering up their issues. They might be better prepared to restore backups or quicker to pay a ransom. Read the rest of
/episode/index/show/voiceofthedba/id/30115903
info_outline
The Art of the Code Review
02/28/2024
The Art of the Code Review
The inspiration for this was a piece about . Throughout my career, I've seen code reviews grow and change. From formal meetings to automated notifications and asynchronous discussions to complete lip service to the process. I'd like to think that most organizations are beyond the latter and there is some sort of review beyond the developer, but I still see a lack of other eyes looking at code before it's deployed, especially database code. The article above opens with the idea of why we review code. The main reason is to create ownership, or more specifically, shared ownership. I had never thought of it in these terms, even though I think the ideas of standards and patterns are certainly shared items. Having everyone take ownership not only keeps quality high but could help you share knowledge and also ensure everyone feels a responsibility to safeguard all the code. This also helps everyone keep an eye on the larger picture of the entire codebase. Read the rest of
/episode/index/show/voiceofthedba/id/30115753
info_outline
The Dangers of Not Upgrading
02/26/2024
The Dangers of Not Upgrading
About ten years ago my sister-in-law broke the screen on her mobile phone. She'd had an older iPhone and when she went to upgrade, none of the upgrade processes worked because her OS was so far behind that they couldn't transfer her information smoothly. She had been avoiding OS updates because they interrupted her life, but that was now a problem because the world had marched so far beyond her version that there weren't tools, or at least, no one was interested in trying to perform an upgrade across multiple OS versions (I think it was 3 or 5 versions). I ran into this recently with someone else I knew, but not for a mobile phone. For TFS 2015. This customer had been working along with this older system and is finally ready to upgrade to Azure DevOps in the cloud. They wanted to know if they could somehow upgrade the TFS database and move all that data easily into the cloud. I said this wasn't likely easy as this isn't an upgrade, but an export and import of a lot of data. Microsoft offered a path, but it was multiple upgrades before an export/import, which was deemed too expensive. Right now, I'm not sure what they're doing to do. Read the rest of
/episode/index/show/voiceofthedba/id/30056838
info_outline
Free SQL Server
02/23/2024
Free SQL Server
No, I don't have a way to license a SQL Server instance for your application for free. Microsoft still charges for production workloads. However, there are several ways that you can do development or testing for free, or at a greatly reduced cost. Bob Ward spent a bit of time researching options and he's written . It's very comprehensive and I know a lot of us are grateful to Bob for summarizing our options. As I work with developers in organizations, there are often questions about the licensing for dev editions. This comes up more with Oracle than other platforms, but SQL Server does get asked about. We made a decision to support SQL Server Developer Edition in , which is in line with what Bob's post above says: this edition is for developers (and it's free). There is one caveat here, which I never knew. The licensing guide says you cannot build test data and move that into production. I'm assuming this doesn't mean you can't create a list of US states, countries in the world, or statuses. I think this means something more substantial, but if anyone knows, let me know. Read the rest of
/episode/index/show/voiceofthedba/id/29991633
info_outline
Visual Design for Safety
02/21/2024
Visual Design for Safety
I drive a Tesla Model Y and love it. They're not for everyone and not for every situation, but I think it's the best car I've owned. My wife feels the same way, and if we had a need for two cars, we'd likely get another one. The car is fun, and I look forward to getting in and moving around town. If you have questions about owning an EV or a Model Y, please feel free to ask. The car isn't perfect, and there are things I wish I could change. There have also been a few recalls on the car, which is interesting for a Tesla. A few of these recalls meant that I got a software update a few days or weeks later and something changed. There was , which affects most Tesla vehicles in the US. I'm sure that by the time you read this, I'll have a software update applied and the issue will be resolved. Read the rest of
/episode/index/show/voiceofthedba/id/29991553
info_outline
Am I Good At My Job?
02/16/2024
Am I Good At My Job?
I was talking with a friend recently about some of their co-workers. In this case, they were complaining that another person couldn't do some tasks that my friend considered relatively easy things. Deal with an unusual restore situation, write some PowerShell to reconfigure servers, build somewhat complex (to them) queries, etc. Things that my friend thinks most database people should be able to do after a year of experience. However, my friend questioned whether they were evaluating co-workers appropriately. How can one tell? I might be able to tell if a coworker is better or worse at a task, but what's my frame of reference and my experience. I might think them not capable at things I do well. At the same time, I can be wowed by someone with more experience with a technology I don't know well, such as Azure Data Factory, but not really be able to judge if they're average or an expert. Read the rest of
/episode/index/show/voiceofthedba/id/29957568
info_outline
This is Why You Use Git for Scripts
02/14/2024
This is Why You Use Git for Scripts
Git has become a fantastic tool for me, and many other technologists, over the last ten years. It's almost ubiquitous in most of my clients, and so many people are comfortable with it. Many others aren't, which is why I started a (and other Ops people) on my blog. Quite a few people asked me why I recommend git over a file share for storing code that a team of Ops people or DBAs might use. Why isn't a global file share a better choice in an organization? I think I have a few good reasons, but if you disagree, let me know in the discussion for this piece. Read the rest of
/episode/index/show/voiceofthedba/id/29880423
info_outline
Un-Stable Teams
02/12/2024
Un-Stable Teams
I've always valued having a team of people I know and can work with. While I haven't had a lot of long-term jobs before Redgate, I have had a few positions that lasted more than a year and appreciated working with the same group for a long time. We might gain or lose a person, but overall, the structure of the team was the same day after day. This was a comfortable atmosphere, and I liked knowing who I was working with each day. At Redgate, we have had some stable teams of people, but in our engineering area, we move teams around. There is each December/January where engineers can choose to leave their team and ask to transfer to another one. They get to put in their top three choices (or remain on their team), and we do a good job of trying to match up everyone's preferences. The number and charter of teams do change a bit each year, so engineers get visibility into the structure we're planning before they mark a preference. It seems from our internal reports that we match up 99% of engineers with their first or second choices (first choice is in the high 80s). Read the rest of
/episode/index/show/voiceofthedba/id/29833153
info_outline
Do You Have a Jeff?
02/09/2024
Do You Have a Jeff?
In the (worth a read), there is a character called Brent, who is to go-to person for everything in IT. I don't know if this character was modeled after , but I always picture him when I re-read the book, and I suspect he was that person in previous positions. I've been that person as well, and it's both exciting, fulfilling, and very stressful. At , that person has been Robert C, who is my go-to person for many questions. In the DBA world, I think of . He's been a prolific and incredible author over the years on many things SQL-related and is a huge proponent of others learning to write better code and better utilize the database platform more efficiently. I suspect in his company, he is the go-to person for most database-related questions and problems. I also suspect he solves most of them very well and has the influence (or power) to effect change. Read the rest of
/episode/index/show/voiceofthedba/id/29833008
info_outline
Ranomware vs. AI
02/07/2024
Ranomware vs. AI
Ransomware has been a growing and shrinking problem in the modern world. Every time I think that some new defenses and protections are preventing ransomware from being a problem, I see another issue. Recently, I saw with an attack and a few friends have recently noted their companies were restoring systems after a portion of their network was locked down. With the advent of Rasnsomware-as-a-service, where criminals deploy software and then sell access to others, better detection and protection become more important. As with any software, criminal human operators will use the ransomware software in different ways. That means that we don't necessarily have a simple threat that can be easily programmed against with anti-virus technology. Read the rest of
/episode/index/show/voiceofthedba/id/29739298
info_outline
Serious Software Glitches
02/05/2024
Serious Software Glitches
Recently pointed out a podcast to me. , but it's for the Journal, which is on other platforms (I listened on Spotify). It's the story of a computer glitch in UK post office software, which resulted in quite a few local postmasters being criminally prosecuted, many convicted, and even a few committing suicide. It's a sad story, and it's complex, but there are some technology-related elements. First, the overall story is Fujitsu sold the UK a point-of-sale system for post offices. There was a computer glitch here, which incorrectly calculated lots of totals and showed postmasters owing more money than they should. They were upset, called support, got nowhere and many were liable for paying money they didn't owe. The UK postal management hid information about the widespread nature of the problem, while prosecuting many local postmasters. Fujitsu support didn't disclose to callers how others were experiencing this same issue. This also coincided with a (an unrelated) law that changed saying computer systems were presumed correct and anyone accused of a crime had to prove the computer was wrong. Read the rest of
/episode/index/show/voiceofthedba/id/29739153
info_outline
How Often Do You Update SSMS?
02/02/2024
How Often Do You Update SSMS?
I got a message recently that SSM S19.3 is out. I am wary of major versions, especially with a few add-in tools, but I have tended to try and update SSMS regularly when it patches, which is about once a quarter. As I checked my desktop, I saw I was still on 19.1 (my laptop was 19.2), so I downloaded and updated both machines. I wonder what the rest of you do. I know many of you have corporate rules and restrictions and you may not be able to update regularly, but in many places, I've worked, once software was installed, I could update it. Are you doing the same thing out there? Let us know in the comments, or better yet, include the version you are running. Read the rest of
/episode/index/show/voiceofthedba/id/29465668
info_outline
Mind Over Milkshake (Thoughts Matter)
01/31/2024
Mind Over Milkshake (Thoughts Matter)
Last year I went to in Wisconsin. It was a fun event, very community and family-friendly, and I enjoyed it. So much so that I recently went back to the Texas event in January. It's more developer-focused, but it does have some data related sessions. I recommend this conference if you're looking for some fun training and want to combine that with a family vacation. Your kids will love it. In any case, I watched a keynote talk that referenced an NPR article, called . It's an interesting look at how the food labels affected people's bodies. It's not definitive and I wouldn't make any drastic changes based on this, but it is an interesting read on the idea your mind and thoughts can influence your body. I've heard about the effect of placebos in the past, we well as attitude on healing, so this makes some sense. Read the rest of
/episode/index/show/voiceofthedba/id/29636593
info_outline
A Great Place to Work
01/26/2024
A Great Place to Work
I have had quite a few employers in my career. Of the ones that paid me for computer work, I'll say that there were 3 great ones (1 I owned), 2 average ones, and 3 poor ones. I've had a few other minor times or contract situations where I didn't really judge or care one way or the other. A lot of time is spent at work, but if it's days/week/(few months), I can deal with most situations. That being said, even at the poor places, I learned a lot and I grew, so I don't regret them or wouldn't want them removed from my past. There are always good and bad things about any job. As I tell my kids, every job is a job some days, even my amazing position at Redgate. Recently my employer, Redgate Software, was on a number of Best Places to Work lists in the US. We took 28th in the US (5th in Austin, 4th in LA, 10th in NY) with higher rankings when you filtered to mid-sized businesses. While I don't work in those places, I do go to our offices, and I think we have an amazing culture, workplace environment, support, and training for staff. We're a mid-sized company now with a bit over 500 people, which is amazing. I was person 146, but I've known the company since it was 8 people. As it's grown, I think Redgate has done a great job under Simon Galbraith's leadership of building a place to work that is productive and profitable, but enjoyable and interesting. Our current CEO, Jakub Lamik, has continued to help Redgate thrive, both as a business and an employer. Read the rest of
/episode/index/show/voiceofthedba/id/29465588
info_outline
Take A Vote and Accept Your Loss
01/24/2024
Take A Vote and Accept Your Loss
I feel differently today than in the past about many of the things I've seen technical people argue about. I've written about and , and others have debated commas before or after among other topics. While these might be interesting sidebars at lunch, I see them sometimes devolve into time sinks with teams revisiting the issues over and over during their daily work. These stifle a lot of productivity and often can linger for years. However, in many cases what I see is debate across weeks or months and then time spent to shift the way that large groups of people work inside of a company. In the last few years, I've seen customers argue about which VCS to use, which new CI tool to choose, or even about which secret store to use for their database credentials. Read the rest of
/episode/index/show/voiceofthedba/id/29465468
info_outline
Hire Well
01/22/2024
Hire Well
In the last few years, I've noticed that the quality of technical workers can vary quite a bit in many organizations. I think most people get things done, but often not at a high-quality level. It's one reason that I write, speak, and try to motivate more of you to work on your skills and your career. I want to see better software being built. I tend to work with more database developers than application developers and I tend to see more SQL code than C#/Java/etc. And I see a lot of poorly written SQL Code and poor data models that seem to have been built without a lot of thought put into them. Whether this is because of ignorance or just poor skills is hard to know, but I see a lot of code that makes me slightly cringe. Read the rest of
/episode/index/show/voiceofthedba/id/29465218
info_outline
Learning NoSQL
01/17/2024
Learning NoSQL
It's a good idea to learn more about different technologies. I've been amazed throughout my career, and even now as someone working for a software vendor, how many different technologies I run into. I'm also amazed at how little bits of knowledge comes in handy, either to help me understand a problem or to help guide others with a recommendation of how to proceed. Many of us have experience with relational databases and tabular data. We are comfortable with it, even if we might struggle with a or using a . However, do you understand how a NoSQL database might be different? Can you even name a few types of NoSQL databases? Read the rest of
/episode/index/show/voiceofthedba/id/29417673
info_outline
Portable Data Storage
01/15/2024
Portable Data Storage
I saw , and it got me thinking about local storage. Over the holidays I needed to scan something from a device at the ranch, but to get the image to my computer, I needed a flash drive. It took me 10 minutes of searching around to find one because I rarely use them anymore. In fact, I couldn't remember the last time I'd used one for a transfer between computers. I just send stuff through OneDrive/DropBox/GDrive or some other mechanism. Today I'm wondering if the rest of you have abandoned using portable storage or if is it something you find useful. How often do you use portable storage in your life? Apart from laptops or mobile phones, I'm wondering about portable disk drives or any device where you transfer data using a wire rather than wirelessly. Note, I'm not talking about going from one computer to another on a wired network. I mean moving the storage from one place to another with your hands. Read the rest of
/episode/index/show/voiceofthedba/id/29417558
info_outline
Continuity Across Restarts
01/12/2024
Continuity Across Restarts
There are a lot of database platforms, and . As Brent points out in that link, sometimes they just skip comparing themselves to other platforms because it makes them look better. They only look at the platforms they compete well against. For most of us, we often just need basic CRUD operations. I know that most RDBMS platforms would work for us, and sometimes NoSQL ones work as well, though I think that NoSQL isn't necessarily better for many applications (maybe most). You may feel differently, but that's my view. While I use SQL Server, I think the majority of systems I've managed or built could easily run on MySQL, PostgreSQL, or many other platforms. Read the rest of
/episode/index/show/voiceofthedba/id/29363278
info_outline
Re-evaluating the Cloud
01/10/2024
Re-evaluating the Cloud
Last year (makers of and ) announced they were leaving the cloud. I , and wondered if they'd look back at this as a great decision or one they'd regret and backtrack to the cloud again. They planned to build their own tooling, buy a bunch of servers, and run their own data center (or rather, rent space in someone's data center). Recently there was an update, in , about how the transition has gone. In short, very well. One of the founders, David Heinemeier Hansson answered several questions about the move and the financial status. They didn't hire more people, so their payroll is the same. They used a service to unpack and rack their servers, so they could just connect to them remotely and not deal with hardware. They built their own redundancy across two data centers where they rent space, and they think they will save well over $7 million in the next 5 years. They had a $3.2million cloud budget per year, so that appears to be halved (3x5=15 - 7 = 8ish) with their move. Read the rest of
/episode/index/show/voiceofthedba/id/29348353
info_outline
Advice for Business
01/08/2024
Advice for Business
During the last few months, I've seen a few different advice posts that caught me eye. One was Kevin Kelley's blog (and ) on life advice that , I look at the book once a week or two, read 1-2 items, and think about them. I think some of them are geared more for younger people growing into life, but quite a few are still things that I appreciate as learnings or reminders. Recently I ran across another one, looking back from a business point of view. I've worked in business for a long time, used to own one, and I tend to enjoy smaller businesses than larger ones. While I enjoyed my time at JD Edwards, I prefer companies with a few hundred people rather than 10,000 or more. Read the rest of
/episode/index/show/voiceofthedba/id/29330043
info_outline
Projects To Showcase Your Skills
01/05/2024
Projects To Showcase Your Skills
It seems I've heard from a lot of people looking for jobs lately. I had a friend reach out and when I posted a note on LinkedIn I had someone looking for a job, I heard from a few dozen others that they were in the same situation. The last year has seen a lot of turnover in IT. There have been lots of big (and small) companies that have let staff go, for a variety of reasons. The why doesn't matter to you if you've lost employment. You just need a new job. At the same time, I hear from lots of customers and friends that they are struggling to find good talent. They have openings, but none of the people interviewing have good skills. Read the rest of
/episode/index/show/voiceofthedba/id/29275268
info_outline
Fixing Poor Programming Practices
01/03/2024
Fixing Poor Programming Practices
I see a lot of poor programming practices in real-world code. I'm sure I've written a few myself. I'm also sure that many of you see the same thing and sometimes wonder how that code got deployed. One of the things I told myself over the last few years was that I had to accept the reality of situations. It's easy to complain and say that code should be written differently or entities should be modeled in another way, but I (or you) can't change that situation today. And it ignores the fact that we are stuck with this environment and we have to move forward from here, not try to rewind the clock and go back in time to design things better at the start. Read the rest of
/episode/index/show/voiceofthedba/id/29275223
info_outline
Advice To Be a Better Person
09/14/2023
Advice To Be a Better Person
As a hobby, I coach volleyball for kids. Each year I meet new kids and parents and talk about my philosophy. Part of that is that I teach skills, athletics, how to compete, and more. However, I do emphasize as well that I'm trying to build better people, not just athletes. I want these kids to be better prepared for life, for job interviews, for future teachers and coaches, and for better relationships. While I'm not perfect, or maybe not even a great person, I do try to improve myself on a regular basis. Or at least learn to be a better person to others. This isn't because of any ideal or goal, but because life is more fun when I have more skills. Whether that's working with objects or interacting with people. The smoother things go, the more I enjoy the world. Read the rest of
/episode/index/show/voiceofthedba/id/27874899