Fun Stuff Around Hardware This Week

Learning Leads To Learning

I am an amateur radio operator. In the US this is commonly referred to as a ham, or a ham radio operator. My call sign is KC1KCE, as issued by the US government through the FCC. And yeah, I can hear you now, a ham is the geek equivalent of a cross-fitter. How do you know someone is a cross-fitter. 'Cause they already told you about it. Hams are kind of the same.

This week I really drilled down on a bunch of stuff with my radios. I have a Raspberry Pi with a transceiver hat (an attachment that goes on top of the Pi, like a hat) that I use as a hotspot for DMR (Digital Mobile Radio). I added functionality for System Fusion, a second digital radio mode to my Pi. I also set up my HF (high frequency) radio to work with a local repeater on 6 Meters (what's known as a band, in this case frequencies between 50 and 54 MHZ). I took part in several nets (on air meetings) using several different radio modes.

Yes, I hear that too. What's all this have to do with databases?

While the time I spend figuring out and implementing these technologies doesn't immediately help me deploy better with Azure DevOps or understand how to capture query metrics in PostgreSQL, it does help me practice good troubleshooting skills. I make backups of my radio's programming (yeah, you can do that, and yeah, you REALLY need to run backups on your radios, just like your databases). I manage code the same way I would if it were database structures. Further, figuring out how to work the OS on the Pi translates back into work I do in containers, working with SQL Server on Linux and other stuff like that.

In short, learning about my radios helps me learn about databases. Learning about databases helps me learn about my radios. Learning helps you to learn better. Learning better helps you learn more. To a large degree, your brain is a muscle. Use it or lose it.

Grant Fritchey

Join the debate, and respond to the editorial on the forums

An overview of the challenges of database testing and test data management, reviewing the different types of database test that need to run during development work, what sort of test data they require, and how to manage all the required data sets, during development, in a way that allows rapid cycles of parallel testing.

Once data is inserted into a table, data typically needs to be maintained as time goes on. To make changes to an existing row or a number of rows, in a table, the UPDATE statement is used. This article shows how to use the UPDATE statement to modify data within a SQL Server table.

In this article I’m going to go over the different types of indexes and some index behaviors. We’ll get into what the indexes are, how they work, and how best you can apply them within your databases.

If you create server aliases for SQL Server connec...

Learn about SQL Server schemas and how to use them...

In SQL Server, an index is a data structure that a...

This month's #tsqltuesday is an especially interes...

What is the difference between Always On Clustered...

This week’s T-SQL Tuesday comes from Raul Gonzal...

Learn how to download, install and configure SQL S...

+OK

Your log is not a jerk The post Logs Do Not Care About Your Feelings or Emotions appeared first on SQLHA.

In this article, we look at how to resolve the issue of an Always On Availability Group database not synchronizing and how to fix this issue.

SAS' Sylvia Kabisa shows you how an online media c...

One of the things that I’ve gotten used to with ...

The new enhancements released in Backup center ena...

SQL Insights for Azure SQL Db allow you to have a quick look into the resource usage of your Azure SQL Resource in a graphical way, but when we...

It is not the first time, that we used to have this type of service requests that our customers reported slow connections in an Elastic Database Pool. Following I...

We found today an out of memory exception raised by SQL Server Management Studio exporting a database. This exception may occurs because, for performance improvement the export process, this process...

You can now create Azure Synapse Runtime for Apach...

In the episode of Data Exposed with Anna Hoffman and Lior Kamrat, we will be talking about how to get started with Azure Arc-enabled data services, the newly announced...

Further fueling fears of a coming recession, Amazo...

Reading Time: 4 minutes I want to cover recommend...

Today we have launched Data Céilí (pronounced ka...

Happy New Year! As we kick off 2023, I wanted to t...

Sure, rightsizing VM instances will save money, but there are other cloud cost optimization strategies that can bring you greater cloud savings and even save you time and technical...

Consider these four differences between AWS, Azure, and GCP before choosing one of the "Big Three" public clouds.

In this blog post, I will show you how to create a...

Microsoft has released yesterday the January 2023 ...

Data science teams are no longer comprised of tiny...

The two people who shut down four Washington power...

"I want to kick things off with a super important ...

I have an anxiety disorder and 24 years ago when I...

When we talk to prospective customers, their first questions are usually around the fundamentals of data quality, including what it is, how we measure it, what happens when it...

Use the Azure Automation extension to perform local authoring and management of automation runbooks using VS Code

First, I apologize. I apologize because I intentio...

Extract, transform, load (ETL) is the process of extracting data from various sources, transforming it through various methods, and loading it into a data warehouse or data lake. Some...

Ryan Lambert thinks about software development: Qu...

The latest camera from Raspberry Pi brings autofoc...

+OK

Learn about G-Code and how we can write our own cu...

When Greg unboxed a new Roomba robot vacuum cleane...

Gavin Strange's neon infused Raspberry Pi powered ...

Exciting portable monitors from Asus, and ViewSoni...

In a recent episode of Tom's Hardware: The Pi Cast...

Open-source technologies will become even more pro...

Ryan Booz thinks about Database DevOps: At the cor...

This post looks at how to set up a PostgreSQL cont...

The cryptomining malware, which typically targets ...

Grant Fritchey provides an overview: In this artic...

Rob Farley cautions against rash decisions on thre...

Learn how to build SQL Server indexes using key an...

In case you’re working in an international compa...

ABSTRACT As chatbots become more prevalent in ...

In this article, we will learn how to create Power...

Welcome to 2023, I am looking forward to an amazin...

The entire dbForge for SQL Server product line from Devart was updated. Now all the dbForge add-ins support SSMS 19 Preview 4, and the dbForge Studio can also be run on Linux and macOS.

Updates to Azure SQL Database, SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.42.0). You can download the MPs from the links below. Majority of the...

This article intends to cover a few tips for creat...

For the past 22 years, we’ve been publishing an ...

I really, really miss speaking at in-person user g...

Sometimes we all need a little help without a long...

If you’ve decided to make some changes this year...

Traditional metrics don't reflect real-world sever...

The Serbian government reports that it staved off ...

School to resume Thursday, Jan. 12, after Iowa sch...

Security tool sprawl is a challenge that organizations of all sizes contend with today. Explore the factors that contribute to tool sprawl and how to get your house in...

The LockBit allegedly targeted the Royal Mail and used encryption to lock some of its computers.

A security vendor's investigation of infrastructur...

Corsha’s Annual State of API Secrets Management ...

With the release of ChatGPT, I’ve read many random articles about this or that threat from the technology. This paper is a good survey of the field: what...

Learn how to use SQL Server or Oracle as the backend database for a simple .Net Core Web Application.

Writing new code = bugging. That part’s easy. Ta...

Not that I’m looking to do this, but that’s th...

Happy T-SQL Tuesday! It’s the first one of 2023 ...

For T-SQL Tuesday #158, I talk about a couple of j...

A SQL Server inner join is a type of join that com...

This tip drills down on how to process JSON files with SQL Server and demonstrates an approach for extracting key values from JSON nested key-value pairs.

A common table expression, also known as a CTE, is a temporary named result set in SQL that can be used within a SELECT, INSERT, UPDATE, or DELETE statement....

Time series capabilities in SQL Server were introduced in Azure SQL Edge, Microsoft's version of SQL Server for the Internet of Things. The post Working with time series data...

Today, I am going to explain how to use the SQL LIMIT clause to limit output values. We all know RDBMS systems are one of the popular ways to...

Microsoft is reportedly planning to integrate Open...

Microsoft's latest update to the Windows Subsystem...

Consideration of how to deploy technology responsi...

With artificial intelligence poised to displace ma...

This article is from The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. This week, a sore throat and...

Ronald Rael and Virginia San Fratello may have met...

I came across an issue with SSMS not loading prope...

Previously the only way to run SQL Server on Apple Silicon was via QEMU emulation or Colima (hat tip to Anthony Nocentino). Docker released beta support today for Apple’s...

Organizations must be vigilant about balancing per...

A quick demonstration of using Flyway with Oracle, for those of a nervous disposition. We'll use Flyway to run some migrations on an Oracle Autonomous Database, building the initial...

In a previous post, I got Flyway installed as a CL...