The Vast Expansions of Hardware
Voice of the DBA
At the recently, one of the talks looked at hardware advances. It was interesting to see a data perspective on hardware changes, as many of us only worry about the results of hardware: can I get my data quickly? In or out, most of us are more often worried about performance than specs. However, today I thought it might be fun to look at a few changes and numbers to get an idea of how our hardware has changed, in the march towards dealing with more and more data. Big data anyone? In thinking about disks, I saw a chart that looked at the changes from HDD (hard disk drives) to SDD (solid state...
info_outline
The Modern Algorithm of Chance
Voice of the DBA
These days algorithms rule much of the world. From how supply chains are managed to how vehicles run their engines to the media that many of us watch on the various streaming services. I assume that most of you know that algorithms drive what you see on social media, on YouTube, and even the search results you get, and what you see might be different than what I see. There is a constant search for a perfect, or at least, very targeted way of getting you what you want. Or at least what the algorithm thinks you want. However, is that the best way for algorithms to be designed? It is for the...
info_outline
The Role of Databases in the Era of AI
Voice of the DBA
I'm hosting a webinar tomorrow with this same title: The Role of Databases in the Era of AI. and you'll get some other perspectives from Microsoft and Rie Merritt. However, I think this is an interesting topic and decided to try and synthesize some thoughts into an editorial today, partially to prep for tomorrow and partly because I'm fascinated by AI and how it will be used in the future. Read the rest of
info_outline
Everything is Code
Voice of the DBA
with this quote: “The content updates had not previously been treated as code because they were strictly configuration information.” This is to a US Congressional committee in trying to explain how they grounded much of the airline industry a few months ago. That was a mess of a situation, and apparently, the vendor didn't think their configuration was part of their code. That's an amazing viewpoint to me. The fact that any developer or manager thinks that their configuration data isn't a part of their code is worth testing. Yet, I see this attitude all the time, where developers, QA,...
info_outline
Keep. It. Simple.
Voice of the DBA
I get a tech newsletter most days, which has news that I enjoy, but interspersed among the news and ads are projects, frameworks, or repos, most of which I've never heard of before. I used to read these, but it seems that there is an endless list of these, which all have marketing descriptions that somehow claim this set of code solves problems that others don't or that this code is easy to use and integrate with, or well, I don't know what other promises. I'm usually turned off by the end of the first sentence. The thing I've noticed is that there are so many projects out there. Even in the...
info_outline
The Load of Real Time Data Warehouses
Voice of the DBA
If you have a data warehouse, what do you think your ratio of reads to writes is on any given day? Do you think 1:1, as in one read for each write? Is it 10:1, with 10 reads for each write? 100:1? Do you track this in any way? One would think that most of the databases we work on in the transactional world have many more reads than writes. I'd have assumed the ratios might be higher for data warehouses, where we load data that is queried (read) as the primary use case. After all, I expect that there are lots of people querying data that is loaded into this warehouse, with relatively few...
info_outline
Where's the Printer Friendly Option?
Voice of the DBA
When is the last time you read an article/blog/etc. on the Internet and saw a button for a print friendly version? That used to be something on every page, and one people often shared on social media (or email) because it didn't have all the advertisements in it. I remember having to help code this feature on SQL Server Central when we started as plenty of people wanted to print articles out and read them later. That desire led to Andy brainstorming that we should release The each year. I was reading about how the Internet has changed many things in our lives and I thought about these links....
info_outline
Cleaning Up Your Database
Voice of the DBA
How many of you have objects in your database that aren't being used? What about something in a schema with a _old in the name? Or _2 or _3 or _delete? There is a lot of old, deprecated stuff I see in production databases. In fact, I've been somewhat amazed as I work with clients that many of the scripts we can build from a database with SQL Compare won't actually execute on an empty database because the script is full of broken code. I also find plenty of DBAs that want to clean things up, but they don't. Sometimes they're afraid they'll break something, which is certainly possible. Sometimes...
info_outline
Effective Engineering
Voice of the DBA
I'm not the smartest developer or DBA. I find myself mystified at times by and I'm amazed at times by the complex systems that I see the put together. I can usually figure things out (sometimes by asking the authors a question), but it's not always easy to do. We have some truly gifted, incredibly intelligent people in this business. I am, however, effective. I have been very successful in my career at getting things done well enough, things that work well, meet the needs of my client/employer, and meeting deadlines. I don't just slap things together, but think about them, build them, test...
info_outline
Dead To Me
Voice of the DBA
I saw a note from someone recently that reminded me of . This was (is?) a technology in SQL Server that I thought might have great potential. I even had a few presentations on the subject, but sadly I've rarely seen anyone implement it. I'm sure some do, but I think for me, this is dead technology. There have been other tech items from which I've been turned off or abandoned over the years. It seems in SQL Server, we have some tech that even Microsoft has abandoned and doesn't put any development resources into improving. Read the rest of
info_outlineMost of the people I know who speak at a SQL Saturday or user group aren't paid for their efforts. At many of the community events, the speakers are volunteering their time. Many are also paying for their own way to those events not located in their area. A few, such as me, might get a company to cover their travel expenses, but often this doesn't include time. If I attend a SQL Saturday, I still have a bunch of work on M-F that needs to be done. No comp time for these events. That being said, I'm happy to donate some time and money to community events.
Some speakers build and teach full-day sessions, usually called pre-conference sessions, for which they are paid. There can be competition at large events like the PASS Data Community Summit and SQL Bits to get a session since the payment can be rewarding. I've seen some speakers make USD$1k or so, which can cover travel expenses, and others make over USD$10k, which is a nice payday.
Read the rest of The Costs and Rewards of Speaking