SteemSQL SSMS simple install guide

SteemSQL is a publicly available Microsoft SQL database, it should contain all the Steem blockchain data. Very valuable information, if you know how to write SQL.

This post will guide you through the setting up DBsteem in Server Management Studio, and get you started querying.

First download SQL Server Management Studio (SSMS) aprox 800 MB
Run SSMS as administrator.

Use these credientials

Login Steemit
Pass Steemit

Check trust server certificate

Now you should be connected and able to write a query...

Lets do a test

SELECT TOP (100) [ID]
,[tx_id]
,[type]
,[from]
,[to]
,[amount]
,[amount_symbol]
,[memo]
,[request_id]
,[timestamp]
FROM [DBSteem].[dbo].[TxTransfers]
order by amount desc

I use top 100 to reduce the load time, and i order by desc to get the highest amount first.

You should get something like this