How to Use SQL to Analyze the Bitcoin Blockchain
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
2023-09-08
3,155 reads
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
2023-09-08
3,155 reads
As a data professional, I have some fun with data in my life. I like numbers, and I like tracking things. I've written posts about my year in numbers, and recently noted the states I've visited. Like many of you, I've sometimes used this data to practice a skill, maybe learn to ETL or query […]
2023-07-14
2,354 reads
Too much data, especially for some data analysis isn't good for diversity of any product domain.
2023-04-12
132 reads
2022-03-25
444 reads
2022-03-11
420 reads
2022-02-25
437 reads
How do you decide what data is important when doing machine learning?
2021-11-13
222 reads
Data can enhance the experience our client's have with software.
2021-09-03
105 reads
The ability to analyze lots of data on a workstation can be a way to test things without overloading server systems until you are sure your code works.
2020-08-25
119 reads
A significant part of product development is A/B testing. Simply put, this is where companies and product managers test to see a new version of their product versus the older one to make sure it’s worth publishing their features to the entire user base. In order to do this, an A/B test needs to be set […]
2020-04-20
3,006 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers