Tracking Table Sizes
Voice of the DBA
info_outline
The Job Outlook for Database Professionals
Voice of the DBA
This is a strange time for many technology professionals and their employment. It seems many organizations have open positions and are struggling to fill those slots with qualified candidates (). At the same time, many other organizations have followed the large technology firms (FAANG, MSFT) and in the last year. At the same time, with the hype and rapid growth of GenAI systems, we have companies that are looking to machines to fill some of their labor needs. as their plan was to use AI tech to help them write enough code. They've seen productivity gains with AI tech, so they aren't adding...
info_outline
A Poor Data Model
Voice of the DBA
Recently there was some online complaints about social security numbers (SSNs) in the US being duplicated and re-used by individuals. This is really political gamesmanship, so ignore the political part. Just know that social security numbers appear to be one of the contenders used in many data models. I found about how SSNs aren't unique, and have a mess of problems. Despite this, many people seem to want to use SSNs as a primary or alternate key in their database systems. They also aren't well secured in many systems, even though we should consider this sensitive PII data. Read the rest of
info_outline
Your Biggest Data Model Complaints
Voice of the DBA
I've been working with databases for a long time and there are no shortage of things I've seen other people do that I don't like. Sometimes I shake my head a little. Sometimes I might groan inwardly (hopefully not aloud), and sometimes I might make an effort to convince someone else to do something differently. Sometimes I'm really annoyed (or angry) and don't even know what to do. Read the rest of
info_outline
Why Not Use AI?
Voice of the DBA
Erin Stellato, a program manager at Microsoft, : "why do you *not* want a Copilot in SSMS?" That got me to stop and think a minute. Why don't we want to use an AI to help us? It's a good question, given the hype and (maybe) potential of the technology. While it might not help you now, or with your specific thing, it might help others, so are there good reasons not to use AI technologies, like the GenAI LLMs? Read the rest of
info_outline
Trust is a Funny Thing
Voice of the DBA
I caught and there was a point in the article where trust was mentioned. Specifically the reasons that people distrust an AI or tech tool is that it makes a mistake, so they stop using it. A few examples of this were using a writing AI that made a grammar mistake or a GPS routing device that added a wrong detour. In those cases the humans stopped using the assistance of the algorithm because they felt it wasn't trustworthy. What's fascinating to me is that I had this same conversation with a human the day before. Someone mentioned they were working with a group and they misstated something....
info_outline
Moving On After a Technology Fail
Voice of the DBA
info_outline
Is Ransomware Fading?
Voice of the DBA
info_outline
How Much Linux Do You Need?
Voice of the DBA
info_outline
The End of Azure Data Studio
Voice of the DBA
I don't know how many of you will be disappointed or impacted by this, but Azure Data Studio (ADS) is being retired, as of 6 Feb, 2024. It will be supported for a little over a year, until 28 Feb, 2026. On one hand I'm not surprised, and on the other, I'm a little shocked by this. I have written , and shown how things work, as well as pointed out a number of things that don't work well in the product or its extensions. These pieces have gotten a number of reads, and people have commented on them, so I wonder if there are a lot of you that are upset by this. Is this going to change the way you...
info_outlineI almost called this "chasing a new laptop" since that's what I'm doing, but I decided to add the date because the current laptop I've using was built in March 2019 and got to me in May 2019. I've had an HP Spectre x360, my second HP Spectre, and I've really enjoyed it. I'm also amazed it still runs. On the last few trips, the two rubber strips that run along the bottom (acting as feet) started to peel away. I've never seen that before and I tried to re-attach them a few times, but that didn't work well.
Not a big deal, and I can live with that, but then during my Australian tour, the laptop started pausing and freezing a few times. It might be that there is too much software on there and needs a pave-and-reinstall, but I decided to check the age on the machine. That was when I realized it was five years old. It's been a great machine, but I don't think I've ever had a work laptop last that long with daily use. Of course, there was about a year during the pandemic when it was rarely used, so maybe its life lengthened during COVID.
Read the rest of Five Years and Counting